public Return_lichsu_nhap LoadLichSu_Nhap(string searchValue, int currPage, int recodperpage, int id_product) { try { Return_lichsu_nhap result = new Return_lichsu_nhap(); List <lichsu_nhap> list = new List <lichsu_nhap>(); SqlConnection con = new SqlConnection(); con = Connection.Connect.GetConnect(); SqlCommand cmd = new SqlCommand("lichsu_nhaphang", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@id_center", user.BranchId)); cmd.Parameters.Add(new SqlParameter("@id_product", id_product)); cmd.Parameters.Add(new SqlParameter("@searchValue", searchValue)); cmd.Parameters.Add(new SqlParameter("@currPage", currPage)); cmd.Parameters.Add(new SqlParameter("@recodperpage", 10)); cmd.Parameters.Add("@totalCount", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Connection = con; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); int total = Convert.ToInt16(cmd.Parameters["@totalCount"].Value); foreach (DataRow rowItem in dt.Rows) { lichsu_nhap item = new lichsu_nhap(); item.id = int.Parse(rowItem["id"].ToString()); item.RowNum = int.Parse(rowItem["RowNum"].ToString()); item.ngaynhap = rowItem["ngaynhap"].ToString(); item.soluong = int.Parse(rowItem["soluong"].ToString()); item.nguoinhap = rowItem["nguoinhap"].ToString(); item.tensp = rowItem["tensp"].ToString(); item.tongtien = float.Parse(rowItem["tongtien"].ToString()); item.giatrungbinh = float.Parse(rowItem["giatrungbinh"].ToString()); item.tennguon = rowItem["tennguon"].ToString(); item.id_nguonnhap = rowItem["id_nguonnhap"].ToString(); item.tendaily = rowItem["tendaily"].ToString(); item.id_center = int.Parse(rowItem["id_center"].ToString()); list.Add(item); } result.Data = list; result.Total = total; return(result); } catch (Exception e) { return(null); } }
public List <lichsu_nhap> bs_Xemchitiet_lichsu_sp(int id) { try { List <lichsu_nhap> list = new List <lichsu_nhap>(); SqlConnection con = new SqlConnection(); con = Connection.Connect.GetConnect(); SqlCommand cmd = new SqlCommand("bs_Xemchitiet_lichsu_sp", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@id", id)); cmd.Connection = con; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); foreach (DataRow rowItem in dt.Rows) { lichsu_nhap item = new lichsu_nhap(); item.id = int.Parse(rowItem["id"].ToString()); item.id_code_p = int.Parse(rowItem["id_code_p"].ToString()); item.RowNum = int.Parse(rowItem["RowNum"].ToString()); item.ngaynhap = rowItem["ngaynhap"].ToString(); item.barcod_sp = rowItem["barcod_sp"].ToString(); item.trangthai = int.Parse(rowItem["trangthai"].ToString()); item.group_code = rowItem["group_code"].ToString(); item.note_code = rowItem["note_code"].ToString(); item.ngayxuat = rowItem["ngayxuat"].ToString(); item.nguoixuat = rowItem["nguoixuat"].ToString(); item.tenKH = rowItem["tenKH"].ToString(); list.Add(item); } return(list); } catch (Exception e) { return(null); } }