示例#1
0
        public int Update(IncometModifyModel model)
        {
            StringBuilder builder = new StringBuilder();

            builder.Append("update Con_Incomet_Modify set ");
            builder.Append("ContractID=@ContractID,");
            builder.Append("ChangeCode=@ChangeCode,");
            builder.Append("ChangeTime=@ChangeTime,");
            builder.Append("ChangePrice=@ChangePrice,");
            builder.Append("ChangeReason=@ChangeReason,");
            builder.Append("Transactor=@Transactor,");
            builder.Append("Annex=@Annex,");
            builder.Append("Remark=@Remark,");
            builder.Append("InputPerson=@InputPerson,");
            builder.Append("InputDate=@InputDate");
            builder.Append(" where ID=@ID ");
            SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.NVarChar, 0x40), new SqlParameter("@ContractID", SqlDbType.NVarChar, 0x40), new SqlParameter("@ChangeCode", SqlDbType.NVarChar, 0x40), new SqlParameter("@ChangeTime", SqlDbType.DateTime), new SqlParameter("@ChangePrice", SqlDbType.Decimal, 9), new SqlParameter("@ChangeReason", SqlDbType.NVarChar, 500), new SqlParameter("@Transactor", SqlDbType.NVarChar, 0x40), new SqlParameter("@Annex", SqlDbType.NVarChar, 200), new SqlParameter("@Remark", SqlDbType.NVarChar), new SqlParameter("@InputPerson", SqlDbType.NVarChar, 0x40), new SqlParameter("@InputDate", SqlDbType.DateTime) };
            commandParameters[0].Value  = model.ID;
            commandParameters[1].Value  = model.ContractID;
            commandParameters[2].Value  = model.ChangeCode;
            commandParameters[3].Value  = model.ChangeTime;
            commandParameters[4].Value  = model.ChangePrice;
            commandParameters[5].Value  = model.ChangeReason;
            commandParameters[6].Value  = model.Transactor;
            commandParameters[7].Value  = model.Annex;
            commandParameters[8].Value  = model.Remark;
            commandParameters[9].Value  = model.InputPerson;
            commandParameters[10].Value = model.InputDate;
            return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters));
        }
示例#2
0
        public IncometModifyModel ReaderBind(IDataReader dataReader)
        {
            IncometModifyModel model = new IncometModifyModel {
                ID         = dataReader["ID"].ToString(),
                ContractID = dataReader["ContractID"].ToString(),
                ChangeCode = dataReader["ChangeCode"].ToString()
            };
            object obj2 = dataReader["ChangeTime"];

            if ((obj2 != null) && (obj2 != DBNull.Value))
            {
                model.ChangeTime = new DateTime?((DateTime)obj2);
            }
            obj2 = dataReader["ChangePrice"];
            if ((obj2 != null) && (obj2 != DBNull.Value))
            {
                model.ChangePrice = new decimal?((decimal)obj2);
            }
            model.ChangeReason = dataReader["ChangeReason"].ToString();
            model.Transactor   = dataReader["Transactor"].ToString();
            model.Annex        = dataReader["Annex"].ToString();
            model.Remark       = dataReader["Remark"].ToString();
            model.InputPerson  = dataReader["InputPerson"].ToString();
            obj2 = dataReader["InputDate"];
            if ((obj2 != null) && (obj2 != DBNull.Value))
            {
                model.InputDate = new DateTime?((DateTime)obj2);
            }
            return(model);
        }
