public int Delete(ASSETKKF_MODEL.Data.Mssql.Mcis.msWorkStation d, string userID = "", SqlTransaction transac = null) { var param = new Dapper.DynamicParameters(); param.Add("@WorkStationCd", d.WorkStationCd.GetValue()); param.Add("@WorkStationNm", d.WorkStationNm.GetValue()); param.Add("@WSProfit", d.WSProfit.GetValue()); param.Add("@WSProfit_NM", d.WSProfit_NM.GetValue()); param.Add("@SelProfit", d.SelProfit.GetValue()); param.Add("@CANCELFLAG", d.CANCELFLAG.GetValue()); string cmd = ""; /* * cmd = DELETE FROM .dbo.msWorkStation "+ * "WHERE WorkStationCd = @.WorkStationCd "+ * " AND WorkStationNm = @.WorkStationNm "+ * " AND WSProfit = @.WSProfit "+ * " AND WSProfit_NM = @.WSProfit_NM "+ * " AND SelProfit = @.SelProfit "+ * " AND CANCELFLAG = @.CANCELFLAG "+ * " "; */ var res = ExecuteNonQuery(transac, cmd, param); return(res); }
public int Insert(ASSETKKF_MODEL.Data.Mssql.Mcis.msWorkStation d, string userID = "") { var param = new Dapper.DynamicParameters(); param.Add("@WorkStationCd", d.WorkStationCd); param.Add("@WorkStationNm", d.WorkStationNm); param.Add("@WSProfit", d.WSProfit); param.Add("@WSProfit_NM", d.WSProfit_NM); param.Add("@SelProfit", d.SelProfit); param.Add("@CANCELFLAG", d.CANCELFLAG); string cmd = "INSERT INTO .dbo.msWorkStation " + $" (WorkStationCd, WorkStationNm, WSProfit, WSProfit_NM, SelProfit, CANCELFLAG) " + $"VALUES(@WorkStationCd, @WorkStationNm, @WSProfit, @WSProfit_NM, @SelProfit, @CANCELFLAG); " + $"SELECT SCOPE_IDENTITY();"; return(ExecuteScalar <int>(cmd, param)); }