public void Ins_WMT02(string pWrkCode, string pLotNo, string pProCode, string pProQty , string pLocCode, string pRelType, string pInsType, string pPerCode) { Comm comm = new Comm(); string wmt0200 = Guid.NewGuid().ToString().Replace("-", "").ToUpper(); DateTime sDateTime = DateTime.Parse(comm.Get_ServerDateTime("yyyy/MM/dd HH:mm:ss")); WMT0200 data_T0200 = new WMT0200() { wmt0200 = wmt0200, lot_no = pLotNo, rel_type = pRelType, rel_code = pWrkCode, ins_type = pInsType, sto_date = sDateTime, pro_code = pProCode, pro_qty = pProQty != "" ? decimal.Parse(pProQty) : 0, sto_code = "", loc_code = pLocCode, scr_no = "", cus_code = "", wmt0100 = 0, container = "", barcode = "", sor_no = "", tra_code = "", identifier = "", ins_user = pPerCode, }; InsertData(data_T0200); }
/// <summary> /// 傳入一個DTO,修改,一次修改一筆 /// </summary> public void UpdateData(WMT0200 WMT0200) { Comm comm = new Comm(); string sSql = " UPDATE WMT0200 " + " SET lot_no = @lot_no , " + " rel_type = @rel_type , " + " rel_code = @rel_code , " + " ins_type = @ins_type , " + " sto_date = @sto_date , " + " pro_code = @pro_code , " + " pro_qty = @pro_qty , " + " sto_code = @sto_code , " + " loc_code = @loc_code , " + " scr_no = @scr_no , " + " cus_code = @cus_code , " + " wmt0100 = @wmt0100 , " + " container = @container , " + " barcode = @barcode , " + " sor_no = @sor_no , " + " tra_code = @tra_code , " + " identifier = @identifier, " + " ins_user = @ins_user " + " WHERE wmt0200 = @wmt0200 "; using (SqlConnection con_db = comm.Set_DBConnection()) { con_db.Execute(sSql, WMT0200); } }
/// <summary> /// 傳入一個DTO,存檔,一次存檔一筆 /// </summary> public void InsertData(WMT0200 WMT0200) { Comm comm = new Comm(); string sSql = " INSERT INTO " + " WMT0200 ( wmt0200, lot_no, rel_type, rel_code, ins_type, sto_date, pro_code, pro_qty, sto_code, loc_code, scr_no, cus_code, " + " wmt0100, container, barcode, sor_no, tra_code, identifier, ins_user ) " + " VALUES ( @wmt0200, @lot_no, @rel_type, @rel_code, @ins_type, @sto_date, @pro_code, @pro_qty, @sto_code, @loc_code, @scr_no, @cus_code, " + " @wmt0100, @container, @barcode, @sor_no, @tra_code, @identifier, @ins_user ) "; using (SqlConnection con_db = comm.Set_DBConnection()) { con_db.Execute(sSql, WMT0200); } }