示例#3
0
    public void InitPage()
    {
        if (base.Request.QueryString["id"] != null)
        {
            this.lblTitle.Text = "编辑收入合同变更";
            IncometModifyModel model = this.incometModifyBll.GetModel(base.Request.QueryString["id"]);
            this.txtChangeCode.Text   = model.ChangeCode;
            this.hdChangeCode.Value   = model.ChangeCode;
            this.txtChangePrice.Text  = model.ChangePrice.ToString();
            this.txtChangeReason.Text = model.ChangeReason;
            this.txtChangeTime.Text   = Common2.GetTime(model.ChangeTime.ToString());
            this.txtInputDate.Text    = Common2.GetTime(model.InputDate.ToString());
            this.txtInputPerson.Text  = model.InputPerson;
            this.txtRemark.Text       = model.Remark;
            this.txtTransactor.Text   = model.Transactor;
            this.hdGuid.Value         = model.ID;
            this.DataBindSheet(model.ID);
        }
        else
        {
            this.lblTitle.Text       = "新增收入合同变更";
            this.txtInputDate.Text   = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
            this.txtInputPerson.Text = PageHelper.QueryUser(this, base.UserCode);
            this.hdGuid.Value        = Guid.NewGuid().ToString();
        }
        IncometContractModel model2 = this.incometContractBll.GetModel(base.Request.QueryString["ContractID"]);

        this.txtContractCode.Text  = model2.ContractCode;
        this.txtContractName.Text  = model2.ContractName;
        this.txtContractPrice.Text = model2.ContractPrice.ToString();
        this.txtEndPrice.Text      = WebUtil.GetEnPrice(model2.ContractPrice.ToString(), model2.ContractID);
        this.txtSignedTime.Text    = Common2.GetTime(model2.SignedTime.ToString());
        if (model2.Project != null)
        {
            this.hfldPrjGuid.Value = model2.Project.PrjGuid.ToString();
        }
        else
        {
            List <string> prjInfoZTBIncoment = this.prjInfoBll.GetPrjInfoZTBIncoment(base.Request.QueryString["ContractID"]);
            if (prjInfoZTBIncoment.Count > 0)
            {
                this.hfldPrjGuid.Value = prjInfoZTBIncoment[4].ToString();
            }
        }
        this.FileLink1.MID  = 1907;
        this.FileLink1.FID  = this.hdGuid.Value;
        this.FileLink1.Type = 1;
    }
示例#4
0
        public IncometModifyModel GetModel(string ID)
        {
            StringBuilder builder = new StringBuilder();

            builder.Append("select ID,ContractID,ChangeCode,ChangeTime,ChangePrice,ChangeReason,Transactor,Annex,Remark,InputPerson,InputDate from Con_Incomet_Modify ");
            builder.Append(" where ID=@ID ");
            IncometModifyModel model = null;

            using (IDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, builder.ToString(), new SqlParameter[] { new SqlParameter("@ID", ID) }))
            {
                if (reader.Read())
                {
                    model = this.ReaderBind(reader);
                }
            }
            return(model);
        }
示例#5
0
        public int Add(IncometModifyModel model)
        {
            StringBuilder builder = new StringBuilder();

            builder.Append("insert into Con_Incomet_Modify(");
            builder.Append("ID,ContractID,ChangeCode,ChangeTime,ChangePrice,ChangeReason,Transactor,Annex,Remark,InputPerson,InputDate)");
            builder.Append(" values (");
            builder.Append("@ID,@ContractID,@ChangeCode,@ChangeTime,@ChangePrice,@ChangeReason,@Transactor,@Annex,@Remark,@InputPerson,@InputDate)");
            SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.NVarChar, 0x40), new SqlParameter("@ContractID", SqlDbType.NVarChar, 0x40), new SqlParameter("@ChangeCode", SqlDbType.NVarChar, 0x40), new SqlParameter("@ChangeTime", SqlDbType.DateTime), new SqlParameter("@ChangePrice", SqlDbType.Decimal, 9), new SqlParameter("@ChangeReason", SqlDbType.NVarChar, 500), new SqlParameter("@Transactor", SqlDbType.NVarChar, 0x40), new SqlParameter("@Annex", SqlDbType.NVarChar, 200), new SqlParameter("@Remark", SqlDbType.NVarChar), new SqlParameter("@InputPerson", SqlDbType.NVarChar, 0x40), new SqlParameter("@InputDate", SqlDbType.DateTime) };
            commandParameters[0].Value  = model.ID;
            commandParameters[1].Value  = model.ContractID;
            commandParameters[2].Value  = model.ChangeCode;
            commandParameters[3].Value  = model.ChangeTime;
            commandParameters[4].Value  = model.ChangePrice;
            commandParameters[5].Value  = model.ChangeReason;
            commandParameters[6].Value  = model.Transactor;
            commandParameters[7].Value  = model.Annex;
            commandParameters[8].Value  = model.Remark;
            commandParameters[9].Value  = model.InputPerson;
            commandParameters[10].Value = model.InputDate;
            return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters));
        }
示例#6
0
 public int Update(IncometModifyModel model)
 {
     return(this.incometModify.Update(model));
 }
示例#7
0
 public int Add(IncometModifyModel model)
 {
     return(this.incometModify.Add(model));
 }