/// <summary> /// 添加经销商品结算单子项 /// </summary> /// <param name="SettleItemInfo"></param> /// <returns></returns> public SettleItemInfo SettleItemInfoAdd(SettleItemInfo settleItemInfo) { DataCommand command = DataCommandManager.GetDataCommand("SettleItemInfoAdd"); command.SetParameterValue("@SettleSysNo", settleItemInfo.SettleSysNo); //command.SetParameterValue("@OrderSysNo", settleItemInfo.OrderSysNo); //command.SetParameterValue("@OrderType", settleItemInfo.FinancePayOrderType); command.SetParameterValue("@CompanyCode", settleItemInfo.CompanyCode); command.SetParameterValue("@FinancePaySysNo", settleItemInfo.FinancePaySysNo); command.ExecuteNonQuery(); object sysNoObj = command.GetParameterValue("@SysNo"); settleItemInfo.SysNo = sysNoObj.ToInteger(); return(settleItemInfo); }
private void InitItemData(List <SettleItemInfo> items, DataTable table) { int rowCount = items.Count; DataRow row = null; SettleItemInfo item = null; for (int i = 0; i < rowCount; i++) { item = items[i]; row = table.NewRow(); row["SettleType"] = GetTypeStr(item.OrderType); row["SettleItemSysno"] = item.OrderSysNo; row["CostDetail"] = (item.Cost13 + item.Cost17 + item.CostOther).ToString("C"); row["RateAmountDetail"] = (item.Rate13 + item.Rate17 + item.RateOther).ToString("C"); row["RateTotalDetail"] = (item.Cost13 + item.Cost17 + item.CostOther + item.Rate13 + item.Rate17 + item.RateOther).ToString("C"); table.Rows.Add(row); } }