Ejemplo n.º 1
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(ChouJiangModel model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into YYHD.dbo.ChouJiang (");
            strSql.Append("ChouJiangClassId,Memo,Invalid,ChouJiangCode,ChouJiangName,CreateTime,BgTime,EndTime,LimitNum,WxPtId,ChouJiangTypeId");
            strSql.Append(") values (");
            strSql.Append("@ChouJiangClassId,@Memo,@Invalid,@ChouJiangCode,@ChouJiangName,@CreateTime,@BgTime,@EndTime,@LimitNum,@WxPtId,@ChouJiangTypeId");
            strSql.Append(") ");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters =
            {
                new SqlParameter("@ChouJiangClassId", SqlDbType.Int,          4),
                new SqlParameter("@Memo",             SqlDbType.VarChar,   4000),
                new SqlParameter("@Invalid",          SqlDbType.Bit,          1),
                new SqlParameter("@ChouJiangCode",    SqlDbType.VarChar,     50),
                new SqlParameter("@ChouJiangName",    SqlDbType.VarChar,     50),
                new SqlParameter("@CreateTime",       SqlDbType.DateTime),
                new SqlParameter("@BgTime",           SqlDbType.DateTime),
                new SqlParameter("@EndTime",          SqlDbType.DateTime),
                new SqlParameter("@LimitNum",         SqlDbType.Int,          4),
                new SqlParameter("@WxPtId",           SqlDbType.Decimal,      9),
                new SqlParameter("@ChouJiangTypeId",  SqlDbType.Int, 4)
            };

            parameters[0].Value  = model.ChouJiangClassId;
            parameters[1].Value  = model.Memo;
            parameters[2].Value  = model.Invalid;
            parameters[3].Value  = model.ChouJiangCode;
            parameters[4].Value  = model.ChouJiangName;
            parameters[5].Value  = model.CreateTime;
            parameters[6].Value  = model.BgTime;
            parameters[7].Value  = model.EndTime;
            parameters[8].Value  = model.LimitNum;
            parameters[9].Value  = model.WxPtId;
            parameters[10].Value = model.ChouJiangTypeId;

            bool result = false;

            try
            {
                helper.ExecSqlReInt(strSql.ToString(), parameters);
                result = true;
            }
            catch (Exception ex)
            {
                this.helper.Close();
                throw ex;
            }
            finally
            {
            }
            return(result);
        }
Ejemplo n.º 2
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public ChouJiangModel GetModel(decimal ChouJiangId)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select ChouJiangId, ChouJiangClassId, Memo, Invalid, ChouJiangCode, ChouJiangName, CreateTime, BgTime, EndTime, LimitNum, WxPtId, ChouJiangTypeId  ");
            strSql.Append("  from YYHD.dbo.ChouJiang ");
            strSql.Append(" where ChouJiangId=@ChouJiangId");
            SqlParameter[] parameters =
            {
                new SqlParameter("@ChouJiangId", SqlDbType.Decimal)
            };
            parameters[0].Value = ChouJiangId;


            ChouJiangModel model = new ChouJiangModel();
            DataSet        ds    = helper.ExecSqlReDs(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows[0]["ChouJiangId"].ToString() != "")
                {
                    model.ChouJiangId = decimal.Parse(ds.Tables[0].Rows[0]["ChouJiangId"].ToString());
                }
                if (ds.Tables[0].Rows[0]["ChouJiangClassId"].ToString() != "")
                {
                    model.ChouJiangClassId = int.Parse(ds.Tables[0].Rows[0]["ChouJiangClassId"].ToString());
                }
                model.Memo = ds.Tables[0].Rows[0]["Memo"].ToString();
                if (ds.Tables[0].Rows[0]["Invalid"].ToString() != "")
                {
                    if ((ds.Tables[0].Rows[0]["Invalid"].ToString() == "1") || (ds.Tables[0].Rows[0]["Invalid"].ToString().ToLower() == "true"))
                    {
                        model.Invalid = true;
                    }
                    else
                    {
                        model.Invalid = false;
                    }
                }
                model.ChouJiangCode = ds.Tables[0].Rows[0]["ChouJiangCode"].ToString();
                model.ChouJiangName = ds.Tables[0].Rows[0]["ChouJiangName"].ToString();
                if (ds.Tables[0].Rows[0]["CreateTime"].ToString() != "")
                {
                    model.CreateTime = DateTime.Parse(ds.Tables[0].Rows[0]["CreateTime"].ToString());
                }
                if (ds.Tables[0].Rows[0]["BgTime"].ToString() != "")
                {
                    model.BgTime = DateTime.Parse(ds.Tables[0].Rows[0]["BgTime"].ToString());
                }
                if (ds.Tables[0].Rows[0]["EndTime"].ToString() != "")
                {
                    model.EndTime = DateTime.Parse(ds.Tables[0].Rows[0]["EndTime"].ToString());
                }
                if (ds.Tables[0].Rows[0]["LimitNum"].ToString() != "")
                {
                    model.LimitNum = int.Parse(ds.Tables[0].Rows[0]["LimitNum"].ToString());
                }
                if (ds.Tables[0].Rows[0]["WxPtId"].ToString() != "")
                {
                    model.WxPtId = decimal.Parse(ds.Tables[0].Rows[0]["WxPtId"].ToString());
                }
                if (ds.Tables[0].Rows[0]["ChouJiangTypeId"].ToString() != "")
                {
                    model.ChouJiangTypeId = int.Parse(ds.Tables[0].Rows[0]["ChouJiangTypeId"].ToString());
                }

                return(model);
            }
            else
            {
                return(model);
            }
        }
