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);
}
