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); }