public static BanHang_PhienLamViec Insert(BanHang_PhienLamViec item) { var Item = new BanHang_PhienLamViec(); var obj = new SqlParameter[6]; obj[0] = new SqlParameter("PLV_ID", item.ID); obj[1] = new SqlParameter("PLV_Username", item.Username); obj[2] = new SqlParameter("PLV_CQ_ID", item.CQ_ID); obj[3] = new SqlParameter("PLV_SoLuong", item.SoLuong); obj[4] = new SqlParameter("PLV_DoanhSo", item.DoanhSo); if (item.Ngay > DateTime.MinValue) { obj[5] = new SqlParameter("PLV_Ngay", item.Ngay); } else { obj[5] = new SqlParameter("PLV_Ngay", DBNull.Value); } using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblBanHang_PhienLamViec_Insert_InsertNormal_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }
public static BanHang_PhienLamViec getFromReader(IDataReader rd) { var Item = new BanHang_PhienLamViec(); if (rd.FieldExists("PLV_ID")) { Item.ID = (Int64)(rd["PLV_ID"]); } if (rd.FieldExists("PLV_Username")) { Item.Username = (String)(rd["PLV_Username"]); } if (rd.FieldExists("PLV_CQ_ID")) { Item.CQ_ID = (Int32)(rd["PLV_CQ_ID"]); } if (rd.FieldExists("PLV_SoLuong")) { Item.SoLuong = (Int32)(rd["PLV_SoLuong"]); } if (rd.FieldExists("PLV_DoanhSo")) { Item.DoanhSo = (Int32)(rd["PLV_DoanhSo"]); } if (rd.FieldExists("PLV_Ngay")) { Item.Ngay = (DateTime)(rd["PLV_Ngay"]); } if (rd.FieldExists("PLV_CQ_Ten")) { Item.CQ_Ten = (String)(rd["PLV_CQ_Ten"]); } return(Item); }
public static BanHang_PhienLamViec SelectByUsername(string Username) { var Item = new BanHang_PhienLamViec(); var obj = new SqlParameter[1]; obj[0] = new SqlParameter("Username", Username); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblBanHang_PhienLamViec_Select_SelectByUsername_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }