public List <INVENTORY_DETAIL> INVENTORY_DETAIL_Search(INVENTORY_DETAIL obj)
{
DataTable dt = new DataTable();
try
{ // lấy dsNV hien thi len luoi voi dieu kien DaXoa = false, TragThai != Nghi Viec
DataProvider.FillDataTable(DataProvider.ConnectionString, dt, "CUSTOMER_RECEIPT_DETAIL_Search",
obj.RefNo,
obj.RefDate,
obj.RefDetailNo,
obj.RefType,
obj.Product_Name,
obj.Batch,
obj.Serial,
obj.Unit,
obj.Price,
obj.Quantity,
obj.UnitPrice,
obj.Amount,
obj.E_Qty,
obj.E_Amt,
obj.Description
);
return(MapINVENTORY_DETAIL(dt));
}
catch (Exception ex)
{
throw ex;
}
}
public int INVENTORY_DETAIL_Update(INVENTORY_DETAIL obj, string ID)
{
try
{
return(DataProvider.ExecuteNonquery(DataProvider.ConnectionString, "INVENTORY_DETAIL_Update",
ID,
obj.RefNo,
obj.RefDate,
obj.RefDetailNo,
obj.RefType,
obj.RefStatus,
obj.StoreID,
obj.Stock_ID,
obj.Product_ID,
obj.Product_Name,
obj.Customer_ID,
obj.Employee_ID,
obj.Batch,
obj.Serial,
obj.Unit,
obj.Price,
obj.Quantity,
obj.UnitPrice,
obj.Amount,
obj.E_Qty,
obj.E_Amt,
obj.Description,
obj.Sorted,
obj.Book_ID
));
}
catch
{
//throw ex;
return(-1);
}
}
private List <INVENTORY_DETAIL> MapINVENTORY_DETAIL(DataTable dt)
{
List <INVENTORY_DETAIL> rs = new List <INVENTORY_DETAIL>();
for (int i = 0; i < dt.Rows.Count; i++)
{
INVENTORY_DETAIL obj = new INVENTORY_DETAIL();
if (dt.Columns.Contains("ID"))
{
obj.ID = long.Parse(dt.Rows[i]["ID"].ToString());
}
if (dt.Columns.Contains("RefNo"))
{
obj.RefNo = dt.Rows[i]["RefNo"].ToString();
}
if (dt.Columns.Contains("RefDate"))
{
obj.RefDate = DateTime.Parse(dt.Rows[i]["RefDate"].ToString());
}
if (dt.Columns.Contains("RefDetailNo"))
{
obj.RefDetailNo = dt.Rows[i]["RefDetailNo"].ToString();
}
if (dt.Columns.Contains("RefType"))
{
obj.RefType = int.Parse(dt.Rows[i]["RefType"].ToString());
}
if (dt.Columns.Contains("RefStatus"))
{
obj.RefStatus = int.Parse(dt.Rows[i]["RefStatus"].ToString());
}
if (dt.Columns.Contains("StoreID"))
{
obj.StoreID = long.Parse(dt.Rows[i]["StoreID"].ToString());
}
if (dt.Columns.Contains("Stock_ID"))
{
obj.Stock_ID = dt.Rows[i]["Stock_ID"].ToString();
}
if (dt.Columns.Contains("Product_ID"))
{
obj.Product_ID = dt.Rows[i]["Product_ID"].ToString();
}
if (dt.Columns.Contains("Product_Name"))
{
obj.Product_Name = dt.Rows[i]["Product_Name"].ToString();
}
if (dt.Columns.Contains("Customer_ID"))
{
obj.Customer_ID = dt.Rows[i]["Customer_ID"].ToString();
}
if (dt.Columns.Contains("Employee_ID"))
{
obj.Employee_ID = dt.Rows[i]["Employee_ID"].ToString();
}
if (dt.Columns.Contains("Batch"))
{
obj.Batch = dt.Rows[i]["Batch"].ToString();
}
if (dt.Columns.Contains("Serial"))
{
obj.Serial = dt.Rows[i]["Serial"].ToString();
}
if (dt.Columns.Contains("Unit"))
{
obj.Unit = dt.Rows[i]["Unit"].ToString();
}
if (dt.Columns.Contains("Price"))
{
obj.Price = double.Parse(dt.Rows[i]["Price"].ToString());
}
if (dt.Columns.Contains("Quantity"))
{
obj.Quantity = double.Parse(dt.Rows[i]["Quantity"].ToString());
}
if (dt.Columns.Contains("UnitPrice"))
{
obj.UnitPrice = double.Parse(dt.Rows[i]["UnitPrice"].ToString());
}
if (dt.Columns.Contains("Amount"))
{
obj.Amount = double.Parse(dt.Rows[i]["Amount"].ToString());
}
if (dt.Columns.Contains("E_Qty"))
{
obj.E_Qty = double.Parse(dt.Rows[i]["E_Qty"].ToString());
}
if (dt.Columns.Contains("E_Amt"))
{
obj.E_Amt = double.Parse(dt.Rows[i]["E_Amt"].ToString());
}
if (dt.Columns.Contains("Description"))
{
obj.Description = dt.Rows[i]["Description"].ToString();
}
if (dt.Columns.Contains("Sorted"))
{
obj.Sorted = long.Parse(dt.Rows[i]["Sorted"].ToString());
}
if (dt.Columns.Contains("Book_ID"))
{
obj.Book_ID = dt.Rows[i]["Book_ID"].ToString();
}
rs.Add(obj);
}
return(rs);
}