private void QueryMaterial()
{
try
{
DataTable dt = new ExtractInventoryTool_MaterialBLL().QueryMaterialExtension();
_materialList = new List <ExtractInventoryTool_MaterialExtension>();
foreach (DataRow row in dt.Rows)
{
ExtractInventoryTool_MaterialExtension material = new ExtractInventoryTool_MaterialExtension();
material.Oid = row["Oid"] == DBNull.Value ? 0 : Convert.ToInt32(row["Oid"]);
material.Name = row["Name"] == DBNull.Value ? "" : (string)row["Name"];
material.Code = row["Code"] == DBNull.Value ? "" : (string)row["Code"];
material.Supplier = row["Supplier"] == DBNull.Value ? "" : (string)row["Supplier"];
material.SupplierCode = row["SupplierCode"] == DBNull.Value ? "" : (string)row["SupplierCode"];
material.Client = row["Client"] == DBNull.Value ? 0 : Convert.ToInt32(row["Client"]);
material.ClientName = row["ClientName"] == DBNull.Value ? "" : (string)row["ClientName"];
material.ClientCode = row["ClientCode"] == DBNull.Value ? "" : (string)row["ClientCode"];
material.UniqueCode = row["UniqueCode"] == DBNull.Value ? "" : (string)row["UniqueCode"];
_materialList.Add(material);
}
QueryMaterialCallbackDel del = QueryMaterialCallback;
comboBox1.BeginInvoke(del, _materialList);
return;
}
catch (Exception ex)
{
LogHelper.WriteLog("QueryClient", ex);
}
}
public void DeleteMaterialRecords(string tableName, List <string> ids)
{
string errorMessage = string.Empty;
int result = new ExtractInventoryTool_MaterialBLL().DeleteRecords(tableName, ids, out errorMessage);
DeleteRecordsCallbackDel del = DeleteRecordsCallback;
dataGridView1.BeginInvoke(del, errorMessage);
}
/// <summary>
/// 查询当前客户的物料
/// </summary>
public void QueryMaterialByClientID(string clientID)
{
DataTable dt = new ExtractInventoryTool_MaterialBLL().QueryMaterialByClientID(clientID);
QueryMaterialCallbackDel del = QueryMaterialCallback;
dataGridView2.BeginInvoke(del, dt);
return;
}
public void SaveMaterialExcel(List <ExtractInventoryTool_Material> excelData, bool isCover)
{
string errorMessage = string.Empty;
bool importResult = false;
importResult = new ExtractInventoryTool_MaterialBLL().ImportMaterial(_excelData, isCover, out errorMessage);
SaveMaterialExcelCallbackDel del = SaveMaterialExcelCallback;
this.BeginInvoke(del, importResult, errorMessage);
}
