RMYY_CallCenter_Api/RMYY_CallCen.../T_WowoRepair...

using System;
using System.Data;
using System.Data.SqlClient;
using System.Reflection;
using System.Text;
using RMYY_CallCenter_Api.DB;

namespace RMYY_CallCenter_Api.Dal
{
    public   class T_WowoRepair_Basedal
    {
        /// <summary>
        /// 是否存在该记录
        /// </summary>
        public bool Exists(string T_Wowocodeid)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(1) from T_WowoRepair_Base ");
            strSql.Append(" where T_Wowocodeid=@T_Wowocodeid");
            SqlParameter[] parameters = {
                    new SqlParameter("@T_Wowocodeid", SqlDbType.Int,4)
            };
            parameters[0].Value = T_Wowocodeid;

            return DbHelperSQL.Exists(strSql.ToString(), parameters);
        }

        #region 添加
        /// <summary>
        /// 增加一条报修工单数据
        /// </summary>
        public int Addrepair(RMYY_CallCenter_Api.Model.T_WowoRepair_Base model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into T_WowoRepair_Base(");
            strSql.Append("T_Wowocodetype,T_Wofrindpid,T_Wowocodestate,T_Wowocodecenter,T_Wocreaterepairman,T_Worepairman,T_Worepairmanphone,T_Worepairdate,T_Worepairyqid,T_Worepairdeptid,T_Worepairaddress,T_Woimageid,T_Wotousercode,T_Wotousertime,T_Wodealrepairman,T_Wodealdesmo,T_Wodealtime)");
            strSql.Append(" values (");
            strSql.Append("@T_Wowocodetype,@T_Wofrindpid,@T_Wowocodestate,@T_Wowocodecenter,@T_Wocreaterepairman,@T_Worepairman,@T_Worepairmanphone,@T_Worepairdate,@T_Worepairyqid,@T_Worepairdeptid,@T_Worepairaddress,@T_Woimageid,@T_Wotousercode,@T_Wotousertime,@T_Wodealrepairman,@T_Wodealdesmo,@T_Wodealtime)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@T_Wowocodetype", SqlDbType.Int,4),
                    new SqlParameter("@T_Wofrindpid", SqlDbType.Int,4),
                    new SqlParameter("@T_Wowocodestate", SqlDbType.Int,4),
                    new SqlParameter("@T_Wowocodecenter", SqlDbType.NVarChar,100),
                    new SqlParameter("@T_Wocreaterepairman", SqlDbType.NVarChar,100),
                    new SqlParameter("@T_Worepairman", SqlDbType.NVarChar,100),
                    new SqlParameter("@T_Worepairmanphone", SqlDbType.NVarChar,100),
                    new SqlParameter("@T_Worepairdate", SqlDbType.DateTime),
                    new SqlParameter("@T_Worepairyqid", SqlDbType.Int,4),
                    new SqlParameter("@T_Worepairdeptid", SqlDbType.Int,4),
                    new SqlParameter("@T_Worepairaddress", SqlDbType.NVarChar,100),
                    new SqlParameter("@T_Woimageid", SqlDbType.Int, 4),
                    new SqlParameter("@T_Wotousercode", SqlDbType.Int,4),
                    new SqlParameter("@T_Wotousertime", SqlDbType.DateTime),
                    new SqlParameter("@T_Wodealrepairman", SqlDbType.Int,4),
                    new SqlParameter("@T_Wodealdesmo", SqlDbType.NVarChar,100),
                    new SqlParameter("@T_Wodealtime", SqlDbType.DateTime)};
            parameters[0].Value = model.T_Wowocodetype;
            parameters[1].Value = model.T_Wofrindpid;
            parameters[2].Value = model.T_Wowocodestate;
            parameters[3].Value = model.T_Wowocodecenter;
            parameters[4].Value = model.T_Wocreaterepairman;
            parameters[5].Value = model.T_Worepairman;
            parameters[6].Value = model.T_Worepairmanphone;
            parameters[7].Value = model.T_Worepairdate;
            parameters[8].Value = model.T_Worepairyqid;
            parameters[9].Value = model.T_Worepairdeptid;
            parameters[10].Value = model.T_Worepairaddress;
            parameters[11].Value = model.T_Woimageid;
            parameters[12].Value = model.T_Wotousercode;
            parameters[13].Value = model.T_Wotousertime;
            parameters[14].Value = model.T_Wodealrepairman;
            parameters[15].Value = model.T_Wodealdesmo;
            parameters[16].Value = model.T_Wodealtime;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }

