public static BanHang_ChiPhi Update(BanHang_ChiPhi item) { var Item = new BanHang_ChiPhi(); var obj = new SqlParameter[5]; obj[0] = new SqlParameter("BHCP_ID", item.ID); obj[1] = new SqlParameter("BHCP_PLV_ID", item.PLV_ID); obj[2] = new SqlParameter("BHCP_Tong", item.Tong); if (item.Ngay > DateTime.MinValue) { obj[3] = new SqlParameter("BHCP_Ngay", item.Ngay); } else { obj[3] = new SqlParameter("BHCP_Ngay", DBNull.Value); } obj[4] = new SqlParameter("BHCP_Username", item.Username); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblBanHang_ChiPhi_Update_UpdateNormal_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }
public static BanHang_ChiPhi getFromReader(IDataReader rd) { var Item = new BanHang_ChiPhi(); if (rd.FieldExists("BHCP_ID")) { Item.ID = (Int64)(rd["BHCP_ID"]); } if (rd.FieldExists("BHCP_PLV_ID")) { Item.PLV_ID = (Int64)(rd["BHCP_PLV_ID"]); } if (rd.FieldExists("BHCP_Tong")) { Item.Tong = (Double)(rd["BHCP_Tong"]); } if (rd.FieldExists("BHCP_Ngay")) { Item.Ngay = (DateTime)(rd["BHCP_Ngay"]); } if (rd.FieldExists("BHCP_Username")) { Item.Username = (String)(rd["BHCP_Username"]); } return(Item); }
public static BanHang_ChiPhi SelectByPLVId(SqlConnection con, Int64 PLV_ID) { var Item = new BanHang_ChiPhi(); var obj = new SqlParameter[1]; obj[0] = new SqlParameter("PLV_ID", PLV_ID); using (IDataReader rd = SqlHelper.ExecuteReader(con, CommandType.StoredProcedure, "sp_tblBanHang_ChiPhi_Select_SelectByPLVId_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }