Esempio n. 1
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(MxWeiXinPF.Model.wx_sjb_bisai model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into wx_sjb_bisai(");
            strSql.Append("bsPic,bsRemark,rcId,qd1Id,qd2Id,beginDate,endDate,jcBeginDate,jcEndDate,resultType,rType1Times,rType2Times,rType3Times,createDate)");
            strSql.Append(" values (");
            strSql.Append("@bsPic,@bsRemark,@rcId,@qd1Id,@qd2Id,@beginDate,@endDate,@jcBeginDate,@jcEndDate,@resultType,@rType1Times,@rType2Times,@rType3Times,@createDate)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters =
            {
                new SqlParameter("@bsPic",       SqlDbType.VarChar,    800),
                new SqlParameter("@bsRemark",    SqlDbType.VarChar,   2000),
                new SqlParameter("@rcId",        SqlDbType.Int,          4),
                new SqlParameter("@qd1Id",       SqlDbType.Int,          4),
                new SqlParameter("@qd2Id",       SqlDbType.Int,          4),
                new SqlParameter("@beginDate",   SqlDbType.DateTime),
                new SqlParameter("@endDate",     SqlDbType.DateTime),
                new SqlParameter("@jcBeginDate", SqlDbType.DateTime),
                new SqlParameter("@jcEndDate",   SqlDbType.DateTime),
                new SqlParameter("@resultType",  SqlDbType.Int,          4),
                new SqlParameter("@rType1Times", SqlDbType.Int,          4),
                new SqlParameter("@rType2Times", SqlDbType.Int,          4),
                new SqlParameter("@rType3Times", SqlDbType.Int,          4),
                new SqlParameter("@createDate",  SqlDbType.DateTime)
            };
            parameters[0].Value  = model.bsPic;
            parameters[1].Value  = model.bsRemark;
            parameters[2].Value  = model.rcId;
            parameters[3].Value  = model.qd1Id;
            parameters[4].Value  = model.qd2Id;
            parameters[5].Value  = model.beginDate;
            parameters[6].Value  = model.endDate;
            parameters[7].Value  = model.jcBeginDate;
            parameters[8].Value  = model.jcEndDate;
            parameters[9].Value  = model.resultType;
            parameters[10].Value = model.rType1Times;
            parameters[11].Value = model.rType2Times;
            parameters[12].Value = model.rType3Times;
            parameters[13].Value = model.createDate;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);

            if (obj == null)
            {
                return(0);
            }
            else
            {
                return(Convert.ToInt32(obj));
            }
        }
Esempio n. 2
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public MxWeiXinPF.Model.wx_sjb_bisai GetModel(int id)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select  top 1 id,bsPic,bsRemark,rcId,qd1Id,qd2Id,beginDate,endDate,jcBeginDate,jcEndDate,resultType,rType1Times,rType2Times,rType3Times,createDate from wx_sjb_bisai ");
            strSql.Append(" where id=@id");
            SqlParameter[] parameters =
            {
                new SqlParameter("@id", SqlDbType.Int, 4)
            };
            parameters[0].Value = id;

            MxWeiXinPF.Model.wx_sjb_bisai model = new MxWeiXinPF.Model.wx_sjb_bisai();
            DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                return(DataRowToModel(ds.Tables[0].Rows[0]));
            }
            else
            {
                return(null);
            }
        }
