public IncomentPaymentApplyModel GetById(string id) { StringBuilder builder = new StringBuilder(); builder.Append("SELECT PaymentId,PaymentCode,ContractId,PaymentPenson,PaymentAmount,PaymentDate,PaymentMode,FlowState,Notes,InputPerson,InputDate,ContainPending "); builder.Append("FROM Con_Income_PaymentApply WHERE PaymentId=@PaymentId"); SqlParameter parameter = new SqlParameter("@PaymentId", SqlDbType.NVarChar, 0x40) { Value = id }; IncomentPaymentApplyModel model = new IncomentPaymentApplyModel(); using (IDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, builder.ToString(), new SqlParameter[] { parameter })) { if (reader.Read()) { model.Id = reader["PaymentId"].ToString(); model.Code = reader["PaymentCode"].ToString(); model.ContractId = reader["ContractId"].ToString(); model.PaymentPenson = reader["PaymentPenson"].ToString(); model.PaymentAmount = Convert.ToDecimal(reader["PaymentAmount"].ToString()); model.PaymentDate = Convert.ToDateTime(reader["PaymentDate"].ToString()); model.PaymentMode = reader["PaymentMode"].ToString(); model.FlowState = Convert.ToInt32(reader["FlowState"]); model.Notes = reader["Notes"].ToString(); model.InputPerson = reader["InputPerson"].ToString(); model.InputDate = Convert.ToDateTime(reader["InputDate"].ToString()); model.ContainPending = Convert.ToBoolean(reader["ContainPending"].ToString()); } } return(model); }
public List <IncomentPaymentApplyModel> GetByContractId(string contractId) { StringBuilder builder = new StringBuilder(); builder.Append("SELECT PaymentId,PaymentCode,ContractId,PaymentPenson,PaymentAmount,PaymentDate,PaymentMode,FlowState,Notes,InputPerson,InputDate,ContainPending "); builder.Append("FROM Con_Income_PaymentApply WHERE ContractId=@ContractId"); SqlParameter parameter = new SqlParameter("@ContractId", SqlDbType.NVarChar, 0x40) { Value = contractId }; List <IncomentPaymentApplyModel> list = new List <IncomentPaymentApplyModel>(); using (IDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, builder.ToString(), new SqlParameter[] { parameter })) { while (reader.Read()) { IncomentPaymentApplyModel item = new IncomentPaymentApplyModel { Id = reader["PaymentId"].ToString(), Code = reader["PaymentCode"].ToString(), ContractId = reader["ContractId"].ToString(), PaymentPenson = reader["PaymentPenson"].ToString(), PaymentAmount = Convert.ToDecimal(reader["PaymentAmount"].ToString()), PaymentDate = Convert.ToDateTime(reader["PaymentDate"].ToString()), PaymentMode = reader["PaymentMode"].ToString(), FlowState = Convert.ToInt32(reader["FlowState"]), Notes = reader["Notes"].ToString(), InputPerson = reader["InputPerson"].ToString(), InputDate = Convert.ToDateTime(reader["InputDate"].ToString()), ContainPending = Convert.ToBoolean(reader["ContainPending"].ToString()) }; list.Add(item); } } return(list); }
private void AddPayment() { IncomentPaymentApplyModel incomentPaymentApplyModel = new IncomentPaymentApplyModel(); incomentPaymentApplyModel.Id = this.ViewState["PaymentId"].ToString(); incomentPaymentApplyModel.ContractId = this.contractId; incomentPaymentApplyModel.Code = this.txtPaymentCode.Value.Trim(); incomentPaymentApplyModel.PaymentPenson = this.txtPaymentPerson.Text.Trim(); incomentPaymentApplyModel.PaymentAmount = Convert.ToDecimal(this.txtPaymentMoney.Text.Trim()); incomentPaymentApplyModel.PaymentDate = Convert.ToDateTime(this.txtPaymentDate.Text.Trim()); if (this.RblPayType.SelectedIndex == -1) { incomentPaymentApplyModel.PaymentMode = "-1"; } else { incomentPaymentApplyModel.PaymentMode = this.RblPayType.SelectedValue; } incomentPaymentApplyModel.FlowState = -1; incomentPaymentApplyModel.Notes = this.txtNotes.Text.Trim(); incomentPaymentApplyModel.InputPerson = this.txtInputPerson.Text.Trim(); if (!string.IsNullOrEmpty(this.txtInputPerson.Text.Trim())) { incomentPaymentApplyModel.InputDate = DateTime.Now; } incomentPaymentApplyModel.ContainPending = this.chkContainPending.Checked; try { if (this.PaymentApply.IsExists(incomentPaymentApplyModel.Code, incomentPaymentApplyModel.ContractId)) { base.RegisterScript("top.ui.alert('此支付编号已经存在')"); } else { this.PaymentApply.Add(incomentPaymentApplyModel); StringBuilder stringBuilder = new StringBuilder(); if (ContractParameter.IsBalanceAlarm && this.PaymentApply.GreaterBalanceMoney(incomentPaymentApplyModel)) { stringBuilder.Append("top.ui.show('支付金额大于收入金额\\n添加成功!')"); } else { stringBuilder.Append("top.ui.show('添加成功!')"); } stringBuilder.Append(Environment.NewLine); stringBuilder.Append("winclose('AddIncometPaymentApply', 'ShowPaymentApplyList.aspx?ContractID=" + incomentPaymentApplyModel.ContractId + "', true)"); base.RegisterScript(stringBuilder.ToString()); } } catch { base.RegisterHintScript("Add", false, string.Empty); } }
public void Update(IncomentPaymentApplyModel model) { StringBuilder builder = new StringBuilder(); builder.Append("UPDATE Con_Income_PaymentApply SET PaymentCode=@PaymentCode,PaymentPenson=@PaymentPenson,PaymentAmount=@PaymentAmount,PaymentDate=@PaymentDate,"); builder.Append("PaymentMode=@PaymentMode,FlowState=@FlowState,Notes=@Notes,ContainPending=@ContainPending WHERE PaymentId=@PaymentId"); SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@PaymentCode", SqlDbType.NVarChar, 0x40), new SqlParameter("@PaymentPenson", SqlDbType.NVarChar, 0x40), new SqlParameter("@PaymentAmount", SqlDbType.Decimal, 9), new SqlParameter("@PaymentDate", SqlDbType.DateTime), new SqlParameter("@PaymentMode", SqlDbType.NVarChar, 20), new SqlParameter("@FlowState", SqlDbType.Int), new SqlParameter("@Notes", SqlDbType.Text), new SqlParameter("@ContainPending", SqlDbType.Bit), new SqlParameter("@PaymentId", SqlDbType.NVarChar, 0x40) }; commandParameters[0].Value = model.Code; commandParameters[1].Value = model.PaymentPenson; commandParameters[2].Value = model.PaymentAmount; commandParameters[3].Value = model.PaymentDate; commandParameters[4].Value = model.PaymentMode; commandParameters[5].Value = model.FlowState; commandParameters[6].Value = model.Notes; commandParameters[7].Value = model.ContainPending; commandParameters[8].Value = model.Id; SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters); }
private void UpdatePayment() { IncomentPaymentApplyModel byId = this.PaymentApply.GetById(this.ViewState["PaymentId"].ToString()); if (!string.IsNullOrEmpty(this.txtPaymentMoney.Text.Trim())) { byId.PaymentAmount = Convert.ToDecimal(this.txtPaymentMoney.Text.Trim()); } if (!string.IsNullOrEmpty(this.txtPaymentDate.Text.Trim())) { byId.PaymentDate = Convert.ToDateTime(this.txtPaymentDate.Text.Trim()); } byId.PaymentPenson = this.txtPaymentPerson.Text.Trim(); byId.Notes = this.txtNotes.Text.Trim(); byId.ContainPending = this.chkContainPending.Checked; if (this.RblPayType.SelectedIndex == -1) { byId.PaymentMode = "-1"; } else { byId.PaymentMode = this.RblPayType.SelectedValue; } try { this.PaymentApply.Update(byId); StringBuilder stringBuilder = new StringBuilder(); if (ContractParameter.IsBalanceAlarm && this.PaymentApply.GreaterBalanceMoney(byId)) { stringBuilder.Append("top.ui.show('支付金额大于结算金额\\n修改成功!')"); } else { stringBuilder.Append("top.ui.show('修改成功!')"); } stringBuilder.Append(Environment.NewLine); stringBuilder.Append("winclose('AddIncometPaymentApply', 'ShowPaymentApplyList.aspx?ContractID=" + byId.ContractId + "', true)"); base.RegisterScript(stringBuilder.ToString()); } catch (Exception) { base.RegisterHintScript("Update", false, string.Empty); } }
protected void chkContainPendint_CheckedChanged(object sender, EventArgs e) { try { if (string.IsNullOrEmpty(this.contractId)) { IncomentPaymentApplyModel byId = this.PaymentApply.GetById(this.ViewState["PaymentId"].ToString()); this.contractId = byId.ContractId; } IncomentPaymentApplyModel byId2 = this.PaymentApply.GetById(this.ViewState["PaymentId"].ToString()); this.txtPaymentCode.Value = byId2.Code; decimal d = decimal.Parse(this.lblPaymentSum.Text); decimal paySum = this.PaymentApply.GetPaySum(this.contractId, this.chkContainPending.Checked); this.lblPaySum.Text = paySum.ToString("0.000"); decimal num = d - paySum; this.txtDiff.Text = num.ToString("0.000"); } catch { } }
public void Add(IncomentPaymentApplyModel model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into Con_Income_PaymentApply("); builder.Append("PaymentId,PaymentCode,ContractId,PaymentPenson,PaymentAmount,PaymentDate,PaymentMode,FlowState,Notes,InputPerson,InputDate,ContainPending)"); builder.Append(" values ("); builder.Append("@PaymentId,@PaymentCode,@ContractId,@PaymentPenson,@PaymentAmount,@PaymentDate,@PaymentMode,@FlowState,@Notes,@InputPerson,@InputDate,@ContainPending)"); SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@PaymentId", SqlDbType.NVarChar, 0x40), new SqlParameter("@PaymentCode", SqlDbType.NVarChar, 0x40), new SqlParameter("@ContractId", SqlDbType.NVarChar, 0x40), new SqlParameter("@PaymentPenson", SqlDbType.NVarChar, 0x40), new SqlParameter("@PaymentAmount", SqlDbType.Decimal, 9), new SqlParameter("@PaymentDate", SqlDbType.DateTime), new SqlParameter("@PaymentMode", SqlDbType.NVarChar, 20), new SqlParameter("@FlowState", SqlDbType.Int), new SqlParameter("@Notes", SqlDbType.Text), new SqlParameter("@InputPerson", SqlDbType.NVarChar, 0x40), new SqlParameter("@InputDate", SqlDbType.DateTime), new SqlParameter("@ContainPending", SqlDbType.Bit) }; commandParameters[0].Value = model.Id; commandParameters[1].Value = model.Code; commandParameters[2].Value = model.ContractId; commandParameters[3].Value = model.PaymentPenson; commandParameters[4].Value = model.PaymentAmount; commandParameters[5].Value = model.PaymentDate; commandParameters[6].Value = model.PaymentMode; commandParameters[7].Value = model.FlowState; commandParameters[8].Value = model.Notes; commandParameters[9].Value = model.InputPerson; commandParameters[10].Value = model.InputDate; commandParameters[11].Value = model.ContainPending; SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters); }
private void InintUpdateState() { IncomentPaymentApplyModel byId = this.PaymentApply.GetById(this.ViewState["PaymentId"].ToString()); this.contractId = byId.ContractId; this.hlfdContractId.Value = byId.ContractId; this.txtPaymentCode.Value = byId.Code; this.txtPaymentPerson.Text = byId.PaymentPenson; this.txtPaymentDate.Text = byId.PaymentDate.ToShortDateString(); this.txtPaymentMoney.Text = byId.PaymentAmount.ToString("0.000"); this.txtInputDate.Text = byId.InputDate.ToString("yyyy-MM-dd"); this.txtInputPerson.Text = byId.InputPerson; this.TxtCapitalNumber.Value = ConverRMB.Convert(byId.PaymentAmount); this.txtNotes.Text = byId.Notes; this.chkContainPending.Checked = byId.ContainPending; string arg_104_0 = byId.PaymentMode; if (byId.PaymentMode != null && byId.PaymentMode.ToString() != "" && byId.PaymentMode != "-1") { this.RblPayType.SelectedValue = byId.PaymentMode.ToString(); } this.InitContractInfo(this.contractId); }
private void InintUpdateState() { IncomentPaymentApplyModel byId = this.paymentApply.GetById(this.ViewState["PaymentId"].ToString()); this.contractId = byId.ContractId; this.lblPaymentCode.Text = byId.Code; this.lblPaymentMoney.Text = byId.PaymentAmount.ToString("0.000"); this.lblPaymentDate.Text = byId.PaymentDate.ToShortDateString(); this.lblPaymentPerson.Text = byId.PaymentPenson; this.lblInputPerson.Text = byId.InputPerson; this.lblInputDate.Text = byId.InputDate.ToShortDateString(); this.lblNotes.Text = byId.Notes; decimal number = 0m; if (byId.PaymentAmount.ToString() != "") { number = Convert.ToDecimal(byId.PaymentAmount); } this.LblCapitalNumber.Text = ConverRMB.Convert(number); if (byId.PaymentMode == "-1") { this.LblPayType.Text = ""; } if (byId.PaymentMode == "0") { this.LblPayType.Text = "现金"; } if (byId.PaymentMode == "1") { this.LblPayType.Text = "支票"; } if (byId.PaymentMode == "2") { this.LblPayType.Text = "转账"; } this.InitContractInfo(this.contractId); }
public List <IncomentPaymentApplyModel> GetList(string strWhere) { StringBuilder builder = new StringBuilder(); builder.Append(" SELECT PaymentId,PaymentCode,Con_Income_PaymentApply.ContractId,PaymentPenson,PaymentAmount,PaymentDate,PaymentMode,Con_Income_PaymentApply.FlowState,Notes,InputPerson,InputDate"); builder.Append(",ContainPending FROM Con_Income_PaymentApply "); builder.Append("LEFT JOIN Con_Incomet_Contract ON Con_Incomet_Contract.ContractID = Con_Income_PaymentApply.ContractID "); if (!string.IsNullOrEmpty(strWhere)) { builder.Append(" WHERE ").Append(strWhere); } List <IncomentPaymentApplyModel> list = new List <IncomentPaymentApplyModel>(); using (IDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, builder.ToString(), new SqlParameter[0])) { while (reader.Read()) { IncomentPaymentApplyModel item = new IncomentPaymentApplyModel { Id = reader["PaymentId"].ToString(), Code = reader["PaymentCode"].ToString(), ContractId = reader["ContractId"].ToString(), PaymentPenson = reader["PaymentPenson"].ToString(), PaymentAmount = Convert.ToDecimal(reader["PaymentAmount"].ToString()), PaymentDate = Convert.ToDateTime(reader["PaymentDate"].ToString()), PaymentMode = reader["PaymentMode"].ToString(), FlowState = Convert.ToInt32(reader["FlowState"]), Notes = reader["Notes"].ToString(), InputPerson = reader["InputPerson"].ToString(), InputDate = Convert.ToDateTime(reader["InputDate"].ToString()), ContainPending = Convert.ToBoolean(reader["ContainPending"].ToString()) }; list.Add(item); } } return(list); }
public bool GreaterBalanceMoney(IncomentPaymentApplyModel model) { List <IncometPaymentModel> listArray = new IncometPayment().GetListArray(string.Format(" WHERE Con_Incomet_Payment.ContractID = '{0}'", model.ContractId)); decimal?nullable = 0M; foreach (IncometPaymentModel model2 in listArray) { nullable += model2.CllectionPrice; } string strWhere = string.Format(" Con_Income_PaymentApply.FlowState != '-2' AND Con_Income_PaymentApply.ContractID = '{0}' ", model.ContractId); List <IncomentPaymentApplyModel> list = this.paymentApply.GetList(strWhere); decimal?nullable2 = 0M; foreach (IncomentPaymentApplyModel model3 in list) { decimal?nullable6 = nullable2; decimal paymentAmount = model3.PaymentAmount; nullable2 = nullable6.HasValue ? new decimal?(nullable6.GetValueOrDefault() + paymentAmount) : null; } decimal?nullable8 = nullable2; decimal?nullable9 = nullable; return((nullable8.GetValueOrDefault() > nullable9.GetValueOrDefault()) && (nullable8.HasValue & nullable9.HasValue)); }
public void Update(IncomentPaymentApplyModel model) { this.paymentApply.Update(model); }
public void Add(IncomentPaymentApplyModel model) { this.paymentApply.Add(model); }