public string ExportInventoryReportDetail(int userID, int factoryWarehouseID, int?productionTeamID, string startDate, string endDate, out Library.DTO.Notification notification) { notification = new Library.DTO.Notification(); notification.Type = Library.DTO.NotificationType.Success; string fileName = string.Empty; InventoryDataObject ds = new InventoryDataObject(); try { //// Get company. //Framework.DAL.DataFactory fwFactory = new Framework.DAL.DataFactory(); //int? companyID = fwFactory.GetCompanyID(userID); //// Get factory warehouse. //int? factoryWID = (factoryWarehouseID <= 0) ? (int?)null : factoryWarehouseID; //int? productionTID = (productionTeamID <= 0) ? (int?)null : productionTeamID; //System.Data.SqlClient.SqlDataAdapter adap = new System.Data.SqlClient.SqlDataAdapter(); //adap.SelectCommand = new System.Data.SqlClient.SqlCommand("InventoryRpt_function_ExportExcel", new System.Data.SqlClient.SqlConnection(Library.Helper.GetSQLConnectionString())); //adap.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure; //adap.SelectCommand.Parameters.AddWithValue("@companyID", companyID); //adap.SelectCommand.Parameters.AddWithValue("@factoryWarehouseID", factoryWID); //adap.SelectCommand.Parameters.AddWithValue("@productionTeamID", productionTID); //adap.SelectCommand.Parameters.AddWithValue("@startDate", startDate); //adap.SelectCommand.Parameters.AddWithValue("@endDate", endDate); //adap.TableMappings.Add("Table", "WarehouseData"); //adap.TableMappings.Add("Table1", "InventoryData"); //adap.TableMappings.Add("Table2", "InventoryDetailData"); //adap.Fill(ds); //InventoryDataObject.CommonDataRow hRow = ds.CommonData.NewCommonDataRow(); //hRow.ReportDate = DateTime.Now.ToString("dd/MM/yyyy"); //hRow.StartDate = startDate; //hRow.EndDate = endDate; //hRow.FactoryWarehouseID = factoryWarehouseID; //ds.CommonData.AddCommonDataRow(hRow); //ds.Tables.Remove("InventoryRpt_Inventory_View"); //ds.Tables.Remove("InventoryRpt_InventoryDetail_View"); //ds.AcceptChanges(); //fileName = Library.Helper.CreateReportFileWithEPPlus2(ds, "InventoryDetail"); } catch (Exception ex) { notification.Type = Library.DTO.NotificationType.Error; notification.Message = ex.Message; if (ex.InnerException != null && !string.IsNullOrEmpty(ex.InnerException.Message)) { notification.DetailMessage.Add(ex.InnerException.Message); } } return(fileName); }
/// <summary> /// Inventories the item popup. /// </summary> /// <returns>The item popup.</returns> /// <param name="_control">Control.</param> /// <param name="_title">Title.</param> /// <param name="_hint">Hint.</param> /// <param name="_name">Name.</param> /// <param name="_help">Help.</param> public static string InventoryItemPopup(ICECreatureControl _control, string _title, string _hint, string _name, string _help = "") { if (_control == null) { return(""); } InventoryDataObject _inventory = _control.Creature.Status.Inventory; if (_inventory == null || _inventory.Slots.Count == 0) { EditorGUILayout.LabelField(_title + " (- no reference item - check register!)"); return(""); } else { List <string> _keys = _inventory.AvailableItems; _keys.Insert(0, " "); string[] _names = new string[_keys.Count]; int _index = 0; for (int i = 0; i < _keys.Count; i++) { if (_keys[i] == " " && i == 0) { _names[i] = " "; } else if (_keys[i] == " ") { _names[i] = ""; } else { _names[i] = _keys[i]; } if (_name == _names[i]) { _index = i; } } if (ICE.World.Utilities.SystemTools.FindChildByName(_name, _control.gameObject.transform) != null) { GUI.backgroundColor = Color.green; } if (_title.Trim() != "") { _index = ICEEditorLayout.Popup(_title, _hint, _index, _names, _help); } else { _index = EditorGUILayout.Popup(_index, _names); } GUI.backgroundColor = ICEEditorLayout.DefaultBackgroundColor; return(_names[_index].Trim()); } }
public string ExportInventoryReport(int userID, int factoryWarehouseID, int?productionTeamID, string startDate, string endDate, out Library.DTO.Notification notification) { notification = new Library.DTO.Notification(); notification.Type = Library.DTO.NotificationType.Success; string fileName = ""; try { Framework.DAL.DataFactory frameworkFactory = new Framework.DAL.DataFactory(); int?companyID = frameworkFactory.GetCompanyID(userID); int?factoryWID = (factoryWarehouseID <= 0) ? (int?)null : factoryWarehouseID; int?productionTID = (productionTeamID <= 0) ? (int?)null : productionTeamID; if (!factoryWID.HasValue && !productionTID.HasValue) { notification.Type = NotificationType.Error; notification.Message = "Please select one Factory Warehouse or one Production Team to search"; return(fileName); } InventoryDataObject ds = new InventoryDataObject(); System.Data.SqlClient.SqlDataAdapter adap = new System.Data.SqlClient.SqlDataAdapter(); if (factoryWID.HasValue) { adap.SelectCommand = new System.Data.SqlClient.SqlCommand("InventoryOverviewRpt_function_ExportInventoryWithFactoryWarehouse", new System.Data.SqlClient.SqlConnection(Library.Helper.GetSQLConnectionString())); adap.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure; adap.SelectCommand.Parameters.AddWithValue("@FactoryWarehouseID", factoryWID); } if (productionTID.HasValue) { adap.SelectCommand = new System.Data.SqlClient.SqlCommand("InventoryOverviewRpt_function_ExportInventoryWithProductionTeam", new System.Data.SqlClient.SqlConnection(Library.Helper.GetSQLConnectionString())); adap.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure; adap.SelectCommand.Parameters.AddWithValue("@ProductionTeamID", productionTID); } adap.SelectCommand.Parameters.AddWithValue("@StartDate", startDate); adap.SelectCommand.Parameters.AddWithValue("@EndDate", endDate); adap.SelectCommand.Parameters.AddWithValue("@CompanyID", companyID); adap.TableMappings.Add("Table", "CommonData"); adap.TableMappings.Add("Table1", "InventoryData"); adap.TableMappings.Add("Table2", "ClientData"); adap.Fill(ds); //ds.AcceptChanges(); foreach (var inventoryItem in ds.InventoryData.ToList()) { var clientUDs = ds.ClientData.Where(o => o.ProductionItemUD == inventoryItem.ProductionItemUD).Select(s => s.ClientUD); if (clientUDs != null && clientUDs.Count() > 0) { inventoryItem.ClientUD = clientUDs.Aggregate((i, j) => i + "," + j); } } fileName = Library.Helper.CreateReportFileWithEPPlus2(ds, "Inventory"); } catch (Exception ex) { notification.Type = NotificationType.Error; notification.Message = Library.Helper.GetInnerException(ex).Message; } return(fileName); }
/// Custom function export data (new version) /// FactoryWarehouses: list selected from front-end /// ProductionTeamID /// StartDate, EndDate public object CustomExportDataWithFilter(int userID, Hashtable filters, out Notification notification) { notification = new Notification(); notification.Type = NotificationType.Success; string path = null; try { string factoryWarehouses = null; int? productionTeamID = null; string startDate = null; string endDate = null; int? companyID = null; if (filters.ContainsKey("factoryWarehouses") && filters["factoryWarehouses"] != null && !string.IsNullOrEmpty(filters["factoryWarehouses"].ToString())) { factoryWarehouses = filters["factoryWarehouses"].ToString(); } if (filters.ContainsKey("productionTeamID") && filters["productionTeamID"] != null && !string.IsNullOrEmpty(filters["productionTeamID"].ToString())) { productionTeamID = (int?)Convert.ToInt32(filters["productionTeamID"].ToString()); } if (filters.ContainsKey("startDate") && filters["startDate"] != null && !string.IsNullOrEmpty(filters["startDate"].ToString())) { startDate = filters["startDate"].ToString(); } if (filters.ContainsKey("endDate") && filters["endDate"] != null && !string.IsNullOrEmpty(filters["endDate"].ToString())) { endDate = filters["endDate"].ToString(); } if (factoryWarehouses == null && productionTeamID == null) { notification.Type = NotificationType.Error; notification.Message = "Please select factory warehouse or production team!"; return(path); } if (startDate == null || endDate == null) { notification.Type = NotificationType.Error; notification.Message = "Please fill start date and end date!"; return(path); } using (var context = CreateContext()) { InventoryDataObject ds = new InventoryDataObject(); System.Data.SqlClient.SqlDataAdapter adap = new System.Data.SqlClient.SqlDataAdapter(); if (!string.IsNullOrEmpty(factoryWarehouses)) { adap.SelectCommand = new System.Data.SqlClient.SqlCommand("InventoryOverviewRpt_function_ExportInventoryWithFactoryWarehouse", new System.Data.SqlClient.SqlConnection(Library.Helper.GetSQLConnectionString())); adap.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure; adap.SelectCommand.Parameters.AddWithValue("@factoryWarehouses", factoryWarehouses); } if (productionTeamID.HasValue) { Framework.DAL.DataFactory fwFactory = new Framework.DAL.DataFactory(); companyID = fwFactory.GetCompanyID(userID); adap.SelectCommand = new System.Data.SqlClient.SqlCommand("InventoryOverviewRpt_function_ExportInventoryWithProductionTeam", new System.Data.SqlClient.SqlConnection(Library.Helper.GetSQLConnectionString())); adap.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure; adap.SelectCommand.Parameters.AddWithValue("@productionTeamID", productionTeamID); adap.SelectCommand.Parameters.AddWithValue("@companyID", companyID); } adap.SelectCommand.Parameters.AddWithValue("@startDate", startDate); adap.SelectCommand.Parameters.AddWithValue("@endDate", endDate); adap.TableMappings.Add("Table", "CommonData"); adap.TableMappings.Add("Table1", "InventoryData"); adap.TableMappings.Add("Table2", "ClientData"); adap.Fill(ds); foreach (var inventoryItem in ds.InventoryData.ToList()) { var clientUDs = ds.ClientData.Where(o => o.ProductionItemUD == inventoryItem.ProductionItemUD).Select(s => s.ClientUD); if (clientUDs != null && clientUDs.Count() > 0) { inventoryItem.ClientUD = clientUDs.Aggregate((i, j) => i + "," + j); } } path = Library.Helper.CreateReportFileWithEPPlus2(ds, "Inventory"); } } catch (Exception ex) { notification.Type = NotificationType.Error; notification.Message = Library.Helper.GetInnerException(ex).Message; } return(path); }