public int Update(IncometBalanceModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update Con_Incomet_Balance set ");
builder.Append("ContractID=@ContractID,");
builder.Append("ClearingNumber=@ClearingNumber,");
builder.Append("ClearingTime=@ClearingTime,");
builder.Append("BalanceMode=@BalanceMode,");
builder.Append("PayMode=@PayMode,");
builder.Append("BalanceObject=@BalanceObject,");
builder.Append("ClearingUser=@ClearingUser,");
builder.Append("ClearingPrice=@ClearingPrice,");
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("@ClearingNumber", SqlDbType.NVarChar, 0x40), new SqlParameter("@ClearingTime", SqlDbType.DateTime), new SqlParameter("@BalanceMode", SqlDbType.NVarChar, 0x40), new SqlParameter("@PayMode", SqlDbType.NVarChar, 0x40), new SqlParameter("@BalanceObject", SqlDbType.NVarChar, 0x40), new SqlParameter("@ClearingUser", SqlDbType.NVarChar, 0x40), new SqlParameter("@ClearingPrice", SqlDbType.Decimal, 9), 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.ClearingNumber;
commandParameters[3].Value = model.ClearingTime;
commandParameters[4].Value = model.BalanceMode;
commandParameters[5].Value = model.PayMode;
commandParameters[6].Value = model.BalanceObject;
commandParameters[7].Value = model.ClearingUser;
commandParameters[8].Value = model.ClearingPrice;
commandParameters[9].Value = model.Annex;
commandParameters[10].Value = model.Remark;
commandParameters[11].Value = model.InputPerson;
commandParameters[12].Value = model.InputDate;
return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters));
}
public IncometBalanceModel ReaderBind(IDataReader dataReader)
{
IncometBalanceModel model = new IncometBalanceModel {
ID = dataReader["ID"].ToString(),
ContractID = dataReader["ContractID"].ToString(),
ClearingNumber = dataReader["ClearingNumber"].ToString()
};
object obj2 = dataReader["ClearingTime"];
if ((obj2 != null) && (obj2 != DBNull.Value))
{
model.ClearingTime = new DateTime?((DateTime)obj2);
}
model.BalanceMode = dataReader["BalanceMode"].ToString();
model.PayMode = dataReader["PayMode"].ToString();
model.BalanceObject = dataReader["BalanceObject"].ToString();
model.ClearingUser = dataReader["ClearingUser"].ToString();
obj2 = dataReader["ClearingPrice"];
if ((obj2 != null) && (obj2 != DBNull.Value))
{
model.ClearingPrice = new decimal?((decimal)obj2);
}
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);
}
public void InitPage()
{
this.BindDdl();
if (base.Request.QueryString["id"] != null)
{
this.lblTitle.Text = "编辑收入合同结算";
IncometBalanceModel model = this.incometBalanceBll.GetModel(base.Request.QueryString["id"]);
this.txtClearingNumber.Text = model.ClearingNumber;
this.hdClearingNumber.Value = model.ClearingNumber;
this.txtClearingPrice.Text = model.ClearingPrice.ToString();
this.txtClearingTime.Text = Common2.GetTime(model.ClearingTime.ToString());
this.txtClearingUser.Text = model.ClearingUser;
this.txtInputDate.Text = Common2.GetTime(model.InputDate.ToString());
this.txtInputPerson.Text = model.InputPerson;
this.txtRemark.Text = model.Remark;
this.hdGuid.Value = model.ID;
this.ddlBalanceMode.SelectedValue = model.BalanceMode;
this.ddlPayMode.SelectedValue = model.PayMode;
this.txtBalanceObj.Text = model.BalanceObject;
List <ConBalanceItem> listByBalanceId = this.conBalItemSev.GetListByBalanceId(this.hdGuid.Value);
this.SaveBanlanceItemToViewState(listByBalanceId);
this.BindBalanceItem();
}
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();
this.BindBalanceItem();
}
this.hfldContractId.Value = base.Request.QueryString["ContractID"];
IncometContractModel model2 = this.incometContractBll.GetModel(base.Request.QueryString["ContractID"]);
this.txtContractCode.Text = model2.ContractCode;
this.txtContractName.Text = model2.ContractName;
this.txtContractPrice.Text = WebUtil.GetEnPrice(model2.ContractPrice.ToString(), model2.ContractID);
this.txtSignedTime.Text = Common2.GetTime(model2.SignedTime.ToString());
this.txtSumClearing.Text = WebUtil.GetPaymentSum(model2.ContractID, "Con_Incomet_Balance", "ClearingPrice");
this.txtDiffAmount.Text = string.Concat(Convert.ToDecimal(this.txtContractPrice.Text) - Convert.ToDecimal(this.txtSumClearing.Text));
this.FileLink1.MID = 1906;
this.FileLink1.FID = this.hdGuid.Value;
this.FileLink1.Type = 1;
IncometContractModel model3 = this.incometContractBll.GetModel(base.Request["ContractID"]);
this.hfldPrjid.Value = model3.Project.PrjGuid.ToString();
this.initMeasureBindGV();
}
public IncometBalanceModel GetModel(string ID)
{
StringBuilder builder = new StringBuilder();
builder.Append("select top 1 ID,ContractID,ClearingNumber,ClearingTime,BalanceMode,PayMode,BalanceObject,ClearingUser,ClearingPrice,Annex,Remark,InputPerson,InputDate from Con_Incomet_Balance ");
builder.Append(" where ID=@ID ");
IncometBalanceModel 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);
}
public int Add(IncometBalanceModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into Con_Incomet_Balance(");
builder.Append("ID,ContractID,ClearingNumber,ClearingTime,BalanceMode,PayMode,BalanceObject,ClearingUser,ClearingPrice,Annex,Remark,InputPerson,InputDate)");
builder.Append(" values (");
builder.Append("@ID,@ContractID,@ClearingNumber,@ClearingTime,@BalanceMode,@PayMode,@BalanceObject,@ClearingUser,@ClearingPrice,@Annex,@Remark,@InputPerson,@InputDate)");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.NVarChar, 0x40), new SqlParameter("@ContractID", SqlDbType.NVarChar, 0x40), new SqlParameter("@ClearingNumber", SqlDbType.NVarChar, 0x40), new SqlParameter("@ClearingTime", SqlDbType.DateTime), new SqlParameter("@BalanceMode", SqlDbType.NVarChar, 0x40), new SqlParameter("@PayMode", SqlDbType.NVarChar, 0x40), new SqlParameter("@BalanceObject", SqlDbType.NVarChar, 0x40), new SqlParameter("@ClearingUser", SqlDbType.NVarChar, 0x40), new SqlParameter("@ClearingPrice", SqlDbType.Decimal, 9), 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.ClearingNumber;
commandParameters[3].Value = model.ClearingTime;
commandParameters[4].Value = model.BalanceMode;
commandParameters[5].Value = model.PayMode;
commandParameters[6].Value = model.BalanceObject;
commandParameters[7].Value = model.ClearingUser;
commandParameters[8].Value = model.ClearingPrice;
commandParameters[9].Value = model.Annex;
commandParameters[10].Value = model.Remark;
commandParameters[11].Value = model.InputPerson;
commandParameters[12].Value = model.InputDate;
return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters));
}
public int Update(IncometBalanceModel model)
{
return(this.incometBalance.Update(model));
}
public int Add(IncometBalanceModel model)
{
return(this.incometBalance.Add(model));
}
