private void UpdateBalance()
{
PayoutBalanceModel model = this.payoutBalance.GetModel(this.ViewState["BalanceId"].ToString());
if (!string.IsNullOrEmpty(this.txtBalanceMoney.Text.Trim()))
{
model.BalanceMoney = new decimal?(Convert.ToDecimal(this.txtBalanceMoney.Text.Trim()));
}
model.BalancePerson = this.txtBalancePerson.Text.Trim();
if (!string.IsNullOrEmpty(this.txtBalanceDate.Text.Trim()))
{
model.BalanceDate = new DateTime?(Convert.ToDateTime(this.txtBalanceDate.Text.Trim()));
}
model.BalanceMode = this.dropBalanceMode.SelectedValue;
model.PayMode = this.dropPayMode.SelectedValue;
model.BalanceObject = this.txtBalanceObj.Text;
model.ContainPending = this.chkContainPending.Checked;
model.Notes = this.txtNotes.Text.Trim();
try
{
this.payoutBalance.Update(model);
this.SaveBalanceStock();
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("top.ui.show('修改成功')");
stringBuilder.Append(Environment.NewLine);
stringBuilder.Append("winclose('BalanceEdit', 'PayoutBalanceEdit.aspx?ContractID=" + model.ContractID + "', true)");
base.RegisterScript(stringBuilder.ToString());
}
catch (Exception)
{
base.RegisterHintScript("Update", false, string.Empty);
}
}
public void Add(PayoutBalanceModel model, SqlTransaction trans)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into Con_Payout_Balance(");
builder.Append("BalanceID,BalanceCode,ContractID,BalanceMoney,BalancePerson,BalanceDate,Annex,FlowState,BalanceMode,PayMode,BalanceObject,ContainPending,Notes,InputPerson,InputDate)");
builder.Append(" values (");
builder.Append("@BalanceID,@BalanceCode,@ContractID,@BalanceMoney,@BalancePerson,@BalanceDate,@Annex,@FlowState,@BalanceMode,@PayMode,@BalanceObject,@ContainPending,@Notes,@InputPerson,@InputDate)");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@BalanceID", SqlDbType.NVarChar, 0x40), new SqlParameter("@BalanceCode", SqlDbType.NVarChar, 0x40), new SqlParameter("@ContractID", SqlDbType.NVarChar, 0x40), new SqlParameter("@BalanceMoney", SqlDbType.Decimal, 9), new SqlParameter("@BalancePerson", SqlDbType.NVarChar, 0x40), new SqlParameter("@BalanceDate", SqlDbType.DateTime), new SqlParameter("@Annex", SqlDbType.NVarChar, 0x100), new SqlParameter("@FlowState", SqlDbType.Int, 4), new SqlParameter("@BalanceMode", SqlDbType.NVarChar, 0x40), new SqlParameter("@PayMode", SqlDbType.NVarChar, 0x40), new SqlParameter("@BalanceObject", SqlDbType.NVarChar, 0x40), new SqlParameter("@ContainPending", SqlDbType.NVarChar, 0x40), new SqlParameter("@Notes", SqlDbType.NVarChar), new SqlParameter("@InputPerson", SqlDbType.NVarChar, 0x40), new SqlParameter("@InputDate", SqlDbType.DateTime) };
commandParameters[0].Value = model.BalanceID;
commandParameters[1].Value = model.BalanceCode;
commandParameters[2].Value = model.ContractID;
commandParameters[3].Value = model.BalanceMoney;
commandParameters[4].Value = model.BalancePerson;
commandParameters[5].Value = model.BalanceDate;
commandParameters[6].Value = model.Annex;
commandParameters[7].Value = model.FlowState;
commandParameters[8].Value = model.BalanceMode;
commandParameters[9].Value = model.PayMode;
commandParameters[10].Value = model.BalanceObject;
commandParameters[11].Value = model.ContainPending;
commandParameters[12].Value = model.Notes;
commandParameters[13].Value = model.InputPerson;
commandParameters[14].Value = model.InputDate;
if (trans == null)
{
SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters);
}
else
{
SqlHelper.ExecuteNonQuery(trans, CommandType.Text, builder.ToString(), commandParameters);
}
}
public bool GreaterModifiedMoney(PayoutBalanceModel balanceInfo)
{
decimal?nullable = 0M;
string strWhere = string.Format(" Con_Payout_Balance.FlowState != '-2' \r\n AND Con_Payout_Contract.ContractID = '{0}'", balanceInfo.ContractID);
foreach (PayoutBalanceModel model in this.balance.GetList(strWhere))
{
nullable += model.BalanceMoney;
}
PayoutContractModel model2 = new cn.justwin.contractBLL.PayoutContract().GetModel(balanceInfo.ContractID);
decimal? nullable5 = nullable;
decimal? modifiedMoney = model2.ModifiedMoney;
return((nullable5.GetValueOrDefault() > modifiedMoney.GetValueOrDefault()) && (nullable5.HasValue & modifiedMoney.HasValue));
}
private void InintUpdateState()
{
PayoutBalanceModel model = this.balance.GetModel(this.ViewState["BalanceId"].ToString());
if (model != null)
{
this.contractId = model.ContractID;
this.lblBalanceCode.Text = model.BalanceCode;
this.lblBalanceMoney.Text = model.BalanceMoney.ToString();
this.lblBalanceDate.Text = model.BalanceDate.Value.ToShortDateString();
this.lblBalancePerson.Text = model.BalancePerson;
this.lblInputPerson.Text = model.InputPerson;
this.lblInputDate.Text = model.InputDate.Value.ToShortDateString();
this.lblNotes.Text = model.Notes;
if (model.BalanceMoney.ToString() != "")
{
Convert.ToDecimal(model.BalanceMoney);
}
this.lblDiffAmount.Text = this.GetDiffAmount(this.contractId, model.ContainPending).ToString();
this.lblBalanceObj.Text = model.BalanceObject;
DataTable table = Common2.GetTable("dbo.XPM_Basic_CodeList", "where typeId=27 and ParentCodeID=0");
DataTable table2 = Common2.GetTable("dbo.XPM_Basic_CodeList", "where typeId=25 and ParentCodeID=0");
if (table.Rows.Count > 0)
{
foreach (DataRow dataRow in table.Rows)
{
if (dataRow["NoteID"].ToString() == model.BalanceMode)
{
this.lblBalanceMode.Text = dataRow["CodeName"].ToString();
}
}
}
if (table2.Rows.Count > 0)
{
foreach (DataRow dataRow2 in table2.Rows)
{
if (dataRow2["NoteID"].ToString() == model.PayMode)
{
this.lblPayMode.Text = dataRow2["CodeName"].ToString();
}
}
}
this.InitContractInfo(this.contractId);
}
}
public void Update(PayoutBalanceModel model, SqlTransaction trans)
{
StringBuilder builder = new StringBuilder();
builder.Append("update Con_Payout_Balance set ");
builder.Append("BalanceCode=@BalanceCode,");
builder.Append("ContractID=@ContractID,");
builder.Append("BalanceMoney=@BalanceMoney,");
builder.Append("BalancePerson=@BalancePerson,");
builder.Append("BalanceDate=@BalanceDate,");
builder.Append("Annex=@Annex,");
builder.Append("FlowState=@FlowState,");
builder.Append("BalanceMode=@BalanceMode,");
builder.Append("PayMode=@PayMode,");
builder.Append("BalanceObject=@BalanceObject,");
builder.Append("ContainPending=@ContainPending,");
builder.Append("Notes=@Notes,");
builder.Append("InputPerson=@InputPerson,");
builder.Append("InputDate=@InputDate");
builder.Append(" where BalanceID=@BalanceID ");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@BalanceID", SqlDbType.NVarChar, 0x40), new SqlParameter("@BalanceCode", SqlDbType.NVarChar, 0x40), new SqlParameter("@ContractID", SqlDbType.NVarChar, 0x40), new SqlParameter("@BalanceMoney", SqlDbType.Decimal, 9), new SqlParameter("@BalancePerson", SqlDbType.NVarChar, 0x40), new SqlParameter("@BalanceDate", SqlDbType.DateTime), new SqlParameter("@Annex", SqlDbType.NVarChar, 0x100), new SqlParameter("@FlowState", SqlDbType.Int, 4), new SqlParameter("@BalanceMode", SqlDbType.NVarChar, 0x40), new SqlParameter("@PayMode", SqlDbType.NVarChar, 0x40), new SqlParameter("@BalanceObject", SqlDbType.NVarChar, 0x40), new SqlParameter("@ContainPending", SqlDbType.NVarChar, 0x40), new SqlParameter("@Notes", SqlDbType.NVarChar), new SqlParameter("@InputPerson", SqlDbType.NVarChar, 0x40), new SqlParameter("@InputDate", SqlDbType.DateTime) };
commandParameters[0].Value = model.BalanceID;
commandParameters[1].Value = model.BalanceCode;
commandParameters[2].Value = model.ContractID;
commandParameters[3].Value = model.BalanceMoney;
commandParameters[4].Value = model.BalancePerson;
commandParameters[5].Value = model.BalanceDate;
commandParameters[6].Value = model.Annex;
commandParameters[7].Value = model.FlowState;
commandParameters[8].Value = model.BalanceMode;
commandParameters[9].Value = model.PayMode;
commandParameters[10].Value = model.BalanceObject;
commandParameters[11].Value = model.ContainPending;
commandParameters[12].Value = model.Notes;
commandParameters[13].Value = model.InputPerson;
commandParameters[14].Value = model.InputDate;
if (trans == null)
{
SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters);
}
else
{
SqlHelper.ExecuteNonQuery(trans, CommandType.Text, builder.ToString(), commandParameters);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.contractId) && !string.IsNullOrEmpty(this.ViewState["BalanceId"].ToString()))
{
PayoutBalanceModel model = this.balance.GetModel(this.ViewState["BalanceId"].ToString());
if (model != null)
{
this.contractId = model.ContractID;
}
}
if (!base.IsPostBack)
{
this.InintUpdateState();
this.Literal1.Text = this.FilesBind(1903, this.ViewState["BalanceId"].ToString());
this.ShowGuideLine();
}
DataTable balanceStockByContractId = this.purchaseStock.GetBalanceStockByContractId(this.contractId, this.ViewState["BalanceId"].ToString());
this.ViewState["resource"] = balanceStockByContractId;
this.DataBindBalanceStock();
}
protected void Page_Load(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.contractId) && !string.IsNullOrEmpty(this.ViewState["BalanceId"].ToString()))
{
PayoutBalanceModel model = this.payoutBalance.GetModel(this.ViewState["BalanceId"].ToString());
this.contractId = model.ContractID;
}
if (!base.IsPostBack)
{
WebUtil.DataBindBalanceMode(this.dropBalanceMode);
WebUtil.DataBindPayMode(this.dropPayMode);
if (string.Compare(this.action, "Add", true) == 0)
{
this.InitAddState();
this.BindBalanceItem();
}
else
{
this.InitUpdateState();
List <ConBalanceItem> listByBalanceId = this.conBalItemSev.GetListByBalanceId(this.hdGuid.Value);
this.SaveBanlanceItemToViewState(listByBalanceId);
this.BindBalanceItem();
}
DataTable balanceStockByContractId = this.purchaseStock.GetBalanceStockByContractId(this.contractId, this.ViewState["BalanceId"].ToString());
this.ViewState["resource"] = balanceStockByContractId;
this.DataBindBalanceStock();
if (balanceStockByContractId.Rows.Count == 0)
{
this.divPurchase.Style.Add("display", "none");
}
this.FileLink1.MID = 1903;
this.FileLink1.FID = this.ViewState["BalanceId"].ToString();
this.FileLink1.Type = 1;
PayoutContractModel model2 = this.payoutContract.GetModel(this.contractId);
this.hfldPrjid.Value = model2.PrjGuid.ToString();
this.InitContractReport();
}
}
private void InitUpdateState()
{
PayoutBalanceModel model = this.payoutBalance.GetModel(this.ViewState["BalanceId"].ToString());
if (model != null)
{
this.contractId = model.ContractID;
this.InitContractInfo();
this.txtBalanceCode.Text = model.BalanceCode;
this.txtBalanceCode.ReadOnly = true;
this.txtBalanceMoney.Text = model.BalanceMoney.ToString();
this.txtBalanceDate.Text = model.BalanceDate.Value.ToShortDateString();
this.txtBalancePerson.Text = model.BalancePerson;
this.dropBalanceMode.SelectedValue = model.BalanceMode;
this.dropPayMode.SelectedValue = model.PayMode;
this.txtBalanceObj.Text = model.BalanceObject;
this.chkContainPending.Checked = model.ContainPending;
this.txtInputPerson.Text = model.InputPerson;
this.txtInputDate.Text = model.InputDate.Value.ToShortDateString();
this.txtNotes.Text = model.Notes;
this.hdGuid.Value = model.BalanceID;
this.txtDiffAmount.Text = this.GetDiffAmount(this.contractId, model.ContainPending).ToString();
}
}
private void ShowGuideLine()
{
if (!this.configSer.IsExist(this.contractId) || !(
from p in this.configSer
where p.ContractId == this.contractId
select p).FirstOrDefault <ConConfigContract>().IsBalanceAlarm)
{
this.trSate.Visible = false;
return;
}
string text = this.ViewState["BalanceId"].ToString();
if (!string.IsNullOrEmpty(text))
{
PayoutBalanceModel model = this.balance.GetModel(text);
PayoutContractModel model2 = new PayoutContract().GetModel(model.ContractID);
decimal balancedAmount = this.balance.GetBalancedAmount(model.ContractID, model.ContainPending);
this.lblBalancedAmount.Text = balancedAmount.ToString("0.000");
this.lblModifedAmount.Text = (model2.ModifiedMoney.HasValue ? model2.ModifiedMoney.ToString() : "0.000");
this.lblBalanceAmount.Text = (model.BalanceMoney.HasValue ? model.BalanceMoney.ToString() : "0.000");
decimal d = 0m;
if (model2.ModifiedMoney.HasValue && model.BalanceMoney.HasValue)
{
d = model2.ModifiedMoney.Value - balancedAmount;
}
decimal num = 0m;
if (model2.ModifiedMoney.HasValue && model2.ModifiedMoney.Value != 0m)
{
num = d / model2.ModifiedMoney.Value;
}
this.lblRate.Text = string.Format("{0:P}", num);
string balanceAmountState = this.balance.GetBalanceAmountState(num, this.contractId);
this.lblState.Text = balanceAmountState;
this.SetLableColor(Common2.GetColorByState(balanceAmountState));
}
}
private void AddBalance()
{
PayoutBalanceModel payoutBalanceModel = new PayoutBalanceModel();
payoutBalanceModel.BalanceID = this.ViewState["BalanceId"].ToString();
payoutBalanceModel.BalanceCode = this.txtBalanceCode.Text.Trim();
payoutBalanceModel.ContractID = this.contractId;
if (!string.IsNullOrEmpty(this.txtBalanceMoney.Text.Trim()))
{
payoutBalanceModel.BalanceMoney = new decimal?(Convert.ToDecimal(this.txtBalanceMoney.Text.Trim()));
}
payoutBalanceModel.BalancePerson = this.txtBalancePerson.Text.Trim();
if (!string.IsNullOrEmpty(this.txtBalanceDate.Text.Trim()))
{
payoutBalanceModel.BalanceDate = new DateTime?(Convert.ToDateTime(this.txtBalanceDate.Text.Trim()));
}
payoutBalanceModel.Annex = string.Empty;
payoutBalanceModel.FlowState = new int?(-1);
payoutBalanceModel.BalanceMode = this.dropBalanceMode.SelectedValue;
payoutBalanceModel.PayMode = this.dropPayMode.SelectedValue;
payoutBalanceModel.BalanceObject = this.txtBalanceObj.Text;
payoutBalanceModel.ContainPending = this.chkContainPending.Checked;
payoutBalanceModel.Notes = this.txtNotes.Text.Trim();
payoutBalanceModel.InputPerson = this.txtInputPerson.Text.Trim();
payoutBalanceModel.InputDate = new DateTime?(Convert.ToDateTime(this.txtInputDate.Text.Trim()));
try
{
if (this.payoutBalance.IsExists(payoutBalanceModel.BalanceCode, payoutBalanceModel.ContractID))
{
base.RegisterScript("top.ui.alert('此结算编号已经存在')");
}
else
{
this.payoutBalance.Add(payoutBalanceModel);
this.SaveBalanceStock();
StringBuilder stringBuilder = new StringBuilder();
bool flag = false;
ConConfigContract conConfigContract = (
from p in this.configSer
where p.ContractId == this.contractId
select p).FirstOrDefault <ConConfigContract>();
if (conConfigContract != null)
{
flag = conConfigContract.IsBalanceAlarm;
}
if (flag && this.payoutBalance.GreaterModifiedMoney(payoutBalanceModel))
{
stringBuilder.Append("top.ui.alert('结算金额大于合同金额\\n添加成功')");
}
else
{
stringBuilder.Append("top.ui.show('添加成功')");
}
stringBuilder.Append(Environment.NewLine);
stringBuilder.Append("winclose('BalanceEdit', 'PayoutBalanceEdit.aspx?ContractID=" + this.contractId + "', true)");
base.RegisterScript(stringBuilder.ToString());
}
}
catch (Exception)
{
base.RegisterHintScript("Add", false, string.Empty);
}
}
public void AddBalanceAlarm(PayoutBalanceModel balanceInfo, bool isContainPending)
{
PayoutContractModel model = new cn.justwin.contractBLL.PayoutContract().GetModel(balanceInfo.ContractID);
decimal num = model.ModifiedMoney.HasValue ? model.ModifiedMoney.Value : 0M;
bool flag1 = this.GetBalancedAmount(balanceInfo.ContractID, isContainPending) > num;
}
public void Update(PayoutBalanceModel model)
{
this.balance.Update(model, null);
}
public void Add(PayoutBalanceModel model)
{
this.balance.Add(model, null);
}
