public T_FB_CHARGEAPPLYDETAIL GetChargeApplyDetailByID(string strChargeApplyDetailId)
{
T_FB_CHARGEAPPLYDETAIL entRd = new T_FB_CHARGEAPPLYDETAIL();
using (ChargeApplyDetailBLL bllChargeApplyDetail = new ChargeApplyDetailBLL())
{
entRd = bllChargeApplyDetail.GetChargeApplyDetailByID(strChargeApplyDetailId);
return(entRd);
}
}
public void AddToT_FB_CHARGEAPPLYDETAIL(T_FB_CHARGEAPPLYDETAIL t_FB_CHARGEAPPLYDETAIL)
{
base.AddObject("T_FB_CHARGEAPPLYDETAIL", t_FB_CHARGEAPPLYDETAIL);
}
public static T_FB_CHARGEAPPLYDETAIL CreateT_FB_CHARGEAPPLYDETAIL(string cHARGEAPPLYDETAILID, decimal cHARGEMONEY, string cREATEUSERID, global::System.DateTime cREATEDATE, string uPDATEUSERID, global::System.DateTime uPDATEDATE)
{
T_FB_CHARGEAPPLYDETAIL t_FB_CHARGEAPPLYDETAIL = new T_FB_CHARGEAPPLYDETAIL();
t_FB_CHARGEAPPLYDETAIL.CHARGEAPPLYDETAILID = cHARGEAPPLYDETAILID;
t_FB_CHARGEAPPLYDETAIL.CHARGEMONEY = cHARGEMONEY;
t_FB_CHARGEAPPLYDETAIL.CREATEUSERID = cREATEUSERID;
t_FB_CHARGEAPPLYDETAIL.CREATEDATE = cREATEDATE;
t_FB_CHARGEAPPLYDETAIL.UPDATEUSERID = uPDATEUSERID;
t_FB_CHARGEAPPLYDETAIL.UPDATEDATE = uPDATEDATE;
return t_FB_CHARGEAPPLYDETAIL;
}
public T_FB_CHARGEAPPLYDETAIL GetChargeApplyDetailByID(string strChargeApplyDetailId)
{
T_FB_CHARGEAPPLYDETAIL entRd = new T_FB_CHARGEAPPLYDETAIL();
using (ChargeApplyDetailBLL bllChargeApplyDetail = new ChargeApplyDetailBLL())
{
entRd = bllChargeApplyDetail.GetChargeApplyDetailByID(strChargeApplyDetailId);
return entRd;
}
}
void browser_ReloadDataEvent()
{
if (frmU._lstSubjectApply_Add == null)
{
Utility.ShowCustomMessage(MessageTypes.Caution, Utility.GetResourceStr("CAUTION"), "请选择要报销的科目");
return;
}
budgetList = frmU._lstSubjectApply_Add;
foreach (T_FB_BUDGETACCOUNT obj in budgetList)
{
T_FB_CHARGEAPPLYDETAIL chaent = new T_FB_CHARGEAPPLYDETAIL();
chaent.CHARGEAPPLYDETAILID = System.Guid.NewGuid().ToString();
if (obj.ACCOUNTOBJECTTYPE == 3) //个人费用报销
{
chaent.CHARGETYPE = 1;
}
else if (obj.ACCOUNTOBJECTTYPE == 2) //部门费用报销
{
chaent.CHARGETYPE = 2;
}
chaent.CREATEDATE = DateTime.Now;
chaent.CREATEUSERID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID;
chaent.T_FB_SUBJECT = obj.T_FB_SUBJECT;
chaent.UPDATEDATE = DateTime.Now;
chaent.UPDATEUSERID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID;
chaent.USABLEMONEY = obj.USABLEMONEY; //据万要求显示可用结余
//chaent.USABLEMONEY = obj.ACTUALMONEY; //据万要求显示实际结余
chaDtlobj.Add(chaent);
}
dgvChargeDetailList.ItemsSource = chaDtlobj;
}
/// <summary>
/// 保存费用报销
/// </summary>
/// <param name="chargeMaster"></param>
private void InnerSaveChargeApply(T_FB_CHARGEAPPLYMASTER chargeMaster)
{
// chargeMaster.BUDGETARYMONTH = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM") + "-1");
chargeMaster.CREATECOMPANYID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
chargeMaster.CREATECOMPANYNAME = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].CompanyName;
chargeMaster.CREATEDATE = DateTime.Now;
chargeMaster.CREATEDEPARTMENTID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].DepartmentID;
chargeMaster.CREATEDEPARTMENTNAME = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].DepartmentName;
chargeMaster.CREATEPOSTID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].PostID;
chargeMaster.CREATEPOSTNAME = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].PostName;
chargeMaster.CREATEUSERID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID;
chargeMaster.CREATEUSERNAME = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeName;
chargeMaster.EDITSTATES = 0;
chargeMaster.OWNERCOMPANYID = strOwnerCompanyID;
chargeMaster.OWNERCOMPANYNAME = strOwnerCompanyName;
chargeMaster.OWNERDEPARTMENTID = strOwnerDepartmentID;
chargeMaster.OWNERDEPARTMENTNAME = strOwnerDepartmentName;
chargeMaster.OWNERID = strOwnerID;
chargeMaster.OWNERNAME = strOwnerName;
chargeMaster.OWNERPOSTID = strOwnerPostID;
chargeMaster.OWNERPOSTNAME = strOwnerPostName;
chargeMaster.PAYTYPE = nChargeType;
if (txtCode.Text.IndexOf('>') > 0)
{
chargeMaster.CHARGEAPPLYMASTERCODE = " ";
}
else
{
chargeMaster.CHARGEAPPLYMASTERCODE = txtCode.Text;
}
if (nChargeType==1)//1为费用报销
{
#region 费用报销情况
if (this.rbPayMySelft.IsChecked.Value)
{
chargeMaster.PAYTARGET = 0;//2013/12/16号起PAYTARGET字段意思：0付本人，1原始值，目前不用，2付多人
}
else
{
chargeMaster.PAYTARGET = 2;
}
#endregion
}
else
{
chargeMaster.PAYTARGET = 1;//不是费用报销则保留原来存值为1
}
chargeMaster.PAYMENTINFO = GetPayInfo();
if (!string.IsNullOrEmpty(txtItemID.Text))
{
// Bank 字段用于做事项审批关联
chargeMaster.BANK = txtItemID.Text;
chargeMaster.BANKACCOUT = txtItemCode.Text;
chargeMaster.RECEIVER = "T_OA_APPROVALINFO";
}
else
{
chargeMaster.BANK = null;
chargeMaster.BANKACCOUT = null;
chargeMaster.RECEIVER = null;
}
chargeMaster.REMARK = txtRemark.Text;
chargeMaster.TOTALMONEY = decimal.Parse(txttotal.Text.ToString());
chargeMaster.UPDATEDATE = DateTime.Now;
chargeMaster.UPDATEUSERID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID;
chargeMaster.UPDATEUSERNAME = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeName;
if (rabPayBor.IsChecked == true) //如果是冲借款就保存冲款金额
{
chargeMaster.REPAYMENT = decimal.Parse(txtTolRepayMon.Text);
//chargeMaster.TOTALMONEY += decimal.Parse(txtTolRepayMon.Text);
chaRepayDetailData.Clear();
foreach (object obj in dgvRepayDetailList.ItemsSource)
{
T_FB_CHARGEAPPLYREPAYDETAIL ent = obj as T_FB_CHARGEAPPLYREPAYDETAIL;
T_FB_CHARGEAPPLYREPAYDETAIL chaRepay = new T_FB_CHARGEAPPLYREPAYDETAIL();
chaRepay.CHARGEAPPLYREPAYDETAILID = System.Guid.NewGuid().ToString();
chaRepay.UPDATEDATE = DateTime.Now;
chaRepay.CREATEDATE = DateTime.Now;
chaRepay.T_FB_CHARGEAPPLYMASTER = chargeMaster;
chaRepay.CREATEUSERID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID;
chaRepay.UPDATEUSERID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID;
chaRepay.BORROWMONEY = ent.BORROWMONEY;
chaRepay.REPAYTYPE = ent.REPAYTYPE;
if (dgvRepayDetailList.Columns[2].GetCellContent(obj) != null)
{
TextBox txtMark = dgvRepayDetailList.Columns[2].GetCellContent(obj).FindName("txtRepRemark") as TextBox;
chaRepay.REMARK = txtMark.Text;
}
if (dgvRepayDetailList.Columns[3].GetCellContent(obj) != null)
{
TextBox tbMon = dgvRepayDetailList.Columns[3].GetCellContent(obj).FindName("txtRepMon") as TextBox;
chaRepay.REPAYMONEY = decimal.Parse(string.IsNullOrEmpty(tbMon.Text.ToString()) == true ? "0" : tbMon.Text.ToString());
}
chaRepayDetailData.Add(chaRepay);
}
}
else
{
chargeMaster.REPAYMENT = 0;
//chargeMaster.REPAYTYPE = null;
}
chargeDtlList.Clear();
//chaDtlobj.Clear();
if (dgvChargeDetailList.ItemsSource != null)
{
foreach (object obj in dgvChargeDetailList.ItemsSource)
{
T_FB_CHARGEAPPLYDETAIL ent = obj as T_FB_CHARGEAPPLYDETAIL;
T_FB_CHARGEAPPLYDETAIL charge = new T_FB_CHARGEAPPLYDETAIL();
charge.CHARGEAPPLYDETAILID = System.Guid.NewGuid().ToString();
charge.CHARGETYPE = ent.CHARGETYPE;
charge.CREATEDATE = DateTime.Now;
charge.CREATEUSERID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID;
charge.T_FB_BORROWAPPLYDETAIL = ent.T_FB_BORROWAPPLYDETAIL;
charge.T_FB_CHARGEAPPLYMASTER = chargeMaster;
charge.T_FB_SUBJECT = ent.T_FB_SUBJECT;
charge.UPDATEDATE = DateTime.Now;
charge.UPDATEUSERID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID;
charge.USABLEMONEY = ent.USABLEMONEY;
if (dgvChargeDetailList.Columns[4].GetCellContent(obj) != null)
{
TextBox txtMark = dgvChargeDetailList.Columns[4].GetCellContent(obj).FindName("txtRemark") as TextBox;
charge.REMARK = txtMark.Text;
}
if (dgvChargeDetailList.Columns[5].GetCellContent(obj) != null)
{
TextBox tbMon = dgvChargeDetailList.Columns[5].GetCellContent(obj).FindName("txtMon") as TextBox;
charge.CHARGEMONEY = decimal.Parse(string.IsNullOrEmpty(tbMon.Text.ToString()) == true ? "0" : tbMon.Text.ToString());
}
chargeDtlList.Add(charge);
}
}
RefreshUI(RefreshedTypes.ShowProgressBar);
string strMsg = string.Empty;
if (types == FormTypes.New)
{
client.AddChargeApplyMasterAndDetailAsync(chargeMaster, chargeDtlList, chaRepayDetailData);
}
else if (types == FormTypes.Edit)
{
string op = needsubmit == false ? "Edit" : "Submit";
client.UptChargeApplyMasterAndDetailAsync(op, chargeMaster, chargeDtlList, chaRepayDetailData, strMsg, op);
}
else if (types == FormTypes.Resubmit)
{
client.UptChargeApplyMasterAndDetailAsync("ReSubmit", chargeMaster, chargeDtlList, chaRepayDetailData, strMsg, "ReSubmit");
}
}
void EditForm_Saving(object sender, SavingEventArgs e)
{
T_FB_CHARGEAPPLYMASTER entCheck = this.OrderEntity.Entity as T_FB_CHARGEAPPLYMASTER;
if (entCheck.T_FB_BORROWAPPLYMASTER != null && entCheck.PAYTYPE != 2)
{
e.Action = Actions.Cancel;
CommonFunction.ShowErrorMessage("必须选择冲借款！");
return;
}
if (entCheck.PAYTYPE == 2 && entCheck.T_FB_BORROWAPPLYMASTER == null)
{
e.Action = Actions.Cancel;
CommonFunction.ShowErrorMessage("请确认已填入借款单！");
return;
}
ObservableCollection <FBEntity> details = this.OrderEntity.GetRelationFBEntities(typeof(T_FB_CHARGEAPPLYDETAIL).Name);
if (details.Count == 0)
{
e.Action = Actions.Cancel;
CommonFunction.ShowErrorMessage(ErrorMessage.NoDetailInfo);
return;
}
if (details.Count > 5)
{
e.Action = Actions.Cancel;
CommonFunction.ShowErrorMessage(ErrorMessage.OverDetailInfo);
return;
}
#region 去掉无关的关联
details.ToList().ForEach(item =>
{
T_FB_CHARGEAPPLYDETAIL detail = item.Entity as T_FB_CHARGEAPPLYDETAIL;
detail.T_FB_SUBJECT.T_FB_BORROWAPPLYDETAIL.Clear();
detail.T_FB_SUBJECT.T_FB_BUDGETACCOUNT.Clear();
detail.T_FB_SUBJECT.T_FB_CHARGEAPPLYDETAIL.Clear();
});
#endregion
List <string> msgs = new List <string>();
details.ToList().ForEach(item =>
{
T_FB_CHARGEAPPLYDETAIL detail = item.Entity as T_FB_CHARGEAPPLYDETAIL;
if (detail.CHARGEMONEY <= 0)
{
string errorMessage = string.Format(ErrorMessage.ChargeMoneyZero, detail.T_FB_SUBJECT.SUBJECTNAME);
msgs.Add(errorMessage);
}
//if (detail.USABLEMONEY.LessThan(detail.CHARGEMONEY))
//{
// msgs.Add(string.Format(ErrorMessage.ChargeMoneyBigger, detail.T_FB_SUBJECT.SUBJECTNAME));
//}
});
//
var items = from item in details
group item by new
{
item.GetEntity <T_FB_CHARGEAPPLYDETAIL>().T_FB_SUBJECT.SUBJECTNAME,
item.GetEntity <T_FB_CHARGEAPPLYDETAIL>().CHARGETYPE,
item.GetEntity <T_FB_CHARGEAPPLYDETAIL>().USABLEMONEY
} into g
where g.Sum(item => item.GetEntity <T_FB_CHARGEAPPLYDETAIL>().CHARGEMONEY) > g.Key.USABLEMONEY
select new { g.Key, totalCharge = g.Sum(item => item.GetEntity <T_FB_CHARGEAPPLYDETAIL>().CHARGEMONEY) };
foreach (var item in items)
{
msgs.Add(string.Format(ErrorMessage.ChargeMoneyBigger, item.Key.SUBJECTNAME));
}
if (msgs.Count > 0)
{
e.Action = Actions.Cancel;
CommonFunction.ShowErrorMessage(msgs);
}
}