private void searchSanPham_CloseUp(object sender, DevExpress.XtraEditors.Controls.CloseUpEventArgs e)
{
int focus = dgvDetails.FocusedRowHandle;
if (focus >= 0)
{
SearchLookUpEdit edit = sender as SearchLookUpEdit;
if (e.AcceptValue)
{
ProductSelect row = (edit.Properties.GetRowByKeyValue(e.Value) as ProductSelect);
dgvDetails.SetFocusedRowCellValue("ProductCode", row.ProductCode.ToString());
dgvDetails.SetFocusedRowCellValue("ID", row.ID.ToString());
dgvDetails.SetFocusedRowCellValue("ProductName", row.ProductName.ToString());
dgvDetails.SetFocusedRowCellValue("Price", row.Price.ToString());
focus = dgv_Main.FocusedRowHandle;
if (focus >= 0)
{
dgv_Main.SetFocusedRowCellValue("TongTien", listdetails.Sum(o => o.ThanhTien));
dgv_Main.BestFitColumns(true);
}
dgvDetails.BestFitColumns(true);
}
}
}
/// <summary>
/// Load Thông Tin Sản Phẩm
/// </summary>
private void LoadInfoProduct()
{
try
{
//string sLink = Form_Main.URL_API + "/api/IPC247/sp_extension_GetDataByStore?sql_Exec=" + "sp_Get_Product_Select";
//var json = API.API_GET(sLink);
//var jsondata = JObject.Parse(json).GetValue("Data");
//var ds = JsonConvert.DeserializeObject<List<ProductSelect>>(jsondata.ToString());
DataTable dt = SQLHelper.ExecuteDataTable("sp_Get_Product_Select");
List <ProductSelect> listob = new List <ProductSelect>();
for (int i = 0; i < dt.Rows.Count; i++)
{
string ID = dt.Rows[i]["ID"].ToString();
string ProductCode = dt.Rows[i]["ProductCode"].ToString();;
string ProductName = dt.Rows[i]["ProductName"].ToString();;
string Description = dt.Rows[i]["Description"].ToString();;
decimal Price = decimal.Parse(dt.Rows[i]["Price"].ToString());
ProductSelect ob = new ProductSelect(ID, ProductCode, ProductName, Description, Price);
listob.Add(ob);
}
searchSanPham.DataSource = listob;
}
catch (Exception ex)
{
API.API_ERRORLOG(new ERRORLOG(Form_Main.IPAddress, "Form_ProductGroup", "LoadInfoProduct()", ex.ToString()));
}
}