public static Chang GetInfo(string MaChang) { DataTable dt = ShipBookingData.FillDataTable("spChang_SelectByID", "@MaChang", MaChang); Chang chang = new Chang(); if (dt.Rows.Count > 0) { chang.MaChang = dt.Rows[0]["MaChang"].ToString(); chang.TinhTrang = dt.Rows[0]["TinhTrang"].ToString(); chang.MaTPDi = dt.Rows[0]["MaTPDi"].ToString(); chang.MaTPDen = dt.Rows[0]["MaTPDen"].ToString(); chang.TenTPDi = dt.Rows[0]["TenTPDi"].ToString(); chang.TenTPDen = dt.Rows[0]["TenTPDen"].ToString(); } else { chang = null; } return chang; }
public static void Update(Chang chang) { string[] parameters = new string[] { "@MaChang", "@TinhTrang", "@MaTPDi", "@MaTPDen", "@TenTPDi", "@TenTPDen" }; string[] values = new string[] { chang.MaChang, chang.TinhTrang, chang.MaTPDi, chang.MaTPDen, chang.TenTPDi, chang.TenTPDen }; ExecuteData("spChang_UpdateByID", parameters, values); }