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);
}
}
