public int Insert(ASSETKKF_MODEL.Data.Mssql.Mcis.mtWorkOrderH d, string userID = "")
{
var param = new Dapper.DynamicParameters();
param.Add("@WorkOrderID", d.WorkOrderID);
param.Add("@MchProjectID", d.MchProjectID);
param.Add("@DrawingCd", d.DrawingCd);
param.Add("@WorkOrderDesc", d.WorkOrderDesc);
param.Add("@QtyAmt", d.QtyAmt);
param.Add("@FMDeptCd", d.FMDeptCd);
param.Add("@CreatedDate", d.CreatedDate);
param.Add("@WorkOrderStatus", d.WorkOrderStatus);
param.Add("@FstRcvrWs", d.FstRcvrWs);
param.Add("@PrintFlg", d.PrintFlg);
param.Add("@AmtUnit", d.AmtUnit);
param.Add("@DocListNo", d.DocListNo);
param.Add("@MainWS", d.MainWS);
param.Add("@SendStock", d.SendStock);
param.Add("@USER_ID", d.USER_ID);
param.Add("@USER_DATE", d.USER_DATE);
param.Add("@Date_Open", d.Date_Open);
param.Add("@PDate_Cls", d.PDate_Cls);
param.Add("@RDate_cls", d.RDate_cls);
param.Add("@CreateSPAuto", d.CreateSPAuto);
param.Add("@DM_COST", d.DM_COST);
param.Add("@DM_FOH", d.DM_FOH);
param.Add("@SEQUENCE_COST", d.SEQUENCE_COST);
param.Add("@SEQUENCE_PROFIT", d.SEQUENCE_PROFIT);
param.Add("@TOTPRC", d.TOTPRC);
param.Add("@TOTCOST", d.TOTCOST);
param.Add("@DM_COST_VERSION", d.DM_COST_VERSION);
param.Add("@DEL_FLAG", d.DEL_FLAG);
param.Add("@MATDAYWANT", d.MATDAYWANT);
param.Add("@SEQUENCE_ACT", d.SEQUENCE_ACT);
param.Add("@TOTCOST_ACT", d.TOTCOST_ACT);
param.Add("@SEQUENCE_DIF", d.SEQUENCE_DIF);
param.Add("@PROFIT_BEG", d.PROFIT_BEG);
param.Add("@STATION_GRP", d.STATION_GRP);
string cmd = "INSERT INTO mcis.dbo.mtWorkOrderH " +
$" (WorkOrderID, MchProjectID, DrawingCd, WorkOrderDesc, QtyAmt, FMDeptCd, CreatedDate, WorkOrderStatus, FstRcvrWs, PrintFlg, AmtUnit, DocListNo, MainWS, SendStock, USER_ID, USER_DATE, Date_Open, PDate_Cls, RDate_cls, CreateSPAuto, DM_COST, DM_FOH, SEQUENCE_COST, SEQUENCE_PROFIT, TOTPRC, TOTCOST, DM_COST_VERSION, DEL_FLAG, MATDAYWANT, SEQUENCE_ACT, TOTCOST_ACT, SEQUENCE_DIF, PROFIT_BEG, STATION_GRP) " +
$"VALUES(@WorkOrderID, @MchProjectID, @DrawingCd, @WorkOrderDesc, @QtyAmt, @FMDeptCd, @CreatedDate, @WorkOrderStatus, @FstRcvrWs, @PrintFlg, @AmtUnit, @DocListNo, @MainWS, @SendStock, @USER_ID, @USER_DATE, @Date_Open, @PDate_Cls, @RDate_cls, @CreateSPAuto, @DM_COST, @DM_FOH, @SEQUENCE_COST, @SEQUENCE_PROFIT, @TOTPRC, @TOTCOST, @DM_COST_VERSION, @DEL_FLAG, @MATDAYWANT, @SEQUENCE_ACT, @TOTCOST_ACT, @SEQUENCE_DIF, @PROFIT_BEG, @STATION_GRP); " +
$"SELECT SCOPE_IDENTITY();";
return(ExecuteScalar <int>(cmd, param));
}
public int Delete(ASSETKKF_MODEL.Data.Mssql.Mcis.mtWorkOrderH d, string userID = "", SqlTransaction transac = null)
{
var param = new Dapper.DynamicParameters();
param.Add("@WorkOrderID", d.WorkOrderID.GetValue());
param.Add("@MchProjectID", d.MchProjectID.GetValue());
param.Add("@DrawingCd", d.DrawingCd.GetValue());
param.Add("@WorkOrderDesc", d.WorkOrderDesc.GetValue());
param.Add("@QtyAmt", d.QtyAmt);
param.Add("@FMDeptCd", d.FMDeptCd.GetValue());
param.Add("@CreatedDate", d.CreatedDate);
param.Add("@WorkOrderStatus", d.WorkOrderStatus.GetValue());
param.Add("@FstRcvrWs", d.FstRcvrWs.GetValue());
param.Add("@PrintFlg", d.PrintFlg.GetValue());
param.Add("@AmtUnit", d.AmtUnit);
param.Add("@DocListNo", d.DocListNo.GetValue());
param.Add("@MainWS", d.MainWS.GetValue());
param.Add("@SendStock", d.SendStock.GetValue());
param.Add("@USER_ID", d.USER_ID.GetValue());
param.Add("@USER_DATE", d.USER_DATE);
param.Add("@Date_Open", d.Date_Open);
param.Add("@PDate_Cls", d.PDate_Cls);
param.Add("@RDate_cls", d.RDate_cls);
param.Add("@CreateSPAuto", d.CreateSPAuto.GetValue());
param.Add("@DM_COST", d.DM_COST);
param.Add("@DM_FOH", d.DM_FOH);
param.Add("@SEQUENCE_COST", d.SEQUENCE_COST);
param.Add("@SEQUENCE_PROFIT", d.SEQUENCE_PROFIT);
param.Add("@TOTPRC", d.TOTPRC);
param.Add("@TOTCOST", d.TOTCOST);
param.Add("@DM_COST_VERSION", d.DM_COST_VERSION.GetValue());
param.Add("@DEL_FLAG", d.DEL_FLAG.GetValue());
param.Add("@MATDAYWANT", d.MATDAYWANT);
param.Add("@SEQUENCE_ACT", d.SEQUENCE_ACT);
param.Add("@TOTCOST_ACT", d.TOTCOST_ACT);
param.Add("@SEQUENCE_DIF", d.SEQUENCE_DIF);
param.Add("@PROFIT_BEG", d.PROFIT_BEG);
param.Add("@STATION_GRP", d.STATION_GRP.GetValue());
string cmd = "";
/*
* cmd = DELETE FROM mcis.dbo.mtWorkOrderH "+
* "WHERE WorkOrderID = @.WorkOrderID "+
* " AND MchProjectID = @.MchProjectID "+
* " AND DrawingCd = @.DrawingCd "+
* " AND WorkOrderDesc = @.WorkOrderDesc "+
* " AND QtyAmt = @.QtyAmt "+
* " AND FMDeptCd = @.FMDeptCd "+
* " AND CreatedDate = @.CreatedDate "+
* " AND WorkOrderStatus = @.WorkOrderStatus "+
* " AND FstRcvrWs = @.FstRcvrWs "+
* " AND PrintFlg = @.PrintFlg "+
* " AND AmtUnit = @.AmtUnit "+
* " AND DocListNo = @.DocListNo "+
* " AND MainWS = @.MainWS "+
* " AND SendStock = @.SendStock "+
* " AND USER_ID = @.USER_ID "+
* " AND USER_DATE = @.USER_DATE "+
* " AND Date_Open = @.Date_Open "+
* " AND PDate_Cls = @.PDate_Cls "+
* " AND RDate_cls = @.RDate_cls "+
* " AND CreateSPAuto = @.CreateSPAuto "+
* " AND DM_COST = @.DM_COST "+
* " AND DM_FOH = @.DM_FOH "+
* " AND SEQUENCE_COST = @.SEQUENCE_COST "+
* " AND SEQUENCE_PROFIT = @.SEQUENCE_PROFIT "+
* " AND TOTPRC = @.TOTPRC "+
* " AND TOTCOST = @.TOTCOST "+
* " AND DM_COST_VERSION = @.DM_COST_VERSION "+
* " AND DEL_FLAG = @.DEL_FLAG "+
* " AND MATDAYWANT = @.MATDAYWANT "+
* " AND SEQUENCE_ACT = @.SEQUENCE_ACT "+
* " AND TOTCOST_ACT = @.TOTCOST_ACT "+
* " AND SEQUENCE_DIF = @.SEQUENCE_DIF "+
* " AND PROFIT_BEG = @.PROFIT_BEG "+
* " AND STATION_GRP = @.STATION_GRP "+
* " ";
*/
var res = ExecuteNonQuery(transac, cmd, param);
return(res);
}
