/// <summary> /// 傳入一個DTO,修改,一次修改一筆 /// </summary> public void Update_NgData(MEM01_0000 MEM01_0000) { Comm comm = new Comm(); string sSql = " UPDATE MEM01_0000 " + " SET ng_qty = @ng_qty " + " WHERE mo_code = @mo_code " + " AND work_code = @work_code "; using (SqlConnection con_db = comm.Set_DBConnection()) { con_db.Execute(sSql, MEM01_0000); } }
/// <summary> /// 傳入一個DTO,存檔,一次存檔一筆 /// </summary> public void InsertData(MEM01_0000 MEM01_0000) { Comm comm = new Comm(); string sSql = " INSERT INTO " + " MEM01_0000 ( mo_code, work_code , station_code , mac_code ," + " work_time_s , work_time_e , ok_qty, ok_unit , " + " ng_qty, ng_unit, work_sec ) " + " VALUES ( @mo_code, @work_code,@station_code,@mac_code, " + " @work_time_s, @work_time_e, @ok_qty, @ok_unit, " + " @ng_qty, @ng_unit, @work_sec ) "; using (SqlConnection con_db = comm.Set_DBConnection()) { con_db.Execute(sSql, MEM01_0000); } }
/// <summary> /// 傳入一個DTO,修改,一次修改一筆 /// </summary> public void UpdateData(MEM01_0000 MEM01_0000) { Comm comm = new Comm(); string sSql = " UPDATE MEM01_0000 " + " SET mo_code = @mo_code, " + " work_code = @work_code, " + " station_code = @station_code, " + " mac_code = @mac_code, " + " work_time_s = @work_time_s, " + " work_time_e = @work_time_e, " + " ok_qty = @ok_qty, " + " ok_unit = @ok_unit, " + " ng_qty = @ng_qty, " + " ng_unit = @ng_unit, " + " work_sec = @work_sec, " + " WHERE MEM01_0000 = @mem01_0000 "; using (SqlConnection con_db = comm.Set_DBConnection()) { con_db.Execute(sSql, MEM01_0000); } }