private void dgList_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
//借方、贷方用不同颜色区分
if ((e.Item.ItemType == ListItemType.Item) ||
(e.Item.ItemType == ListItemType.AlternatingItem))
{
WebNumericEdit txtCrebitMoney = (WebNumericEdit)e.Item.FindControl("txtCrebitMoney");
decimal val = txtCrebitMoney.ValueDecimal;
if (val == 0)
{
e.Item.CssClass = "ItemGridTr1";
e.Item.Attributes["myclass"] = e.Item.CssClass;
}
else
{
e.Item.CssClass = "ItemGridTr2";
e.Item.Attributes["myclass"] = e.Item.CssClass;
}
}
//显示合计
if (e.Item.ItemType == ListItemType.Footer)
{
Label lblTotalDebitMoney = (Label)e.Item.FindControl("lblTotalDebitMoney");
lblTotalDebitMoney.Text = this.txtTotalDebitMoney.Value;
Label lblTotalCrebitMoney = (Label)e.Item.FindControl("lblTotalCrebitMoney");
lblTotalCrebitMoney.Text = this.txtTotalCrebitMoney.Value;
}
}
private void dgCostList_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
switch (e.Item.ItemType)
{
case ListItemType.Header:
break;
case ListItemType.Item:
case ListItemType.AlternatingItem:
string ud_sProjectCode = Request["ProjectCode"] + "";
UserControls.ExchangeRateControl ud_ucExchangeRate = (UserControls.ExchangeRateControl)e.Item.FindControl("ucExchangeRate");
UserControls.InputCostBudgetDtl ud_ucCostBudgetDtl = (UserControls.InputCostBudgetDtl)e.Item.FindControl("ucCostBudgetDtl");
WebNumericEdit ud_txtCostTotalChangeCash = (WebNumericEdit)e.Item.FindControl("txtCostTotalChangeCash");
DataRowView ud_drvItem = (DataRowView)e.Item.DataItem;
ud_ucCostBudgetDtl.ProjectCode = ud_sProjectCode;
ud_txtCostTotalChangeCash.Enabled = false;
ud_ucExchangeRate.IsShowTitle = false;
ud_ucExchangeRate.IsAllowCashChange = false;
ud_ucExchangeRate.Cash = BLL.ConvertRule.ToDecimal(ud_drvItem["Cash"]);
if (ud_drvItem["MoneyType"].ToString() != "")
{
ud_ucExchangeRate.ExchangeRate = BLL.ConvertRule.ToDecimal(ud_drvItem["ExchangeRate"]);
ud_ucExchangeRate.MoneyType = ud_drvItem["MoneyType"].ToString();
}
if (HttpUtility.HtmlDecode(e.Item.Cells[1].Text).Trim() != "")
{
((UserControls.InputCostBudgetDtl)e.Item.FindControl("ucCostBudgetDtl")).Enable = false;
ud_ucExchangeRate.EditMode = false;
}
else
{
((UserControls.InputCostBudgetDtl)e.Item.FindControl("ucCostBudgetDtl")).Enable = true;
ud_ucExchangeRate.EditMode = true;
}
ud_ucExchangeRate.BindControl();
break;
case ListItemType.Footer:
//显示合计金额
((Label)e.Item.FindControl("lblSumCostOriginalMoney")).Text = BLL.MathRule.GetDecimalShowString(ViewState["SumCostOriginalMoney"]);
((Label)e.Item.FindControl("lblSumCostTotalChangeMoney")).Text = BLL.MathRule.GetDecimalShowString(ViewState["SumCostTotalChangeMoney"]);
((Label)e.Item.FindControl("lblSumCostChangeMoney")).Text = BLL.MathRule.GetDecimalShowString(ViewState["SumCostChangeMoney"]);
((Label)e.Item.FindControl("lblSumCostNewMoney")).Text = BLL.MathRule.GetDecimalShowString(ViewState["SumCostNewMoney"]);
break;
default:
break;
}
}
public string SaveToSession()
{
string alertMsg = "";
try
{
string contractCode = ContractCode;
string projectCode = Request["ProjectCode"] + "";
EntityData entity = ReadEntitySession();
entity.SetCurrentTable("ContractCost");
foreach (DataRow dr in entity.Tables["ContractCost"].Select(String.Format("ContractCostCode='{0}'", ContractCostCode)))
{
dr["CostCode"] = ucCostBudgetDtl.CostCode;
dr["CostBudgetSetCode"] = ucCostBudgetDtl.CostBudgetSetCode;
dr["PBSType"] = ucCostBudgetDtl.PBSType;
dr["PBSCode"] = ucCostBudgetDtl.PBSCode;
dr["Money"] = txtTotalMoney.ValueDecimal;
dr["Description"] = txtDescription.Text.Trim();
}
foreach (DataGridItem li in this.dgCostList.Items)
{
string planningPayDate = ((AspWebControl.Calendar)li.FindControl("dtPlanningPayDate")).Value;
string payConditionText = ((HtmlInputText)li.FindControl("txtPayConditionText")).Value.Trim();
//((TextBox)li.FindControl("txtPayConditionText")).Text.Trim();
WebNumericEdit txtMoney = (WebNumericEdit)li.FindControl("txtMoney");
string contractCostPlanCode = li.Cells[0].Text;
foreach (DataRow dr in entity.Tables["ContractCostPlan"].Select(String.Format("ContractCostPlanCode='{0}'", contractCostPlanCode)))
{
dr["Money"] = txtMoney.ValueDecimal;
dr["PayConditionText"] = payConditionText;
if (planningPayDate != "")
{
dr["PlanningPayDate"] = planningPayDate;
}
else
{
dr["PlanningPayDate"] = System.DBNull.Value;
}
}
}
WriteEntitySession(entity);
entity.Dispose();
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "");
Response.Write(Rms.Web.JavaScript.Alert(true, "明细保存出错：" + ex.Message));
}
return(alertMsg);
}
protected void fvExchangeRate_DataBound(object sender, EventArgs e)
{
DataRowView ud_drvItem = (DataRowView)this.fvExchangeRate.DataItem;
switch (this.fvExchangeRate.CurrentMode)
{
case FormViewMode.Edit:
DropDownList ddlMoneyType = (DropDownList)this.fvExchangeRate.FindControl("ddlMoneyType");
WebNumericEdit txtCash = (WebNumericEdit)this.fvExchangeRate.FindControl("txtCash");
WebNumericEdit txtExchangeRate = (WebNumericEdit)this.fvExchangeRate.FindControl("txtExchangeRate");
txtCash.ClientSideEvents.ValueChange = this.UniqueID + "InfraCashMoneyChange";
txtExchangeRate.ClientSideEvents.ValueChange = this.UniqueID + "InfraCashMoneyChange";
ddlMoneyType.DataSource = this.MoneyTypeDataSource;
ddlMoneyType.DataBind();
ddlMoneyType.SelectedIndex = ddlMoneyType.Items.IndexOf(ddlMoneyType.Items.FindByText(ud_drvItem["MoneyType"].ToString()));
if (ddlMoneyType.SelectedItem.Text == "ÈËÃñ±Ò (RMB)")
{
txtExchangeRate.Enabled = false;
txtExchangeRate.ValueDecimal = 1m;
}
else
{
txtExchangeRate.Enabled = true;
}
if (this.hidExchangeRate.Value.Trim() == string.Empty)
{
txtExchangeRate.ValueDecimal = RmsPM.BLL.ConvertRule.ToDecimal(ddlMoneyType.SelectedValue);
}
break;
case FormViewMode.ReadOnly:
HtmlTableCell tdForeignCurrency = (HtmlTableCell)this.fvExchangeRate.FindControl("tdForeignCurrency");
if (ud_drvItem["MoneyType"].ToString() == "ÈËÃñ±Ò (RMB)")
{
tdForeignCurrency.Visible = false;
}
else
{
tdForeignCurrency.Visible = true;
}
break;
}
}
protected void uwgModules_InitializeRow(object sender, Infragistics.WebUI.UltraWebGrid.RowEventArgs e)
{
// Build dataset containing all pane names
DataSet ds = new DataSet();
DataTable dt = ds.Tables.Add("PaneList");
dt.Columns.Add("Value", Type.GetType("System.Int32"));
dt.Columns.Add("Text", Type.GetType("System.String"));
dt.Rows.Add(new object[] { 0, "LeftPane" });
dt.Rows.Add(new object[] { 1, "ContentPane" });
dt.Rows.Add(new object[] { 2, "RightPane" });
// Get properties for this row
int moduleDefId = (Int16)e.Row.Cells.FromKey(CST_FIELD_WEBPARTID).Value;
DataRow drProperties = Configuration.GetModuleProperties(moduleDefId);
// Find pane list in current row
TemplatedColumn currentTempColPane = (TemplatedColumn)e.Row.Cells.FromKey(CST_FIELD_PANENAME).Column;
CellItem currentCellItemPane = (CellItem)currentTempColPane.CellItems[e.Row.Index];
DropDownList currentDDL = (DropDownList)currentCellItemPane.FindControl("ddlPaneList");
// Find module order in current row
TemplatedColumn currentTempColOrder = (TemplatedColumn)e.Row.Cells.FromKey(CST_FIELD_SORT).Column;
CellItem currentCellItemOrder = (CellItem)currentTempColOrder.CellItems[e.Row.Index];
WebNumericEdit currentWNE = (WebNumericEdit)currentCellItemOrder.FindControl("wneModuleOrder");
// Update data in pane list
currentDDL.DataSource = ds;
currentDDL.DataTextField = "Text";
currentDDL.DataValueField = "Value";
currentDDL.DataBind();
int selectedPane = 0;
if (drProperties != null)
{
selectedPane = (Int16)drProperties[CST_FIELD_PANEID];
}
currentDDL.SelectedIndex = selectedPane; // select pane name
// Update data in edit for module order
currentWNE.Value = 0;
if (drProperties != null)
{
currentWNE.Value = drProperties[CST_FIELD_SORT].ToString() != string.Empty? Convert.ToInt32(drProperties[CST_FIELD_SORT].ToString()): 0;
}
// free memory
ds.Dispose();
}
private string SaveToSession()
{
string alertMsg = "";
try
{
string contractCode = this.txtContractCode.Value;
string projectCode = Request["ProjectCode"] + "";
EntityData entity = (EntityData)Session["ContractEntity"];
foreach (DataGridItem li in this.dgFactValueList.Items)
{
string ContractProductionCode = li.Cells[0].Text;
string FactProductionDate = ((AspWebControl.Calendar)li.FindControl("dtFactProductionDate")).Value;
WebNumericEdit txtFactValue = (WebNumericEdit)li.FindControl("txtFactValue");
foreach (DataRow dr in entity.Tables["ContractProduction"].Select(String.Format("ContractProductionCode='{0}'", ContractProductionCode)))
{
dr["ProductionValue"] = txtFactValue.ValueDecimal;
if (FactProductionDate != "")
{
dr["ProductionDate"] = FactProductionDate;
}
else
{
dr["ProductionDate"] = System.DBNull.Value;
}
}
}
Session["ContractEntity"] = entity;
entity.Dispose();
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "");
Response.Write(Rms.Web.JavaScript.Alert(true, "保存出错：" + ex.Message));
}
return(alertMsg);
}
protected void uwtProperties_ButtonClicked(object sender, Infragistics.WebUI.UltraWebToolbar.ButtonEvent be)
{
if (be.Button.Key.Equals("btnSave"))
{
DataSet dsResult = new DataSet();
DataTable dt = dsResult.Tables.Add(CST_TABLE_WEBPARTS);
dt.Columns.Add(CST_FIELD_WEBPARTID, Type.GetType("System.Int16"));
dt.Columns.Add(CST_FIELD_PANEID, Type.GetType("System.Int16"));
dt.Columns.Add(CST_FIELD_SORT, Type.GetType("System.Int16"));
for (int i = 0; i < uwgModules.Rows.Count; i++)
{
UltraGridRow currentRow = uwgModules.Rows[i];
bool isPresent = (bool)currentRow.Cells.FromKey(CST_FIELD_ISPRESENT).Value;
if (isPresent)
{
// get module identifier
int moduleDefId = Convert.ToInt32(currentRow.Cells.FromKey(CST_FIELD_WEBPARTID).Value.ToString());
// get pane name
TemplatedColumn tempColPane = (TemplatedColumn)currentRow.Cells.FromKey(CST_FIELD_PANENAME).Column;
DropDownList ddlPaneList = (DropDownList)((CellItem)tempColPane.CellItems[currentRow.Index]).FindControl("ddlPaneList");
int paneId = Convert.ToInt32(ddlPaneList.SelectedValue);
// get module order
TemplatedColumn tempColOrder = (TemplatedColumn)currentRow.Cells.FromKey(CST_FIELD_SORT).Column;
WebNumericEdit wneModuleOrder = (WebNumericEdit)((CellItem)tempColOrder.CellItems[currentRow.Index]).FindControl("wneModuleOrder");
int moduleOrder = wneModuleOrder.ValueInt;
// add new module
dt.Rows.Add(new object[] { moduleDefId, paneId, moduleOrder });
}
}
// save properties
SaveModules(dsResult);
// refresh document
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "close", "<script>opener.document.location.reload();window.close();</script>");
}
else if (be.Button.Key.Equals("btnCancel"))
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "close", "<script>window.close();</script>");
}
}
protected void gvPayoutItem_RowDataBound(object sender, System.Web.UI.WebControls.GridViewRowEventArgs e)
{
switch (e.Row.RowType)
{
case DataControlRowType.DataRow:
DataRowView ud_drvItem = (DataRowView)e.Row.DataItem;
WebNumericEdit ud_txtPayoutCash = (WebNumericEdit)e.Row.FindControl("txtPayoutCash");
WebNumericEdit ud_txtPayoutExchangeRate = (WebNumericEdit)e.Row.FindControl("txtPayoutExchangeRate");
Label ud_lblPayoutItemMoney = (Label)e.Row.FindControl("lblPayoutItemMoney");
RmsPM.Web.UserControls.InputSubject ud_ucPayoutInputSubject = (RmsPM.Web.UserControls.InputSubject)e.Row.FindControl("ucPayoutInputSubject");
string ud_sPaymentMoneyType = ud_drvItem["PaymentMoneyType"] == DBNull.Value ? string.Empty : ud_drvItem["PaymentMoneyType"].ToString();
bool ud_bChecked = false;
if (ud_drvItem["Checked"] != DBNull.Value && ud_drvItem["Checked"].ToString() == "1")
{
ud_bChecked = true;
}
if (ud_sPaymentMoneyType == ucExchangeRate.MoneyType)
{
ud_txtPayoutExchangeRate.Enabled = false;
}
else
{
ud_txtPayoutExchangeRate.Enabled = true;
}
decimal ud_dePayoutItemMoney = ud_txtPayoutCash.ValueDecimal * ud_txtPayoutExchangeRate.ValueDecimal;
ud_lblPayoutItemMoney.Text = ud_dePayoutItemMoney.ToString("N");
break;
}
}
/// <summary>
/// 屏幕数据保存到临时表
/// </summary>
/// <returns></returns>
private DataTable ScreenToTable(bool isBindGrid)
{
DataTable tb = BLL.PaymentRule.GeneratePayoutItemTable("");
BLL.PaymentRule.VoucherDetailAddColumnSubjectName(tb, this.txtSubjectSetCode.Value);
tb.Columns.Add("SubjectHint", typeof(String));
foreach (DataGridItem item in this.dgList.Items)
{
HtmlInputHidden txtSelect = (HtmlInputHidden)item.FindControl("txtSelect");
HtmlInputHidden txtPayoutItemCode = (HtmlInputHidden)item.FindControl("txtPayoutItemCode");
HtmlInputHidden txtSummary = (HtmlInputHidden)item.FindControl("txtSummary");
HtmlInputHidden txtItemMoney = (HtmlInputHidden)item.FindControl("txtItemMoney");
HtmlInputHidden txtTotalPayoutMoney = (HtmlInputHidden)item.FindControl("txtTotalPayoutMoney");
HtmlInputHidden txtRemainItemMoney = (HtmlInputHidden)item.FindControl("txtRemainItemMoney");
WebNumericEdit txtPayoutMoney = (WebNumericEdit)item.FindControl("txtPayoutMoney");
// HtmlInputText txtPayoutMoney = (HtmlInputText)item.FindControl("txtPayoutMoney");
HtmlInputHidden txtCostCode = (HtmlInputHidden)item.FindControl("txtCostCode");
HtmlInputHidden txtCostName = (HtmlInputHidden)item.FindControl("txtCostName");
RmsPM.Web.UserControls.InputSubject ucInputSubject = (RmsPM.Web.UserControls.InputSubject)item.FindControl("ucInputSubject");
HtmlInputHidden txtBuildingCodeAll = (HtmlInputHidden)item.FindControl("txtBuildingCodeAll");
HtmlInputHidden txtBuildingNameAll = (HtmlInputHidden)item.FindControl("txtBuildingNameAll");
HtmlInputHidden txtPaymentItemCode = (HtmlInputHidden)item.FindControl("txtPaymentItemCode");
HtmlInputHidden txtPaymentID = (HtmlInputHidden)item.FindControl("txtPaymentID");
RmsPM.Web.UserControls.ExchangeRateControl ucItemCash = (RmsPM.Web.UserControls.ExchangeRateControl)item.FindControl("ucItemCash");
string PayoutItemCode = txtPayoutItemCode.Value;
/*
* if ( txtPayoutMoney.Value != "")
* {
* if ( !Rms.Check.StringCheck.IsNumber(txtPayoutMoney.Value))
* {
* Response.Write(Rms.Web.JavaScript.Alert(true, "金额数字格式不正确 !"));
* return null;
* }
* }
*/
DataRow dr = tb.NewRow();
dr["Checked"] = BLL.ConvertRule.ToInt(txtSelect.Value);
dr["PayoutItemCode"] = PayoutItemCode;
dr["Summary"] = txtSummary.Value;
dr["ItemMoney"] = BLL.ConvertRule.ToDecimalObj(txtItemMoney.Value);
dr["TotalPayoutMoney"] = BLL.ConvertRule.ToDecimalObj(txtTotalPayoutMoney.Value);
dr["RemainItemMoney"] = BLL.ConvertRule.ToDecimalObj(txtRemainItemMoney.Value);
dr["PayoutCash"] = ucItemCash.Cash;
dr["MoneyType"] = ucItemCash.MoneyType;
dr["ExchangeRate"] = ucItemCash.ExchangeRate;
dr["PayoutMoney"] = ucItemCash.Cash * ucItemCash.ExchangeRate;
// dr["PayoutMoney"] = txtPayoutMoney.ValueDecimal;
// dr["PayoutMoney"] = BLL.ConvertRule.ToDecimalObj(txtPayoutMoney.Value);
dr["CostCode"] = txtCostCode.Value;
dr["CostName"] = txtCostName.Value;
dr["SubjectCode"] = ucInputSubject.Value;
dr["SubjectName"] = ucInputSubject.Text;
dr["SubjectHint"] = ucInputSubject.Hint;
dr["BuildingCodeAll"] = txtBuildingCodeAll.Value;
dr["BuildingNameAll"] = txtBuildingNameAll.Value;
dr["PaymentItemCode"] = txtPaymentItemCode.Value;
dr["PaymentID"] = txtPaymentID.Value;
tb.Rows.Add(dr);
}
if (isBindGrid)
{
this.dgList.DataSource = tb;
this.dgList.DataBind();
}
return(tb);
}
private string SaveToSession()
{
string alertMsg = "";
try
{
string contractCode = this.txtContractCode.Value;
string projectCode = Request["ProjectCode"] + "";
EntityData entity = ReadEntitySession();
string contractLabel = txtContractChangeCode.Value;
//合同变更基本信息
entity.SetCurrentTable("ContractChange");
foreach (DataRow dr in entity.CurrentTable.Select(String.Format("ContractChangeCode='{0}'", contractLabel), "", DataViewRowState.CurrentRows))
{
dr["Voucher"] = txtVoucher.Value;
dr["ContractChangeId"] = txtChangeId.Value;
dr["ChangeReason"] = txtChangeReason.Value;
dr["SupplierChangeMoney"] = txtSupplierChangeMoney.ValueDecimal;
dr["ConsultantAuditMoney"] = txtConsultantAuditMoney.ValueDecimal;
dr["ProjectAuditMoney"] = txtProjectAuditMoney.ValueDecimal;
dr["ChangeType"] = this.ddlChangeType.SelectedItem.Value;
}
//款项明细
entity.SetCurrentTable("ContractCostChange");
foreach (DataGridItem li in this.dgCostList.Items)
{
string contractCostChangeCode = li.Cells[0].Text;
string contractCostCode = HttpUtility.HtmlDecode(li.Cells[1].Text).Trim();
UserControls.InputCostBudgetDtl ucCostBudgetDtl = (UserControls.InputCostBudgetDtl)li.FindControl("ucCostBudgetDtl");
UserControls.ExchangeRateControl ud_ucExchangeRate = (UserControls.ExchangeRateControl)li.FindControl("ucExchangeRate");
WebNumericEdit txtCostChangeCash = (WebNumericEdit)li.FindControl("txtCostChangeCash");
HtmlInputText txtDescription = (HtmlInputText)li.FindControl("txtDescription");
foreach (DataRow dr in entity.CurrentTable.Select(String.Format("ContractCostChangeCode='{0}'", contractCostChangeCode), "", DataViewRowState.CurrentRows))
{
decimal ud_deCostCash, ud_deCostOriginalCash, ud_deCostTotalChangeCash, ud_deCostChangeCash, ud_deCostNewCash, ud_deExchangeRate;
decimal ud_deCostMoney, ud_deCostOriginalMoney, ud_deCostTotalChangeMoney, ud_deCostChangeMoney, ud_deCostNewMoney;
ud_deCostCash = (decimal)dr["Cash"];
ud_deCostOriginalCash = (decimal)dr["OriginalCash"];
ud_deCostTotalChangeCash = (decimal)dr["TotalChangeCash"];
ud_deCostMoney = (decimal)dr["Money"];
ud_deCostOriginalMoney = (decimal)dr["OriginalMoney"];
ud_deCostTotalChangeMoney = (decimal)dr["TotalChangeMoney"];
ud_deCostChangeCash = txtCostChangeCash.ValueDecimal;
ud_deExchangeRate = ud_ucExchangeRate.ExchangeRate;
ud_deCostNewCash = ud_deCostOriginalCash + ud_deCostTotalChangeCash + ud_deCostChangeCash;
ud_deCostNewMoney = ud_deCostNewCash * ud_deExchangeRate;
ud_deCostChangeMoney = ud_deCostChangeCash * ud_deExchangeRate;
dr["ChangeCash"] = ud_deCostChangeCash;
dr["NewCash"] = ud_deCostNewCash;
dr["ChangeMoney"] = ud_deCostChangeMoney;
dr["NewMoney"] = ud_deCostNewMoney;
dr["Description"] = txtDescription.Value;
if (contractCostCode == "")
{
dr["CostCode"] = ucCostBudgetDtl.CostCode;
dr["CostBudgetSetCode"] = ucCostBudgetDtl.CostBudgetSetCode;
dr["PBSType"] = ucCostBudgetDtl.PBSType;
dr["PBSCode"] = ucCostBudgetDtl.PBSCode;
dr["MoneyType"] = ud_ucExchangeRate.MoneyType;
dr["ExchangeRate"] = ud_ucExchangeRate.ExchangeRate;
}
}
}
WriteEntitySession(entity);
entity.Dispose();
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "");
Response.Write(Rms.Web.JavaScript.Alert(true, "保存Session出错：" + ex.Message));
}
return(alertMsg);
}
public string SaveToSession()
{
string alertMsg = "";
try
{
string projectCode = Request["ProjectCode"] + "";
EntityData entity = ReadEntitySession();
decimal ud_deCostMoney = Decimal.Zero;
//保存币种金额
foreach (DataGridItem ud_dgItem in dgCostCash.Items)
{
string contractCostCashCode = ud_dgItem.Cells[1].Text;
foreach (DataRow dr in entity.Tables["ContractCostCash"].Select(String.Format("ContractCostCashCode='{0}'", contractCostCashCode)))
{
UserControls.ExchangeRateControl ud_ucExchangeRate = (UserControls.ExchangeRateControl)ud_dgItem.FindControl("ucExchangeRate");
decimal ud_deCash = ud_ucExchangeRate.Cash;
decimal ud_deMoney = ud_deCash * ud_ucExchangeRate.ExchangeRate;
try
{
dr["amount"] = ud_ucExchangeRate.Amount;
}
catch { }
try
{
dr["UnitPrise"] = ud_ucExchangeRate.UnitPrise;
}
catch { }
dr["Cash"] = ud_deCash;
dr["MoneyType"] = ud_ucExchangeRate.MoneyType;
dr["ExchangeRate"] = ud_ucExchangeRate.ExchangeRate;
dr["Money"] = ud_deMoney;
ud_deCostMoney += ud_deMoney;
}
}
//保存款项明细
foreach (DataRow dr in entity.Tables["ContractCost"].Select(String.Format("ContractCostCode='{0}'", this.ContractCostCode)))
{
//try
//{
// dr["amount"] = ucCostBudgetDtl.Amount;
//}
//catch { }
//try
//{
// dr["UnitPrise"] = ucCostBudgetDtl.UnitPrise;
//}
//catch { }
dr["CostCode"] = ucCostBudgetDtl.CostCode;
dr["CostBudgetSetCode"] = ucCostBudgetDtl.CostBudgetSetCode;
dr["PBSType"] = ucCostBudgetDtl.PBSType;
dr["PBSCode"] = ucCostBudgetDtl.PBSCode;
dr["Description"] = txtDescription.Text.Trim();
dr["Money"] = ud_deCostMoney;
}
//保存付款计划
foreach (DataGridItem ud_dgItem in dgCostPlan.Items)
{
string contractCostPlanCode = ud_dgItem.Cells[1].Text;
string planningPayDate = ((AspWebControl.Calendar)ud_dgItem.FindControl("dtPlanningPayDate")).Value;
string payConditionText = ((HtmlInputText)ud_dgItem.FindControl("txtPayConditionText")).Value.Trim();
WebNumericEdit txtMoney = (WebNumericEdit)ud_dgItem.FindControl("txtMoney");
foreach (DataRow dr in entity.Tables["ContractCostPlan"].Select(String.Format("ContractCostPlanCode='{0}'", contractCostPlanCode)))
{
dr["Money"] = txtMoney.ValueDecimal;
dr["PayConditionText"] = payConditionText;
if (planningPayDate != "")
{
dr["PlanningPayDate"] = planningPayDate;
}
else
{
dr["PlanningPayDate"] = System.DBNull.Value;
}
}
}
WriteEntitySession(entity);
entity.Dispose();
return(alertMsg);
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "");
Response.Write(Rms.Web.JavaScript.Alert(true, "明细保存出错：" + ex.Message));
throw ex;
}
}
/// <summary>
/// 屏幕数据保存到session临时表
/// </summary>
/// <returns></returns>
private DataTable SaveToTempTable(bool isBindGrid)
{
try
{
DataTable dt = (DataTable)Session["VoucherDetailTable"];
// dt.Rows.Clear();
foreach (DataGridItem item in this.dgList.Items)
{
if (item.ItemType == ListItemType.Item || item.ItemType == ListItemType.AlternatingItem)
{
TextBox txtSummary = (TextBox)item.FindControl("txtSummary");
RmsPM.Web.UserControls.InputSubject ucInputSubject = (RmsPM.Web.UserControls.InputSubject)item.FindControl("ucInputSubject");
// TextBox txtDebitMoney = (TextBox)item.FindControl("txtDebitMoney");
// TextBox txtCrebitMoney = (TextBox)item.FindControl("txtCrebitMoney");
WebNumericEdit txtDebitMoney = (WebNumericEdit)item.FindControl("txtDebitMoney");
WebNumericEdit txtCrebitMoney = (WebNumericEdit)item.FindControl("txtCrebitMoney");
TextBox txtContractID = (TextBox)item.FindControl("txtContractID");
HtmlInputHidden txtContractCode = (HtmlInputHidden)item.FindControl("txtContractCode");
HtmlInputHidden txtSupplyCode = (HtmlInputHidden)item.FindControl("txtSupplyCode");
HtmlInputHidden txtSupplyName = (HtmlInputHidden)item.FindControl("txtSupplyName");
HtmlInputHidden txtCustCode = (HtmlInputHidden)item.FindControl("txtCustCode");
HtmlInputHidden txtCustName = (HtmlInputHidden)item.FindControl("txtCustName");
RmsPM.Web.UserControls.InputUnit ucUFUnit = (RmsPM.Web.UserControls.InputUnit)item.FindControl("ucUFUnit");
RmsPM.Web.UserControls.InputUser ucPaymentCheckPerson = (RmsPM.Web.UserControls.InputUser)item.FindControl("ucPaymentCheckPerson");
RmsPM.Web.UserControls.InputPBS ucPBS = (RmsPM.Web.UserControls.InputPBS)item.FindControl("ucPBS");
HtmlInputHidden txtUFProjectCode = (HtmlInputHidden)item.FindControl("txtUFProjectCode");
HtmlInputHidden txtUFProjectName = (HtmlInputHidden)item.FindControl("txtUFProjectName");
TextBox txtBillNo = (TextBox)item.FindControl("txtBillNo");
HtmlInputHidden txtVoucherDetailCode = (HtmlInputHidden)item.FindControl("txtVoucherDetailCode");
string VoucherDetailCode = txtVoucherDetailCode.Value;
DataRow dr = dt.Select("VoucherDetailCode='" + VoucherDetailCode + "'")[0];
dr["VoucherDetailCode"] = VoucherDetailCode;
dr["Summary"] = txtSummary.Text;
dr["SubjectCode"] = ucInputSubject.Value;
dr["SubjectName"] = ucInputSubject.Text;
dr["SubjectHint"] = ucInputSubject.Hint;
dr["ContractID"] = txtContractID.Text;
dr["ContractCode"] = txtContractCode.Value;
dr["SupplyCode"] = txtSupplyCode.Value.Trim();
dr["SupplyName"] = txtSupplyName.Value;
dr["CustCode"] = txtCustCode.Value.Trim();
dr["CustName"] = txtCustName.Value;
dr["UFUnitCode"] = ucUFUnit.Value;
dr["UFUnitName"] = ucUFUnit.Text;
dr["PaymentCheckPerson"] = ucPaymentCheckPerson.Value;
dr["PaymentCheckPersonName"] = ucPaymentCheckPerson.Text;
dr["PBSType"] = ucPBS.PBSType;
dr["PBSCode"] = ucPBS.Value;
dr["PBSName"] = ucPBS.Text;
dr["UFProjectCode"] = txtUFProjectCode.Value.Trim();
dr["UFProjectName"] = txtUFProjectName.Value;
dr["BillNo"] = txtBillNo.Text;
dr["DebitMoney"] = txtDebitMoney.ValueDecimal;
dr["CrebitMoney"] = txtCrebitMoney.ValueDecimal;
}
}
Session["VoucherDetailTable"] = dt;
if (isBindGrid)
{
BindDataGrid(dt);
}
return(dt);
}
catch (Exception ex)
{
throw ex;
}
}
private string SaveToSession()
{
string alertMsg = "";
try
{
string ud_sContractCode = this.txtContractCode.Value;
string ud_sProjectCode = Request["ProjectCode"] + "";
string ud_sContractCostCode = this.ddlCost.SelectedValue;
EntityData entity = this.ReadEntitySession();
foreach (DataRow dr in entity.Tables["ContractCost"].Select(string.Format("ContractCostCode='{0}'", ud_sContractCostCode)))
{
if (this.ccStartDay.Value == "")
{
dr["PlanStartDate"] = DBNull.Value;
}
else
{
dr["PlanStartDate"] = this.ccStartDay.Value;
}
if (this.ccEndDay.Value == "")
{
dr["PlanEndDate"] = DBNull.Value;
}
else
{
dr["PlanEndDate"] = this.ccEndDay.Value;
}
}
foreach (DataGridItem ud_Item in this.dgCostList.Items)
{
AspWebControl.Calendar ud_dtPlanningPayDate = (AspWebControl.Calendar)ud_Item.FindControl("dtPlanningPayDate");
WebNumericEdit ud_txtMoney = (WebNumericEdit)ud_Item.FindControl("txtMoney");
HtmlInputText ud_txtPayConditionText = (HtmlInputText)ud_Item.FindControl("txtPayConditionText");
string ud_sContractCostPlanCode = ud_Item.Cells[1].Text;
bool ud_bModify = false;
foreach (DataRow dr in entity.Tables["ContractCostPlan"].Select(String.Format("ContractCostPlanCode='{0}'", ud_sContractCostPlanCode)))
{
if (ud_dtPlanningPayDate.Value == "")
{
dr["PlanningPayDate"] = DBNull.Value;
}
else
{
dr["PlanningPayDate"] = ud_dtPlanningPayDate.Value;
}
dr["Money"] = ud_txtMoney.ValueDecimal;
dr["PayConditionText"] = ud_txtPayConditionText.Value;
ud_bModify = true;
}
if (!ud_bModify)
{
DataRow ud_drNew = entity.Tables["ContractCostPlan"].NewRow();
ud_drNew["ContractCode"] = ud_sContractCode;
ud_drNew["ContractCostCode"] = ud_sContractCostCode;
ud_drNew["ContractCostPlanCode"] = ud_sContractCostPlanCode;
if (ud_dtPlanningPayDate.Value == "")
{
ud_drNew["PlanningPayDate"] = DBNull.Value;
}
else
{
ud_drNew["PlanningPayDate"] = ud_dtPlanningPayDate.Value;
}
ud_drNew["Money"] = ud_txtMoney.ValueDecimal;
ud_drNew["PayConditionText"] = ud_txtPayConditionText.Value;
entity.Tables["ContractCostPlan"].Rows.Add(ud_drNew);
}
}
this.WriteEntitySession(entity);
entity.Dispose();
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "");
Response.Write(Rms.Web.JavaScript.Alert(true, "保存出错：" + ex.Message));
}
return(alertMsg);
}
/// <summary>
/// 屏幕数据保存到临时表
/// </summary>
/// <returns></returns>
private DataTable ScreenToTable(bool isBindGrid)
{
// DataTable ud_dtDtl = RmsPM.BLL.PaymentRule.GeneratePayoutItemTable("");
DataTable ud_dtDtl = GetDefaultPayoutItemTable();
RmsPM.BLL.PaymentRule.VoucherDetailAddColumnSubjectName(ud_dtDtl, this.txtSubjectSetCode.Value);
ud_dtDtl.Columns.Add("SubjectHint", typeof(String));
decimal ud_dePayoutExchangeRate = ucExchangeRate.ExchangeRate;
foreach (GridViewRow ud_gvrRow in this.gvPayoutItem.Rows)
{
HtmlInputHidden txtSelect = (HtmlInputHidden)ud_gvrRow.FindControl("txtSelect");
HtmlInputHidden txtPayoutItemCode = (HtmlInputHidden)ud_gvrRow.FindControl("txtPayoutItemCode");
HtmlInputHidden txtPaymentItemCode = (HtmlInputHidden)ud_gvrRow.FindControl("txtPaymentItemCode");
HtmlInputHidden txtSummary = (HtmlInputHidden)ud_gvrRow.FindControl("txtSummary");
HtmlInputHidden txtItemMoney = (HtmlInputHidden)ud_gvrRow.FindControl("txtItemMoney");
HtmlInputHidden txtTotalPayoutCash = (HtmlInputHidden)ud_gvrRow.FindControl("txtTotalPayoutCash");
HtmlInputHidden txtRemainItemCash = (HtmlInputHidden)ud_gvrRow.FindControl("txtRemainItemCash");
HtmlInputHidden txtCostCode = (HtmlInputHidden)ud_gvrRow.FindControl("txtCostCode");
HtmlInputHidden txtCostName = (HtmlInputHidden)ud_gvrRow.FindControl("txtCostName");
HtmlInputHidden txtPaymentID = (HtmlInputHidden)ud_gvrRow.FindControl("txtPaymentID");
WebNumericEdit txtPayoutCash = (WebNumericEdit)ud_gvrRow.FindControl("txtPayoutCash");
RmsPM.Web.UserControls.InputSubject ucPayoutInputSubject = (RmsPM.Web.UserControls.InputSubject)ud_gvrRow.FindControl("ucPayoutInputSubject");
WebNumericEdit txtPayoutExchangeRate = (WebNumericEdit)ud_gvrRow.FindControl("txtPayoutExchangeRate");
string ud_sPayoutItemCode = txtPayoutItemCode.Value;
string ud_sPayoutItemCodeFilter = string.Format("PayoutItemCode='{0}'", ud_sPayoutItemCode);
foreach (DataRow dr in ud_dtDtl.Select(ud_sPayoutItemCodeFilter))
{
dr["Checked"] = RmsPM.BLL.ConvertRule.ToInt(txtSelect.Value);
dr["PayoutCash"] = txtPayoutCash.ValueDecimal;
dr["MoneyType"] = dr["PaymentMoneyType"];
dr["ExchangeRate"] = txtPayoutExchangeRate.ValueDecimal;
if (ucExchangeRate.MoneyType == "人民币 (RMB)")
{
dr["PayoutMoney"] = txtPayoutCash.ValueDecimal * txtPayoutExchangeRate.ValueDecimal;
}
else
{
dr["PayoutMoney"] = txtPayoutCash.ValueDecimal * (decimal)dr["ExchangeRate"];
}
dr["PayoutMoneyType"] = ucExchangeRate.MoneyType;
dr["PayoutExchangeRate"] = ucExchangeRate.ExchangeRate;
dr["SubjectCode"] = ucPayoutInputSubject.Value;
dr["SubjectName"] = ucPayoutInputSubject.Text;
dr["SubjectHint"] = ucPayoutInputSubject.Hint;
}
}
if (isBindGrid)
{
this.BindGridView(ud_dtDtl);
}
return(ud_dtDtl);
}
