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