using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using DBUtility;
|
|
namespace DAL
|
{
|
public class ClsCg_OrderTransportBill_Ctl : ClsXt_BaseBill
|
{
|
|
public ClsCg_OrderTransportBill_Ctl()
|
{
|
base.MvarItemKeySub = "ClsCg_OrderTransportBillSub";
|
base.MvarItemKeySub2 = "ClsCg_OrderTransportBillSub_Money";
|
base.MvarItemKeySub3 = "";
|
base.MvarItemKeySub4 = "";
|
base.MvarItemKey = "ClsCg_OrderTransportBillMain";
|
base.MvarReportTitle = "运单申请";
|
base.BillType = "1118";
|
base.HBillSubType = "1118";
|
|
}
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
//原代码 用于 替换子项目
|
public string HOldNumber;
|
public Model.ClsCg_OrderTransportBill_Model oModel = new Model.ClsCg_OrderTransportBill_Model();
|
public Model.ClsCg_OrderTransportBillSub_Model oModel_Sub = new Model.ClsCg_OrderTransportBillSub_Model();
|
public Model.ClsCg_OrderTransportBillSub_Money_Model oModel_Sub_Money = new Model.ClsCg_OrderTransportBillSub_Money_Model();
|
|
public override bool DeleteBill(long lngBillKey, ref string sReturn)
|
{
|
return base.DeleteBill(lngBillKey, ref sReturn);
|
}
|
|
public override bool IsExistMainID(ref string sReturn, long lngBillKey, Pub_Class.ClsPub.Enum_BillStatus oBillStatus)
|
{
|
return base.IsExistMainID(ref sReturn, lngBillKey, oBillStatus);
|
}
|
|
public override bool IsExistBillNo(ref string sReturn, string sBillNo, Pub_Class.ClsPub.Enum_BillStatus oBillStatus, long lngBillKey)
|
{
|
return base.IsExistBillNo(ref sReturn, sBillNo, oBillStatus, lngBillKey);
|
}
|
|
public override bool ModifyBill(long lngBillKey, ref string sReturn)
|
{
|
return base.ModifyBill(lngBillKey, ref sReturn);
|
}
|
|
public override bool AddBill(ref string sReturn)
|
{
|
bool success = false;
|
// 添加主表
|
string sql = $@" Insert Into {MvarItemKey}
|
INSERT INTO BillMain (
|
HYear, HPeriod, HBillType, HBillSubType, HInterID, HDate, HBillNo, HBillStatus,
|
HCheckItemNowID, HCheckItemNextID, HCheckFlowID, HRemark, HBacker, HBackDate, HBackRemark,
|
HChecker, HCheckDate, HMaker, HMakeDate, HUpDater, HUpDateDate, HCloseMan, HCloseDate,
|
HCloseType, HDeleteMan, HDeleteDate, HMainSourceBillType, HMainSourceInterID, HMainSourceEntryID,
|
HMainSourceBillNo, HPrintQty, HItemMainID, HCusID, HStockOutBillMainID, HStockOutBillNo,
|
HSupID, HOrderBillNumber, HOrderType, HTransportType, HTransportMoney, HSendAddr,
|
HReceAddr, HGoodsVolume, HTakeGoodsTime, HArriveGoodsTime, HCarID, HDriverID,
|
HLoadRate, HOrderStatus
|
) VALUES (
|
{oModel.HYear}, {oModel.HPeriod}, '{oModel.HBillType}', '{oModel.HBillSubType}', {oModel.HInterID}, '{oModel.HDate}', '{oModel.HBillNo}', {oModel.HBillStatus},
|
{oModel.HCheckItemNowID}, {oModel.HCheckItemNextID}, {oModel.HCheckFlowID}, '{oModel.HRemark}', '{oModel.HBacker}', '{oModel.HBackDate}', '{oModel.HBackRemark}',
|
'{oModel.HChecker}', '{oModel.HCheckDate}', '{oModel.HMaker}', '{oModel.HMakeDate}', '{oModel.HUpDater}', '{oModel.HUpDateDate}', '{oModel.HCloseMan}', '{oModel.HCloseDate}',
|
{oModel.HCloseType}, '{oModel.HDeleteMan}', '{oModel.HDeleteDate}', '{oModel.HMainSourceBillType}', {oModel.HMainSourceInterID}, {oModel.HMainSourceEntryID},
|
'{oModel.HMainSourceBillNo}', {oModel.HPrintQty}, {oModel.HItemMainID}, {oModel.HCusID}, {oModel.HStockOutBillMainID}, '{oModel.HStockOutBillNo}',
|
{oModel.HSupID}, '{oModel.HOrderBillNumber}', '{oModel.HOrderType}', '{oModel.HTransportType}', {oModel.HTransportMoney}, '{oModel.HSendAddr}',
|
'{oModel.HReceAddr}', {oModel.HGoodsVolume}, '{oModel.HTakeGoodsTime}', '{oModel.HArriveGoodsTime}', {oModel.HCarID}, {oModel.HDriverID},
|
{oModel.HLoadRate}, {oModel.HOrderStatus}
|
";
|
|
oCn.RunProc(sql);
|
// 添加子表
|
success = AddBillSub(ref DBUtility.ClsPub.sExeReturnInfo);
|
|
// 添加子表-金额
|
success = AddBillSub_Money(ref DBUtility.ClsPub.sExeReturnInfo);
|
|
return success;
|
}
|
|
public override bool ShowBill(long lngBillKey, ref string sReturn)
|
{
|
return base.ShowBill(lngBillKey, ref sReturn);
|
}
|
|
public override void DeleteRelation(ref string sReturn, long lngBillKey)
|
{
|
base.DeleteRelation(ref sReturn, lngBillKey);
|
}
|
|
public override void AddNewRelation(ref string sReturn, long lngBillKey)
|
{
|
base.AddNewRelation(ref sReturn, lngBillKey);
|
}
|
|
// 添加子单据
|
public bool AddBillSub(ref string sReturn)
|
{
|
string sql = $@"
|
INSERT INTO {MvarItemKeySub} (
|
HInterID, HBillNo_bak, HEntryID, HCloseMan, HEntryCloseDate, HCloseType,
|
HRemark, HSourceInterID, HSourceEntryID, HSourceBillNo, HSourceBillType,
|
HRelationQty, HRelationMoney, HItemSubID, HMaterID, HVolume, HPack, HUnitID
|
) VALUES (
|
{oModel_Sub.HInterID}, '{oModel_Sub.HBillNo_bak}', {oModel_Sub.HEntryID},
|
'{oModel_Sub.HCloseMan}', '{oModel_Sub.HEntryCloseDate}', {oModel_Sub.HCloseType},
|
'{oModel_Sub.HRemark}', {oModel_Sub.HSourceInterID}, {oModel_Sub.HSourceEntryID},
|
'{oModel_Sub.HSourceBillNo}', '{oModel_Sub.HSourceBillType}', {oModel_Sub.HRelationQty},
|
'{oModel_Sub.HRelationMoney}', {oModel_Sub.HItemSubID}, {oModel_Sub.HMaterID},
|
{oModel_Sub.HVolume}, '{oModel_Sub.HPack}', {oModel_Sub.HUnitID}
|
)
|
";
|
oCn.RunProc(sql);
|
|
return true;
|
}
|
|
// 添加子单据 费用
|
public bool AddBillSub_Money(ref string sReturn)
|
{
|
string sql = $@"
|
INSERT INTO {MvarItemKeySub} (
|
HInterID, HBillNo_bak, HEntryID, HCloseMan, HEntryCloseDate, HCloseType,
|
HRemark, HSourceInterID, HSourceEntryID, HSourceBillNo, HSourceBillType,
|
HRelationQty, HRelationMoney, HItemSubID, HMaterID, HVolume, HPack, HUnitID
|
) VALUES (
|
{oModel_Sub.HInterID}, '{oModel_Sub.HBillNo_bak}', {oModel_Sub.HEntryID},
|
'{oModel_Sub.HCloseMan}', '{oModel_Sub.HEntryCloseDate}', {oModel_Sub.HCloseType},
|
'{oModel_Sub.HRemark}', {oModel_Sub.HSourceInterID}, {oModel_Sub.HSourceEntryID},
|
'{oModel_Sub.HSourceBillNo}', '{oModel_Sub.HSourceBillType}', {oModel_Sub.HRelationQty},
|
'{oModel_Sub.HRelationMoney}', {oModel_Sub.HItemSubID}, {oModel_Sub.HMaterID},
|
{oModel_Sub.HVolume}, '{oModel_Sub.HPack}', {oModel_Sub.HUnitID}
|
)
|
";
|
oCn.RunProc(sql);
|
|
return true;
|
}
|
}
|
}
|