Esempio n. 3
0
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public MxWeiXinPF.Model.wx_sjb_bisai DataRowToModel(DataRow row)
 {
     MxWeiXinPF.Model.wx_sjb_bisai model = new MxWeiXinPF.Model.wx_sjb_bisai();
     if (row != null)
     {
         if (row["id"] != null && row["id"].ToString() != "")
         {
             model.id = int.Parse(row["id"].ToString());
         }
         if (row["bsPic"] != null)
         {
             model.bsPic = row["bsPic"].ToString();
         }
         if (row["bsRemark"] != null)
         {
             model.bsRemark = row["bsRemark"].ToString();
         }
         if (row["rcId"] != null && row["rcId"].ToString() != "")
         {
             model.rcId = int.Parse(row["rcId"].ToString());
         }
         if (row["qd1Id"] != null && row["qd1Id"].ToString() != "")
         {
             model.qd1Id = int.Parse(row["qd1Id"].ToString());
         }
         if (row["qd2Id"] != null && row["qd2Id"].ToString() != "")
         {
             model.qd2Id = int.Parse(row["qd2Id"].ToString());
         }
         if (row["beginDate"] != null && row["beginDate"].ToString() != "")
         {
             model.beginDate = DateTime.Parse(row["beginDate"].ToString());
         }
         if (row["endDate"] != null && row["endDate"].ToString() != "")
         {
             model.endDate = DateTime.Parse(row["endDate"].ToString());
         }
         if (row["jcBeginDate"] != null && row["jcBeginDate"].ToString() != "")
         {
             model.jcBeginDate = DateTime.Parse(row["jcBeginDate"].ToString());
         }
         if (row["jcEndDate"] != null && row["jcEndDate"].ToString() != "")
         {
             model.jcEndDate = DateTime.Parse(row["jcEndDate"].ToString());
         }
         if (row["resultType"] != null && row["resultType"].ToString() != "")
         {
             model.resultType = int.Parse(row["resultType"].ToString());
         }
         if (row["rType1Times"] != null && row["rType1Times"].ToString() != "")
         {
             model.rType1Times = int.Parse(row["rType1Times"].ToString());
         }
         if (row["rType2Times"] != null && row["rType2Times"].ToString() != "")
         {
             model.rType2Times = int.Parse(row["rType2Times"].ToString());
         }
         if (row["rType3Times"] != null && row["rType3Times"].ToString() != "")
         {
             model.rType3Times = int.Parse(row["rType3Times"].ToString());
         }
         if (row["createDate"] != null && row["createDate"].ToString() != "")
         {
             model.createDate = DateTime.Parse(row["createDate"].ToString());
         }
     }
     return(model);
 }