Ejemplo n.º 3
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(ChouJiangModel model)
        {
            bool          reValue = true;
            int           reCount = 0;
            StringBuilder strSql  = new StringBuilder();

            strSql.Append("update YYHD.dbo.ChouJiang set ");

            strSql.Append(" ChouJiangClassId = @ChouJiangClassId , ");
            strSql.Append(" Memo = @Memo , ");
            strSql.Append(" Invalid = @Invalid , ");
            strSql.Append(" ChouJiangCode = @ChouJiangCode , ");
            strSql.Append(" ChouJiangName = @ChouJiangName , ");
            strSql.Append(" CreateTime = @CreateTime , ");
            strSql.Append(" BgTime = @BgTime , ");
            strSql.Append(" EndTime = @EndTime , ");
            strSql.Append(" LimitNum = @LimitNum , ");
            strSql.Append(" WxPtId = @WxPtId , ");
            strSql.Append(" ChouJiangTypeId = @ChouJiangTypeId  ");
            strSql.Append(" where ChouJiangId=@ChouJiangId ");

            SqlParameter[] parameters =
            {
                new SqlParameter("@ChouJiangId",      SqlDbType.Decimal,      9),
                new SqlParameter("@ChouJiangClassId", SqlDbType.Int,          4),
                new SqlParameter("@Memo",             SqlDbType.VarChar,   4000),
                new SqlParameter("@Invalid",          SqlDbType.Bit,          1),
                new SqlParameter("@ChouJiangCode",    SqlDbType.VarChar,     50),
                new SqlParameter("@ChouJiangName",    SqlDbType.VarChar,     50),
                new SqlParameter("@CreateTime",       SqlDbType.DateTime),
                new SqlParameter("@BgTime",           SqlDbType.DateTime),
                new SqlParameter("@EndTime",          SqlDbType.DateTime),
                new SqlParameter("@LimitNum",         SqlDbType.Int,          4),
                new SqlParameter("@WxPtId",           SqlDbType.Decimal,      9),
                new SqlParameter("@ChouJiangTypeId",  SqlDbType.Int, 4)
            };

            parameters[0].Value  = model.ChouJiangId;
            parameters[1].Value  = model.ChouJiangClassId;
            parameters[2].Value  = model.Memo;
            parameters[3].Value  = model.Invalid;
            parameters[4].Value  = model.ChouJiangCode;
            parameters[5].Value  = model.ChouJiangName;
            parameters[6].Value  = model.CreateTime;
            parameters[7].Value  = model.BgTime;
            parameters[8].Value  = model.EndTime;
            parameters[9].Value  = model.LimitNum;
            parameters[10].Value = model.WxPtId;
            parameters[11].Value = model.ChouJiangTypeId; try
            {//异常处理
                reCount = this.helper.ExecSqlReInt(strSql.ToString(), parameters);
            }
            catch (Exception ex)
            {
                this.helper.Close();
                throw ex;
            }
            if (reCount <= 0)
            {
                reValue = false;
            }
            return(reValue);
        }