public override void CellChanged(UFIDA.U8.UAP.UI.Runtime.Common.CellChangeEventArgs para, BusinessProxy businessObject, VoucherProxy voucherObject)
{
base.CellChanged(para, businessObject, voucherObject);
if (para.ColumnName == "cBudgetItemID")
{
Business business = voucherObject.Businesses["27d9db0f-1099-4e02-a070-45fa6b11db89"];
string currentPKValue = business.PrimaryKey;
if (!string.IsNullOrEmpty(currentPKValue))
{
if (para.NewHiddenValue == null && string.IsNullOrEmpty(para.NewHiddenValue.ToString()))
{
business.Rows[currentPKValue].Cells["cPayToken"].Value = ("");
}
else
{
VoucherSrv voucherSrv = new VoucherSrv();
string text = "select cToken from BG_V_ItemToken where cItemCode='" + para.NewHiddenValue.ToString() + "'";
DataSet dataSet = voucherSrv.ExcuteSqlInData(text);
if (dataSet != null && dataSet.Tables != null && dataSet.Tables.Count > 0 && dataSet.Tables[0].Rows.Count > 0)
{
DataRow dataRow = dataSet.Tables[0].Rows[0];
business.Rows[currentPKValue].Cells["cPayToken"].Value = dataRow["cToken"] == null ? "" : dataRow["cToken"].ToString();
}
}
}
}
}
public override void CellChanged(UFIDA.U8.UAP.UI.Runtime.Common.CellChangeEventArgs para, BusinessProxy businessObject, VoucherProxy voucherObject)
{
base.CellChanged(para, businessObject, voucherObject);
if (para.ColumnName == "cName")
{
}
}
private bool IsUnchangeFinallyPrice(UFIDA.U9.SCM.SM.SOUIModel.SO_SOLinesRecord line)
{
if (line != null
&& line.FreeType == (int)FreeTypeEnumData.Present
)
{
return false;
}
return true;
}
//private string GetDiscountOpath(UFIDA.U9.SCM.SM.SOUIModel.SOUIModelModel soModel)
//{
// decimal totalMoneyOrginal = GetTotalMoneyOriginal(soModel);
// if (totalMoneyOrginal > 0)
// {
// }
// return string.Empty;
//}
private static decimal GetTotalMoneyOriginal(UFIDA.U9.SCM.SM.SOUIModel.SOUIModelModel soModel)
{
decimal totalMoneyOrginal = 0;
if (soModel != null)
{
UFIDA.U9.SCM.SM.SOUIModel.SORecord soHead = soModel.SO.FocusedRecord;
if (soHead != null)
{
IUIRecord[] arrSOLine = soHead.GetChildRecords(soModel.SO_SOLines);
if (arrSOLine != null
&& arrSOLine.Length > 0
)
{
foreach (UFIDA.U9.SCM.SM.SOUIModel.SO_SOLinesRecord soline in arrSOLine)
{
if (soline != null)
{
decimal price = soline.OrderPriceTC >= 0 ? soline.OrderPriceTC : soline.FinallyPriceTC;
totalMoneyOrginal += price * soline.OrderByQtyPU;
}
}
}
}
}
return totalMoneyOrginal;
}
public override void CellChanged(UFIDA.U8.UAP.UI.Runtime.Common.CellChangeEventArgs para, BusinessProxy businessObject, VoucherProxy voucherObject)
{
base.CellChanged(para, businessObject, voucherObject);
if (NeExpense.config == null)
{
NeExpense.config = CheckConfig.Init();
}
if (businessObject.EntityID == "a701a36d-ec4f-43c9-b95a-ef77d7600f57") //表体
{
if (para.ColumnName == "ExpenseMoney")
{
CalcBody_ReCalcBXAmount(para, businessObject, voucherObject);
if (voucherObject.Businesses["12f73210-161b-4d45-94a0-6589e1ec7ae2"].Cells["OperationTypeCode"].Value == "O")
CalcBody_Tax_LWOTH(businessObject, voucherObject);
//从表头报销人会自动带到表体，不触发事件，所以在金额处再补带一次。
string exposerID = businessObject.Cells["ExpenserID"].Value;
//string cNeDefine12 = businessObject.Cells["cNeDefine12"].Value;
if (!string.IsNullOrEmpty(exposerID))//&& string.IsNullOrEmpty(cNeDefine12))
{
CalcBody_RefTypeVID(exposerID, businessObject, voucherObject);
}
queryICBC(businessObject, voucherObject);
}
else if (para.ColumnName == "ExpenserID")
{
CalcBody_RefTypeVID(para, businessObject, voucherObject);
if (voucherObject.Businesses["12f73210-161b-4d45-94a0-6589e1ec7ae2"].Cells["OperationTypeCode"].Value == "O")
{
CalcBody_Tax_LWOTH(businessObject, voucherObject);
}
queryICBC(businessObject, voucherObject);
}
else if (para.ColumnName == "cNeDefine13")//手动录入身份证号，并计算税。
{
if (voucherObject.Businesses["12f73210-161b-4d45-94a0-6589e1ec7ae2"].Cells["OperationTypeCode"].Value == "O")
CalcBody_Tax_LWOTH(businessObject, voucherObject);
}
else if (para.ColumnName == gwc_traceDateField) //公务卡日期。
{
queryICBC(businessObject, voucherObject);
}
}
else if (businessObject.EntityID == "12f73210-161b-4d45-94a0-6589e1ec7ae2") //表头
{
if (para.ColumnName == "cDefine13")
{
if (para.NewValue == "公务卡")
{
voucherObject.SetPortalButtonEnabled("btnSWRefConsume", true);
}
else if (para.OldValue == "公务卡" && para.NewValue != "公务卡")
{
voucherObject.Businesses["a701a36d-ec4f-43c9-b95a-ef77d7600f57"].Clear();
voucherObject.SetPortalButtonEnabled("btnSWRefConsume", false);
}
}
}
CalcBody_zzg(para, businessObject, voucherObject);
}
private void CalcBody_zzg(UFIDA.U8.UAP.UI.Runtime.Common.CellChangeEventArgs para, BusinessProxy businessObject, VoucherProxy voucherObject)
{
string entityID = businessObject.EntityID;
if (NeExpense.config.ContainsKey(entityID))
{
CheckConfig checkConfig = NeExpense.config[(entityID)];
if (checkConfig.ChangedColName == para.ColumnName)
{
VoucherSrv voucherSrv = new VoucherSrv();
string text = checkConfig.CheckSql.Replace("@ret", para.NewValue);
DataSet dataSet = voucherSrv.ExcuteSqlInData(text);
DataRow dataRow = null;
if (dataSet != null && dataSet.Tables != null && dataSet.Tables[0] != null && dataSet.Tables[0].Rows.Count > 0)
{
dataRow = dataSet.Tables[0].Rows[0];
}
if (dataRow != null)
{
using (Dictionary<string, string>.KeyCollection.Enumerator enumerator = checkConfig.WriteCol.Keys.GetEnumerator())
{
while (enumerator.MoveNext())
{
string current = enumerator.Current;
businessObject.Cells[current].Value = dataRow[checkConfig.WriteCol[current]].ToString();
}
}
}
}
}
}
private void CalcBody_ReCalcBXAmount(UFIDA.U8.UAP.UI.Runtime.Common.CellChangeEventArgs para, BusinessProxy businessObject, VoucherProxy voucherObject)
{
string value = businessObject.Cells["cNeDefine11"].Value;
if (string.IsNullOrEmpty(value)) return;
string newValue = para.NewValue;
if (newValue != "")
{
double num = 0.0;
double.TryParse(newValue, out num);
if (num > 0.0)
{
string value2 = businessObject.Cells["cNeDefine21"].Value;
double num2 = 0.0;
double.TryParse(value2, out num2);
if (num > num2)
{
businessObject.Cells["ExpenseMoney"].Value = (value2);
businessObject.Cells["LocalMoney"].Value = (value2);
this.CalcHead_Money(voucherObject);
}
}
}
}
private void CalcBody_RefTypeVID(UFIDA.U8.UAP.UI.Runtime.Common.CellChangeEventArgs para, BusinessProxy businessObject, VoucherProxy voucherObject)
{
//15.6.25表体报销人带其它 信息。
string exid = null;
if (para.NewHiddenValue != null) exid = para.NewHiddenValue.ToString();
CalcBody_RefTypeVID(exid, businessObject, voucherObject);
}