Esempio n. 4
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(MxWeiXinPF.Model.wx_sjb_bisai model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update wx_sjb_bisai set ");
            strSql.Append("bsPic=@bsPic,");
            strSql.Append("bsRemark=@bsRemark,");
            strSql.Append("rcId=@rcId,");
            strSql.Append("qd1Id=@qd1Id,");
            strSql.Append("qd2Id=@qd2Id,");
            strSql.Append("beginDate=@beginDate,");
            strSql.Append("endDate=@endDate,");
            strSql.Append("jcBeginDate=@jcBeginDate,");
            strSql.Append("jcEndDate=@jcEndDate,");
            strSql.Append("resultType=@resultType,");
            strSql.Append("rType1Times=@rType1Times,");
            strSql.Append("rType2Times=@rType2Times,");
            strSql.Append("rType3Times=@rType3Times,");
            strSql.Append("createDate=@createDate");
            strSql.Append(" where id=@id");
            SqlParameter[] parameters =
            {
                new SqlParameter("@bsPic",       SqlDbType.VarChar,    800),
                new SqlParameter("@bsRemark",    SqlDbType.VarChar,   2000),
                new SqlParameter("@rcId",        SqlDbType.Int,          4),
                new SqlParameter("@qd1Id",       SqlDbType.Int,          4),
                new SqlParameter("@qd2Id",       SqlDbType.Int,          4),
                new SqlParameter("@beginDate",   SqlDbType.DateTime),
                new SqlParameter("@endDate",     SqlDbType.DateTime),
                new SqlParameter("@jcBeginDate", SqlDbType.DateTime),
                new SqlParameter("@jcEndDate",   SqlDbType.DateTime),
                new SqlParameter("@resultType",  SqlDbType.Int,          4),
                new SqlParameter("@rType1Times", SqlDbType.Int,          4),
                new SqlParameter("@rType2Times", SqlDbType.Int,          4),
                new SqlParameter("@rType3Times", SqlDbType.Int,          4),
                new SqlParameter("@createDate",  SqlDbType.DateTime),
                new SqlParameter("@id",          SqlDbType.Int, 4)
            };
            parameters[0].Value  = model.bsPic;
            parameters[1].Value  = model.bsRemark;
            parameters[2].Value  = model.rcId;
            parameters[3].Value  = model.qd1Id;
            parameters[4].Value  = model.qd2Id;
            parameters[5].Value  = model.beginDate;
            parameters[6].Value  = model.endDate;
            parameters[7].Value  = model.jcBeginDate;
            parameters[8].Value  = model.jcEndDate;
            parameters[9].Value  = model.resultType;
            parameters[10].Value = model.rType1Times;
            parameters[11].Value = model.rType2Times;
            parameters[12].Value = model.rType3Times;
            parameters[13].Value = model.createDate;
            parameters[14].Value = model.id;

            int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Esempio n. 5
0
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public MxWeiXinPF.Model.wx_sjb_bisai DataRowToModel(DataRow row)
 {
     MxWeiXinPF.Model.wx_sjb_bisai model=new MxWeiXinPF.Model.wx_sjb_bisai();
     if (row != null)
     {
         if(row["id"]!=null && row["id"].ToString()!="")
         {
             model.id=int.Parse(row["id"].ToString());
         }
         if(row["bsPic"]!=null)
         {
             model.bsPic=row["bsPic"].ToString();
         }
         if(row["bsRemark"]!=null)
         {
             model.bsRemark=row["bsRemark"].ToString();
         }
         if(row["rcId"]!=null && row["rcId"].ToString()!="")
         {
             model.rcId=int.Parse(row["rcId"].ToString());
         }
         if(row["qd1Id"]!=null && row["qd1Id"].ToString()!="")
         {
             model.qd1Id=int.Parse(row["qd1Id"].ToString());
         }
         if(row["qd2Id"]!=null && row["qd2Id"].ToString()!="")
         {
             model.qd2Id=int.Parse(row["qd2Id"].ToString());
         }
         if(row["beginDate"]!=null && row["beginDate"].ToString()!="")
         {
             model.beginDate=DateTime.Parse(row["beginDate"].ToString());
         }
         if(row["endDate"]!=null && row["endDate"].ToString()!="")
         {
             model.endDate=DateTime.Parse(row["endDate"].ToString());
         }
         if(row["jcBeginDate"]!=null && row["jcBeginDate"].ToString()!="")
         {
             model.jcBeginDate=DateTime.Parse(row["jcBeginDate"].ToString());
         }
         if(row["jcEndDate"]!=null && row["jcEndDate"].ToString()!="")
         {
             model.jcEndDate=DateTime.Parse(row["jcEndDate"].ToString());
         }
         if(row["resultType"]!=null && row["resultType"].ToString()!="")
         {
             model.resultType=int.Parse(row["resultType"].ToString());
         }
         if(row["rType1Times"]!=null && row["rType1Times"].ToString()!="")
         {
             model.rType1Times=int.Parse(row["rType1Times"].ToString());
         }
         if(row["rType2Times"]!=null && row["rType2Times"].ToString()!="")
         {
             model.rType2Times=int.Parse(row["rType2Times"].ToString());
         }
         if(row["rType3Times"]!=null && row["rType3Times"].ToString()!="")
         {
             model.rType3Times=int.Parse(row["rType3Times"].ToString());
         }
         if(row["createDate"]!=null && row["createDate"].ToString()!="")
         {
             model.createDate=DateTime.Parse(row["createDate"].ToString());
         }
     }
     return model;
 }
Esempio n. 6
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public MxWeiXinPF.Model.wx_sjb_bisai GetModel(int id)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("select  top 1 id,bsPic,bsRemark,rcId,qd1Id,qd2Id,beginDate,endDate,jcBeginDate,jcEndDate,resultType,rType1Times,rType2Times,rType3Times,createDate from wx_sjb_bisai ");
            strSql.Append(" where id=@id");
            SqlParameter[] parameters = {
                    new SqlParameter("@id", SqlDbType.Int,4)
            };
            parameters[0].Value = id;

            MxWeiXinPF.Model.wx_sjb_bisai model=new MxWeiXinPF.Model.wx_sjb_bisai();
            DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
            if(ds.Tables[0].Rows.Count>0)
            {
                return DataRowToModel(ds.Tables[0].Rows[0]);
            }
            else
            {
                return null;
            }
        }