        /// <summary>
        /// 增加一条派单数据
        /// </summary>
        public int Addrepairsend(RMYY_CallCenter_Api.Model.T_Wowo_repair_send model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into T_Wowo_repair_send(");
            strSql.Append("T_Wowocodeid,T_Wousername,T_Wouserphone,T_Worepairmanphone,T_Wocreatetime)");
            strSql.Append(" values (");
            strSql.Append("@T_Wowocodeid,@T_Wousername,@T_Wouserphone,@T_Worepairmanphone,@T_Wocreatetime)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@T_Wowocodeid", SqlDbType.Int,4),
                    new SqlParameter("@T_Wousername", SqlDbType.NVarChar,100),
                    new SqlParameter("@T_Wouserphone", SqlDbType.NVarChar,100),
                    new SqlParameter("@T_Woreparicenter", SqlDbType.NVarChar,100),
                    new SqlParameter("@T_Wocreatetime", SqlDbType.DateTime)};
            parameters[0].Value = model.T_Wowocodeid;
            parameters[1].Value = model.T_Wousername;
            parameters[2].Value = model.T_Wouserphone;
            parameters[3].Value = model.T_Woreparicenter;
            parameters[4].Value = model.T_Wocreatetime;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }

        /// <summary>
        /// 增加一条工单流程数据
        /// </summary>
        public int Addrepairitems(RMYY_CallCenter_Api.Model.T_Wowo_repair_items model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into T_Wowo_repair_items(");
            strSql.Append("T_Wowocodeid,T_Woplaycenter,T_Wocreatetime)");
            strSql.Append(" values (");
            strSql.Append("@T_Wowocodeid,@T_Woplaycenter,@T_Wocreatetime)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@T_Wowocodeid", SqlDbType.Int,4),
                    new SqlParameter("@T_Woplaycenter", SqlDbType.NVarChar,100),
                    new SqlParameter("@T_Wocreatetime", SqlDbType.DateTime)};
            parameters[0].Value = model.T_Wowocodeid;
            parameters[1].Value = model.T_Woplaycenter;
            parameters[2].Value = model.T_Wocreatetime;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
        /// <summary>
        /// 上传一张工单图片
        /// </summary>
        public int Addrepairimg(RMYY_CallCenter_Api.Model.T_Wowo_repair_img model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into T_Wowo_repair_img(");
            strSql.Append("T_Wofilename,T_Wofileurl)");
            strSql.Append(" values (");
            strSql.Append("@T_Wofilename,@T_Wofileurl)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    //new SqlParameter("@T_Wowocodeid", SqlDbType.Int,4),
                    new SqlParameter("@T_Wofilename",SqlDbType.NVarChar,100),
                    new SqlParameter("@T_Wofileurl", SqlDbType.NVarChar,100),};
            //parameters[0].Value = model.T_Wowocodeid;
            parameters[0].Value = model.T_Wofilename;
            parameters[1].Value = model.T_Wofileurl;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
        /// <summary>
        /// 评价
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int Addrepairevaluate(RMYY_CallCenter_Api.Model.T_Wowo_repair_evaluate model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into T_Wowo_repair_evaluate(");
            strSql.Append("T_Wowocodeid,T_Woscore,T_Woevaluate,T_Wolabel,T_Wocreateuser,T_Wocreatetime)");
            strSql.Append(" values (");
            strSql.Append("@T_Wowocodeid,@T_Woscore@T_Woevaluate@T_Wolabel,@T_Wocreateuser,@T_Wocreatetime)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@T_Wowocodeid", SqlDbType.Int,4),
                    new SqlParameter("@T_Woscore", SqlDbType.Int,4),
                    new SqlParameter("@T_Woevaluate",SqlDbType.NVarChar,100),
                    new SqlParameter("@T_Wolabel", SqlDbType.NVarChar,100),
                    new SqlParameter("@T_Wocreateuser", SqlDbType.NVarChar,100),
                    new SqlParameter("@T_Wocreatetime", SqlDbType.DateTime) };
            parameters[0].Value = model.T_Wowocodeid;
            parameters[1].Value = model.T_Woscore;
            parameters[2].Value = model.T_Woevaluate;
            parameters[3].Value = model.T_Wolabel;
            parameters[4].Value = model.T_Wocreateuser;
            parameters[5].Value = model.T_Wocreatetime;
            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
        #endregion
        #region 修改
        /// <summary>
        /// 更新一条报修工单数据
        /// </summary>
        public bool Updaterepair(RMYY_CallCenter_Api.Model.T_WowoRepair_Base model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update T_WowoRepair_Base set ");
            strSql.Append("T_Wowocodetype=@T_Wowocodetype,");
            strSql.Append("T_Wofrindpid=@T_Wofrindpid,");
            strSql.Append("T_Wowocodestate=@T_Wowocodestate,");
            strSql.Append("T_Wowocodecenter=@T_Wowocodecenter,");
            strSql.Append("T_Worepairman=@T_Worepairman,");
            strSql.Append("T_Worepairmanphone=@T_Worepairmanphone,");
            strSql.Append("T_Worepairdate=@T_Worepairdate,");
            strSql.Append("T_Worepairyqid=@T_Worepairyqid");
            strSql.Append("T_Worepairdeptid=@T_Worepairdeptid");
            strSql.Append("T_Worepairaddress=@T_Worepairaddress");
            strSql.Append("T_Woimageid=@T_Woimageid");
            strSql.Append("T_Wotousercode=@T_Wotousercode");
            strSql.Append("T_Wotousertime=@T_Wotousertime");
            strSql.Append("T_Wodealrepairman=@T_Wodealrepairman");
            strSql.Append("T_Wodealdesmo=@T_Wodealdesmo"); 
            strSql.Append("T_Wodealtime=@T_Wodealtime");
            strSql.Append(" where T_Wowocodeid=@T_Wowocodeid");
            SqlParameter[] parameters = {
                    new SqlParameter("@T_Wowocodetype", SqlDbType.Int,4),
                    new SqlParameter("@T_Wofrindpid", SqlDbType.Int,4),
                    new SqlParameter("@T_Wowocodestate", SqlDbType.Int,4),
                    new SqlParameter("@T_Wowocodecenter", SqlDbType.NVarChar,100),
                    new SqlParameter("@T_Worepairman", SqlDbType.NVarChar,100),
                    new SqlParameter("@T_Worepairmanphone", SqlDbType.NVarChar,100),
                    new SqlParameter("@T_Worepairdate", SqlDbType.DateTime),
                    new SqlParameter("@T_Worepairyqid", SqlDbType.Int,4),
                    new SqlParameter("@T_Worepairdeptid", SqlDbType.Int,4),
                    new SqlParameter("@T_Worepairaddress", SqlDbType.NVarChar,100),
                    new SqlParameter("@T_Woimageid", SqlDbType.Int, 4),
                    new SqlParameter("@T_Wotousercode", SqlDbType.Int,4),
                    new SqlParameter("@T_Wotousertime", SqlDbType.DateTime),
                    new SqlParameter("@T_Wodealrepairman", SqlDbType.Int,4),
                    new SqlParameter("@T_Wodealdesmo", SqlDbType.NVarChar,100),
                    new SqlParameter("@T_Wodealtime", SqlDbType.DateTime),
                    new SqlParameter("@T_Worepairyqid", SqlDbType.Int,4)};
            parameters[0].Value = model.T_Wowocodetype;
            parameters[1].Value = model.T_Wofrindpid;
            parameters[2].Value = model.T_Wowocodestate;
            parameters[3].Value = model.T_Wowocodecenter;
            parameters[4].Value = model.T_Worepairman;
            parameters[5].Value = model.T_Worepairmanphone;
            parameters[6].Value = model.T_Worepairdate;
            parameters[7].Value = model.T_Worepairyqid;
            parameters[8].Value = model.T_Worepairdeptid;
            parameters[9].Value = model.T_Worepairaddress;
            parameters[10].Value = model.T_Woimageid;
            parameters[11].Value = model.T_Wotousercode;
            parameters[12].Value = model.T_Wotousertime;
            parameters[13].Value = model.T_Wodealrepairman;
            parameters[14].Value = model.T_Wodealdesmo; 
            parameters[15].Value = model.T_Wodealtime;
            parameters[16].Value = model.T_Wowocodeid;

            int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        #endregion
        #region 删除
        /// <summary>
        /// 删除一条数据
        /// </summary>
        public bool Deleterepair(int T_Wowocodeid)
        {

            StringBuilder strSql = new StringBuilder();
            strSql.Append("delete from T_WowoRepair_Base ");
            strSql.Append(" where T_Wowocodeid=@T_Wowocodeid");
            SqlParameter[] parameters = {
                    new SqlParameter("@T_Wowocodeid", SqlDbType.Int,4)
            };
            parameters[0].Value = T_Wowocodeid;

            int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        #endregion
        #region 查询
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public RMYY_CallCenter_Api.Model.T_WowoRepair_Base GetModel(int T_Wowocodeid)
        {

            StringBuilder strSql = new StringBuilder();
            strSql.Append("select  top 1 T_Wowocodeid,T_Wowocodetype,T_Wowocodestate,T_Wowocodecenter,T_Worepairman,T_Worepairmanphone,T_Worepairdate,T_Worepairyqid,T_Worepairdeptid,T_Worepairaddress,T_Woimageid,T_Wotousercode,T_Wotousertime,T_Wodealrepairman,T_Wodealtime from T_WowoRepair_Base ");
            strSql.Append(" where T_Wowocodeid=@T_Wowocodeid");
            SqlParameter[] parameters = {
                    new SqlParameter("@T_Wowocodeid", SqlDbType.Int,4)
            };
            parameters[0].Value = T_Wowocodeid;

            RMYY_CallCenter_Api.Model.T_WowoRepair_Base model = new RMYY_CallCenter_Api.Model.T_WowoRepair_Base();
            DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
            if (ds.Tables[0].Rows.Count > 0)
            {
                return DataRowToModel(ds.Tables[0].Rows[0]);
            }
            else
            {
                return null;
            }
        }
        /// <summary>
        /// 分页获取数据列表
        /// </summary>
        public DataSet GetListByPage(string strWhere, string orderby, int startIndex, int endIndex)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("SELECT * FROM ( ");
            strSql.Append(" SELECT ROW_NUMBER() OVER (");
            if (!string.IsNullOrEmpty(orderby.Trim()))
            {
                strSql.Append("order by T." + orderby);
            }
            else
            {
                strSql.Append("order by T.T_Wowocodeid desc");
            }
            strSql.Append(")AS Row, T.*  from T_WowoRepair_Base T ");
            if (!string.IsNullOrEmpty(strWhere.Trim()))
            {
                strSql.Append(" WHERE 1=1" + strWhere);
            }
            strSql.Append(" ) TT");
            strSql.AppendFormat(" WHERE TT.Row between {0} and {1}", startIndex, endIndex);
            return DbHelperSQL.Query(strSql.ToString());
        }
        /// <summary>
        /// 获取工单流程信息
        /// </summary>
        /// <param name="T_Wowocodeid"></param>
        /// <returns></returns>
        public DataSet Getworderitems(int T_Wowocodeid)
        {
           
            StringBuilder strSql = new StringBuilder();
            strSql.Append("SELECT * FROM  T_Wowo_repair_items ");
            strSql.Append(" where T_Wowocodeid=@T_Wowocodeid");
            return DbHelperSQL.Query(strSql.ToString());
        }

        /// <summary>
        /// 获取派单记录
        /// </summary>
        /// <param name="T_Wowocodeid"></param>
        /// <returns></returns>
        public DataSet Getwordersend(int T_Wowocodeid)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("SELECT * FROM  T_Wowo_repair_send ");
            strSql.Append(" where T_Wowocodeid=@T_Wowocodeid");
            return DbHelperSQL.Query(strSql.ToString());
        }
        /// <summary>
        /// 获取评价信息
        /// </summary>
        /// <param name="T_Wowocodeid"></param>
        /// <returns></returns>
        public DataSet Getworderevaluate(int T_Wowocodeid)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("SELECT * FROM  T_Wowo_repair_evaluate ");
            strSql.Append(" where T_Wowocodeid=@T_Wowocodeid");
            return DbHelperSQL.Query(strSql.ToString());
        }
        #endregion
        #region 得到一个对象实体
        /// <summary>
        /// 得到一个工单对象实体
        /// </summary>
        public RMYY_CallCenter_Api.Model.T_WowoRepair_Base DataRowToModel(DataRow row)
        {
            RMYY_CallCenter_Api.Model.T_WowoRepair_Base model = new RMYY_CallCenter_Api.Model.T_WowoRepair_Base();
            if (row != null)
            {
                #region 主表信息======================
                //利用反射获得属性的所有公共属性
                Type modelType = model.GetType();
                for (int i = 0; i < row.Table.Columns.Count; i++)
                {
                    PropertyInfo proInfo = modelType.GetProperty(row.Table.Columns[i].ColumnName);
                    if (proInfo != null && row[i] != DBNull.Value)
                    {
                        //用索引值设置属性值
                        proInfo.SetValue(model, row[i], null);
                    }
                }
                #endregion
            }
            return model;
        }
        /// <summary>
        /// 得到一个工单流程对象实体
        /// </summary>
        public RMYY_CallCenter_Api.Model.T_Wowo_repair_items DataRowToitemModel(DataRow row)
        {
            RMYY_CallCenter_Api.Model.T_Wowo_repair_items model = new RMYY_CallCenter_Api.Model.T_Wowo_repair_items();
            if (row != null)
            {
                #region 主表信息======================
                //利用反射获得属性的所有公共属性
                Type modelType = model.GetType();
                for (int i = 0; i < row.Table.Columns.Count; i++)
                {
                    PropertyInfo proInfo = modelType.GetProperty(row.Table.Columns[i].ColumnName);
                    if (proInfo != null && row[i] != DBNull.Value)
                    {
                        //用索引值设置属性值
                        proInfo.SetValue(model, row[i], null);
                    }
                }
                #endregion
            }
            return model;
        }
        /// <summary>
        /// 得到一个排单记录对象实体
        /// </summary>
        public RMYY_CallCenter_Api.Model.T_Wowo_repair_send DataRowTosendModel(DataRow row)
        {
            RMYY_CallCenter_Api.Model.T_Wowo_repair_send model = new RMYY_CallCenter_Api.Model.T_Wowo_repair_send();
            if (row != null)
            {
                #region 主表信息======================
                //利用反射获得属性的所有公共属性
                Type modelType = model.GetType();
                for (int i = 0; i < row.Table.Columns.Count; i++)
                {
                    PropertyInfo proInfo = modelType.GetProperty(row.Table.Columns[i].ColumnName);
                    if (proInfo != null && row[i] != DBNull.Value)
                    {
                        //用索引值设置属性值
                        proInfo.SetValue(model, row[i], null);
                    }
                }
                #endregion
            }
            return model;
        }
        /// <summary>
        /// 得到一个评价对象实体
        /// </summary>
        public RMYY_CallCenter_Api.Model.T_Wowo_repair_evaluate DataRowToevaluateModel(DataRow row)
        {
            RMYY_CallCenter_Api.Model.T_Wowo_repair_evaluate model = new RMYY_CallCenter_Api.Model.T_Wowo_repair_evaluate();
            if (row != null)
            {
                #region 主表信息======================
                //利用反射获得属性的所有公共属性
                Type modelType = model.GetType();
                for (int i = 0; i < row.Table.Columns.Count; i++)
                {
                    PropertyInfo proInfo = modelType.GetProperty(row.Table.Columns[i].ColumnName);
                    if (proInfo != null && row[i] != DBNull.Value)
                    {
                        //用索引值设置属性值
                        proInfo.SetValue(model, row[i], null);
                    }
                }
                #endregion
            }
            return model;
        }
        #endregion
    }
}