public static bool insert_delivery_note(Phieu_Giao pg) { if (QLLK_DAO.add_delivery_note(pg)) { return(true); } return(false); }
public static bool add_delivery_note(Phieu_Giao pg) { string query = @"insert into PHIEU_GIAO values('" + pg.Id_pg + "','" + pg.Id_hd + "',convert(datetime,'" + pg.Ngaygiao + "',103),'" + pg.Noinhan + "','" + pg.Trangthai + "','" + pg.Id_kh + "')"; SqlConnection conn = new SqlConnection(@"Data Source=LAPTOP-A27VSOCJ\SQLEXPRESS;Initial Catalog=QLLK;Integrated Security=True"); SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); return(false); }
public bool UpData(Phieu_Giao pgObj) { cmd.CommandText = "update PHIEU_GIAO set TRANG_THAI = '" + pgObj.Trangthai + "' where ID_PG='" + pgObj.Id_pg + "'"; cmd.CommandType = CommandType.Text; cmd.Connection = conn.Connection; try { conn.OpenConn(); cmd.ExecuteNonQuery(); conn.CloseConn(); return(true); } catch (Exception ex) { String mex = ex.Message; cmd.Dispose(); conn.CloseConn(); } return(false); }
public bool UpdData(Phieu_Giao hdObj) { return(hdMod.UpData(hdObj)); }