示例#1
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public HXD.Model.tb_U_weixin GetModel(int Id)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select  top 1 Id,ClassId,IsTop,IsStatus,IsElite,IsHot,Sort,CreateUsers,CreateTimes,CreateIp,EditUsers,EditTimes,EditIp,FormUserName,ToUserName,MsgType,Msg,Creatime,Location_X,Location_Y from tb_U_weixin ");
            strSql.Append(" where Id=@Id");
            SqlParameter[] parameters =
            {
                new SqlParameter("@Id", SqlDbType.Int, 4)
            };
            parameters[0].Value = Id;

            HXD.Model.tb_U_weixin model = new HXD.Model.tb_U_weixin();
            DataSet ds = HXD.DBUtility.SQLHelper.ExecuteDataset(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                return(DataRowToModel(ds.Tables[0].Rows[0]));
            }
            else
            {
                return(null);
            }
        }
示例#2
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(HXD.Model.tb_U_weixin model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update tb_U_weixin set ");
            strSql.Append("ClassId=@ClassId,");
            strSql.Append("IsTop=@IsTop,");
            strSql.Append("IsStatus=@IsStatus,");
            strSql.Append("IsElite=@IsElite,");
            strSql.Append("IsHot=@IsHot,");
            strSql.Append("Sort=@Sort,");
            strSql.Append("CreateUsers=@CreateUsers,");
            strSql.Append("CreateTimes=@CreateTimes,");
            strSql.Append("CreateIp=@CreateIp,");
            strSql.Append("EditUsers=@EditUsers,");
            strSql.Append("EditTimes=@EditTimes,");
            strSql.Append("EditIp=@EditIp,");
            strSql.Append("FormUserName=@FormUserName,");
            strSql.Append("ToUserName=@ToUserName,");
            strSql.Append("MsgType=@MsgType,");
            strSql.Append("Msg=@Msg,");
            strSql.Append("Creatime=@Creatime,");
            strSql.Append("Location_X=@Location_X,");
            strSql.Append("Location_Y=@Location_Y");
            strSql.Append(" where Id=@Id");
            SqlParameter[] parameters =
            {
                new SqlParameter("@ClassId",      SqlDbType.Int,         4),
                new SqlParameter("@IsTop",        SqlDbType.Bit,         1),
                new SqlParameter("@IsStatus",     SqlDbType.Bit,         1),
                new SqlParameter("@IsElite",      SqlDbType.Bit,         1),
                new SqlParameter("@IsHot",        SqlDbType.Bit,         1),
                new SqlParameter("@Sort",         SqlDbType.Int,         4),
                new SqlParameter("@CreateUsers",  SqlDbType.NVarChar,  200),
                new SqlParameter("@CreateTimes",  SqlDbType.DateTime),
                new SqlParameter("@CreateIp",     SqlDbType.NVarChar,  200),
                new SqlParameter("@EditUsers",    SqlDbType.NVarChar,  200),
                new SqlParameter("@EditTimes",    SqlDbType.DateTime),
                new SqlParameter("@EditIp",       SqlDbType.NVarChar,  200),
                new SqlParameter("@FormUserName", SqlDbType.NVarChar,  200),
                new SqlParameter("@ToUserName",   SqlDbType.NVarChar,  200),
                new SqlParameter("@MsgType",      SqlDbType.NVarChar,  200),
                new SqlParameter("@Msg",          SqlDbType.NText),
                new SqlParameter("@Creatime",     SqlDbType.DateTime),
                new SqlParameter("@Location_X",   SqlDbType.NVarChar,  200),
                new SqlParameter("@Location_Y",   SqlDbType.NVarChar,  200),
                new SqlParameter("@Id",           SqlDbType.Int, 4)
            };
            parameters[0].Value  = model.ClassId;
            parameters[1].Value  = model.IsTop;
            parameters[2].Value  = model.IsStatus;
            parameters[3].Value  = model.IsElite;
            parameters[4].Value  = model.IsHot;
            parameters[5].Value  = model.Sort;
            parameters[6].Value  = model.CreateUsers;
            parameters[7].Value  = model.CreateTimes;
            parameters[8].Value  = model.CreateIp;
            parameters[9].Value  = model.EditUsers;
            parameters[10].Value = model.EditTimes;
            parameters[11].Value = model.EditIp;
            parameters[12].Value = model.FormUserName;
            parameters[13].Value = model.ToUserName;
            parameters[14].Value = model.MsgType;
            parameters[15].Value = model.Msg;
            parameters[16].Value = model.Creatime;
            parameters[17].Value = model.Location_X;
            parameters[18].Value = model.Location_Y;
            parameters[19].Value = model.Id;

            return(HXD.DBUtility.SQLHelper.ExecuteNonQuery(strSql.ToString(), parameters) == 1);
        }
