public void Bind() { Guid fRid = new Guid(this.hdfReturnId.Value.ToString()); PrjReturnModel modelById = this.returnBLL.GetModelById(fRid); this.txtCode.Text = modelById.FR_Code; List <string> list = new List <string>(); list.Add(modelById.FR_name); list.Add(modelById.FR_user); List <string> names = this.yhmcBLL.GetNames(list); int num = 0; foreach (string current in names) { if (num == 0) { this.txtPeople.Text = current; } else { if (num == 1) { this.txtUser.Text = current; } } num++; } this.hdfUserCode.Value = modelById.FR_name; this.txtData.Text = Common2.GetTime(modelById.FR_data); this.txtMoney.Text = modelById.FR_Money.ToString(); this.txtInterest.Text = modelById.FR_interest.ToString(); this.txtDeduct.Text = modelById.FR_deduct.ToString(); this.txtremark.Text = modelById.FR_remark.ToString(); this.txtTime.Text = Common2.GetTime(modelById.FR_Time); }
public int Update(SqlTransaction trans, PrjReturnModel returnModel) { return(this.ptDal.Update(trans, returnModel)); }
protected void btnSave_Click(object sender, EventArgs e) { PrjReturnModel prjReturnModel = new PrjReturnModel(); prjReturnModel.FR_Code = this.txtCode.Text; prjReturnModel.FR_data = new DateTime?(DateTime.Now); if (this.txtData.Text.ToString() != "") { prjReturnModel.FR_data = new DateTime?(Convert.ToDateTime(this.txtData.Text.ToString())); } prjReturnModel.FR_deduct = new decimal?(0m); if (this.txtDeduct.Text.ToString() != "") { prjReturnModel.FR_deduct = new decimal?(Convert.ToDecimal(this.txtDeduct.Text.ToString())); } prjReturnModel.FR_flowState = new int?(-1); prjReturnModel.FR_id = new Guid(this.hdfReturnId.Value.ToString()); prjReturnModel.LoanID = new Guid(base.Request["LoanID"].ToString()); prjReturnModel.FR_interest = new decimal?(0m); if (this.txtInterest.Text.ToString() != "") { prjReturnModel.FR_interest = new decimal?(Convert.ToDecimal(this.txtInterest.Text.ToString())); } prjReturnModel.FR_Money = new decimal?(0m); if (this.txtMoney.Text.ToString() != "") { prjReturnModel.FR_Money = new decimal?(Convert.ToDecimal(this.txtMoney.Text.ToString())); } prjReturnModel.FR_name = this.hdfUserCode.Value.ToString(); prjReturnModel.FR_remark = this.txtremark.Text; prjReturnModel.FR_Time = new DateTime?(Convert.ToDateTime(this.txtTime.Text.ToString())); prjReturnModel.FR_user = base.UserCode; int state = 0; if (this.rdbNo.Checked) { state = 0; } else { if (this.rdbYes.Checked) { state = 1; } } using (SqlConnection sqlConnection = new SqlConnection(SqlHelper.ConnectionString)) { new StringBuilder(); sqlConnection.Open(); SqlTransaction sqlTransaction = sqlConnection.BeginTransaction(); if (base.Request["id"] != null && base.Request["id"] != "") { prjReturnModel.FR_Time = new DateTime?(DateTime.Now); int num = this.returnBLL.Update(sqlTransaction, prjReturnModel); if (num > 0) { int num2 = this.prjLoad.updateReturnState(sqlTransaction, new Guid(base.Request["LoanID"].ToString()), state); if (num2 > 0) { sqlTransaction.Commit(); base.RegisterScript("top.ui.tabSuccess({ parentName: '_prjreturnlist' });"); } else { sqlTransaction.Rollback(); base.RegisterScript("top.ui.alert('修改失败');"); } } else { sqlTransaction.Rollback(); base.RegisterScript("top.ui.alert('修改失败');"); } } else { int num3 = this.returnBLL.Add(sqlTransaction, prjReturnModel); if (num3 > 0) { int num4 = this.prjLoad.updateReturnState(sqlTransaction, new Guid(base.Request["LoanID"].ToString()), state); if (num4 > 0) { sqlTransaction.Commit(); base.RegisterScript("top.ui.tabSuccess({ parentName: '_prjreturnlist' });"); } else { sqlTransaction.Rollback(); base.RegisterScript("top.ui.alert('新增失败');"); } } else { sqlTransaction.Rollback(); base.RegisterScript("top.ui.alert('新增失败');"); } } sqlConnection.Close(); } }
public int Add(SqlTransaction trans, PrjReturnModel model) { return(this.ptDal.Add(trans, model)); }