/// <summary>
/// 屏幕数据保存到临时表
/// </summary>
/// <returns></returns>
private DataTable ScreenToTable(bool isBindGrid)
{
DataTable tb = BLL.PaymentRule.GeneratePayoutItemTable(this.txtPayoutCode.Value);
BLL.PaymentRule.VoucherDetailAddColumnSubjectName(tb, this.txtSubjectSetCode.Value);
tb.Columns.Add("SubjectHint", typeof(String));
foreach (DataGridItem item in this.dgList.Items)
{
HtmlInputHidden txtPayoutItemCode = (HtmlInputHidden)item.FindControl("txtPayoutItemCode");
string PayoutItemCode = txtPayoutItemCode.Value;
RmsPM.Web.UserControls.InputSubject ucInputSubject = (RmsPM.Web.UserControls.InputSubject)item.FindControl("ucInputSubject");
DataRow[] drs = tb.Select("PayoutItemCode='" + PayoutItemCode + "'");
if (drs.Length <= 0)
{
throw new Exception("未找到付款单明细");
}
DataRow dr = drs[0];
dr["SubjectCode"] = ucInputSubject.Value;
dr["SubjectName"] = ucInputSubject.Text;
dr["SubjectHint"] = ucInputSubject.Hint;
}
if (isBindGrid)
{
this.dgList.DataSource = tb;
this.dgList.DataBind();
}
return(tb);
}
private void dgList_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
switch (e.Item.ItemType)
{
case ListItemType.Item:
case ListItemType.AlternatingItem:
RmsPM.Web.UserControls.InputSubject ucInputSubject = (RmsPM.Web.UserControls.InputSubject)e.Item.FindControl("ucInputSubject");
ucInputSubject.ProjectCode = this.txtProjectCode.Value;
break;
}
}
private void dgList_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
if ((e.Item.ItemType == ListItemType.Item) || (e.Item.ItemType == ListItemType.AlternatingItem))
{
RmsPM.Web.UserControls.InputSubject ucInputSubject = (RmsPM.Web.UserControls.InputSubject)e.Item.FindControl("ucInputSubject");
ucInputSubject.ProjectCode = this.txtProjectCode.Value;
ucInputSubject.SubjectSetCode = this.txtSubjectSetCode.Value;
RmsPM.Web.UserControls.InputPBS ucPBS = (RmsPM.Web.UserControls.InputPBS)e.Item.FindControl("ucPBS");
ucPBS.ProjectCode = this.txtProjectCode.Value;
}
// Button btnCalcSum;
//
// if (e.Item.ItemType == ListItemType.Footer)
// {
// btnCalcSum = (Button)e.Item.FindControl("btnCalcSum");
// btnCalcSum.Click += new System.EventHandler(this.btnCalcSum_Click);
// }
}
/// <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);
}
/// <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;
}
}
protected void btnSave_Click(object sender, System.EventArgs e)
{
string projectCode = Request["ProjectCode"] + "";
try
{
EntityData allCost = DAL.EntityDAO.CBSDAO.GetCBSByProject(projectCode);
foreach (RepeaterItem li in this.repeat1.Items)
{
System.Web.UI.HtmlControls.HtmlInputText txtSortID = (HtmlInputText)li.FindControl("txtSortID");
System.Web.UI.HtmlControls.HtmlInputText txtCostAllocationDescription = (HtmlInputText)li.FindControl("txtCostAllocationDescription");
System.Web.UI.HtmlControls.HtmlInputText txtDescription = (HtmlInputText)li.FindControl("txtDescription");
RmsPM.Web.UserControls.InputSubject ucInputSubject = (RmsPM.Web.UserControls.InputSubject)li.FindControl("ucInputSubject");
string costCode = ((HtmlInputHidden)li.FindControl("txtCostCode")).Value;
string costName = ((HtmlInputHidden)li.FindControl("txtCostName")).Value;
string sortID = txtSortID.Value.Trim();
if (sortID == "")
{
Response.Write(Rms.Web.JavaScript.Alert(true, costName + "： 必须填写费用项编号 !"));
return;
}
string subjectCode = ucInputSubject.Value.Trim();
if (subjectCode != "")
{
string subjectName = BLL.SubjectRule.GetSubjectName(subjectCode, base.SubjectSetCode);
if (subjectName == "")
{
Response.Write(Rms.Web.JavaScript.Alert(true, costName + "： 不存在这个科目编号 ！"));
return;
}
}
DataRow[] drs = allCost.CurrentTable.Select(String.Format("CostCode='{0}'", costCode));
if (drs.Length > 0)
{
int iChildCount = (int)drs[0]["ChildCount"];
// 明细节点项要对应科目
if (iChildCount == 0 && subjectCode == "")
{
Response.Write(Rms.Web.JavaScript.Alert(true, costName + "： 明细费用项要对应到科目 ！"));
return;
}
drs[0]["SortID"] = sortID;
drs[0]["SubjectCode"] = subjectCode;
drs[0]["CostAllocationDescription"] = txtCostAllocationDescription.Value;
drs[0]["Description"] = txtDescription.Value;
}
}
DAL.EntityDAO.CBSDAO.UpdateCBS(allCost);
allCost.Dispose();
Response.Write(JavaScript.ScriptStart);
Response.Write(JavaScript.Alert(false, "批量修改完成 ！"));
Response.Write(JavaScript.OpenerReload(false));
Response.Write("window.close();");
Response.Write(JavaScript.ScriptEnd);
Response.End();
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "");
}
}