示例#3
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(HXD.Model.tb_U_weixin model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into tb_U_weixin(");
            strSql.Append("ClassId,IsTop,IsStatus,IsElite,IsHot,Sort,CreateUsers,CreateTimes,CreateIp,EditUsers,EditTimes,EditIp,FormUserName,ToUserName,MsgType,Msg,Creatime,Location_X,Location_Y)");
            strSql.Append(" values (");
            strSql.Append("@ClassId,@IsTop,@IsStatus,@IsElite,@IsHot,@Sort,@CreateUsers,@CreateTimes,@CreateIp,@EditUsers,@EditTimes,@EditIp,@FormUserName,@ToUserName,@MsgType,@Msg,@Creatime,@Location_X,@Location_Y)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters =
            {
                new SqlParameter("@ClassId",      SqlDbType.Int,         4),
                new SqlParameter("@IsTop",        SqlDbType.Bit,         1),
                new SqlParameter("@IsStatus",     SqlDbType.Bit,         1),
                new SqlParameter("@IsElite",      SqlDbType.Bit,         1),
                new SqlParameter("@IsHot",        SqlDbType.Bit,         1),
                new SqlParameter("@Sort",         SqlDbType.Int,         4),
                new SqlParameter("@CreateUsers",  SqlDbType.NVarChar,  200),
                new SqlParameter("@CreateTimes",  SqlDbType.DateTime),
                new SqlParameter("@CreateIp",     SqlDbType.NVarChar,  200),
                new SqlParameter("@EditUsers",    SqlDbType.NVarChar,  200),
                new SqlParameter("@EditTimes",    SqlDbType.DateTime),
                new SqlParameter("@EditIp",       SqlDbType.NVarChar,  200),
                new SqlParameter("@FormUserName", SqlDbType.NVarChar,  200),
                new SqlParameter("@ToUserName",   SqlDbType.NVarChar,  200),
                new SqlParameter("@MsgType",      SqlDbType.NVarChar,  200),
                new SqlParameter("@Msg",          SqlDbType.NText),
                new SqlParameter("@Creatime",     SqlDbType.DateTime),
                new SqlParameter("@Location_X",   SqlDbType.NVarChar,  200),
                new SqlParameter("@Location_Y",   SqlDbType.NVarChar, 200)
            };
            parameters[0].Value  = model.ClassId;
            parameters[1].Value  = model.IsTop;
            parameters[2].Value  = model.IsStatus;
            parameters[3].Value  = model.IsElite;
            parameters[4].Value  = model.IsHot;
            parameters[5].Value  = model.Sort;
            parameters[6].Value  = model.CreateUsers;
            parameters[7].Value  = model.CreateTimes;
            parameters[8].Value  = model.CreateIp;
            parameters[9].Value  = model.EditUsers;
            parameters[10].Value = model.EditTimes;
            parameters[11].Value = model.EditIp;
            parameters[12].Value = model.FormUserName;
            parameters[13].Value = model.ToUserName;
            parameters[14].Value = model.MsgType;
            parameters[15].Value = model.Msg;
            parameters[16].Value = model.Creatime;
            parameters[17].Value = model.Location_X;
            parameters[18].Value = model.Location_Y;

            //object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            //if (obj == null)
            //{
            //    return 0;
            //}
            //else
            //{
            //    return Convert.ToInt32(obj);
            //}
            return(HXD.DBUtility.SQLHelper.ExecuteNonQuery(strSql.ToString(), parameters) == 1);
        }
示例#4
0
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public HXD.Model.tb_U_weixin DataRowToModel(DataRow row)
 {
     HXD.Model.tb_U_weixin model = new HXD.Model.tb_U_weixin();
     if (row != null)
     {
         if (row["Id"] != null && row["Id"].ToString() != "")
         {
             model.Id = int.Parse(row["Id"].ToString());
         }
         if (row["ClassId"] != null && row["ClassId"].ToString() != "")
         {
             model.ClassId = int.Parse(row["ClassId"].ToString());
         }
         if (row["IsTop"] != null && row["IsTop"].ToString() != "")
         {
             if ((row["IsTop"].ToString() == "1") || (row["IsTop"].ToString().ToLower() == "true"))
             {
                 model.IsTop = true;
             }
             else
             {
                 model.IsTop = false;
             }
         }
         if (row["IsStatus"] != null && row["IsStatus"].ToString() != "")
         {
             if ((row["IsStatus"].ToString() == "1") || (row["IsStatus"].ToString().ToLower() == "true"))
             {
                 model.IsStatus = true;
             }
             else
             {
                 model.IsStatus = false;
             }
         }
         if (row["IsElite"] != null && row["IsElite"].ToString() != "")
         {
             if ((row["IsElite"].ToString() == "1") || (row["IsElite"].ToString().ToLower() == "true"))
             {
                 model.IsElite = true;
             }
             else
             {
                 model.IsElite = false;
             }
         }
         if (row["IsHot"] != null && row["IsHot"].ToString() != "")
         {
             if ((row["IsHot"].ToString() == "1") || (row["IsHot"].ToString().ToLower() == "true"))
             {
                 model.IsHot = true;
             }
             else
             {
                 model.IsHot = false;
             }
         }
         if (row["Sort"] != null && row["Sort"].ToString() != "")
         {
             model.Sort = int.Parse(row["Sort"].ToString());
         }
         if (row["CreateUsers"] != null)
         {
             model.CreateUsers = row["CreateUsers"].ToString();
         }
         if (row["CreateTimes"] != null && row["CreateTimes"].ToString() != "")
         {
             model.CreateTimes = DateTime.Parse(row["CreateTimes"].ToString());
         }
         if (row["CreateIp"] != null)
         {
             model.CreateIp = row["CreateIp"].ToString();
         }
         if (row["EditUsers"] != null)
         {
             model.EditUsers = row["EditUsers"].ToString();
         }
         if (row["EditTimes"] != null && row["EditTimes"].ToString() != "")
         {
             model.EditTimes = DateTime.Parse(row["EditTimes"].ToString());
         }
         if (row["EditIp"] != null)
         {
             model.EditIp = row["EditIp"].ToString();
         }
         if (row["FormUserName"] != null)
         {
             model.FormUserName = row["FormUserName"].ToString();
         }
         if (row["ToUserName"] != null)
         {
             model.ToUserName = row["ToUserName"].ToString();
         }
         if (row["MsgType"] != null)
         {
             model.MsgType = row["MsgType"].ToString();
         }
         if (row["Msg"] != null)
         {
             model.Msg = row["Msg"].ToString();
         }
         if (row["Creatime"] != null && row["Creatime"].ToString() != "")
         {
             model.Creatime = DateTime.Parse(row["Creatime"].ToString());
         }
         if (row["Location_X"] != null)
         {
             model.Location_X = row["Location_X"].ToString();
         }
         if (row["Location_Y"] != null)
         {
             model.Location_Y = row["Location_Y"].ToString();
         }
     }
     return(model);
 }