[HttpGet] //To take all preference of the view public string GetPreferenceColumnOfViewAll(int idView) { SQLServerManager SQL = new SQLServerManager(SqlCnxStr); string preferenceOfView = SQL.SP_GetPreferenceColumnOfViewAll(SqlCnxStr, idView); return(preferenceOfView); }
[HttpGet] // Return the list of the table (that is accessible by the user) public string GetViewList(int ID_User) { SQLServerManager SQL = new SQLServerManager(SqlCnxStr); string primaryList = SQL.SP_GetViewList(SqlCnxStr, ID_User); return(primaryList); }
[HttpGet]// Return color choosen by user by type of line in JSON text public string GetUserColorSetting(int ID_User) { SQLServerManager SQL = new SQLServerManager(SqlCnxStr); string result = SQL.SP_GetUserColorSetting(SqlCnxStr, ID_User); return(result); }
[HttpGet] // Return the list of table public string getTableList() { SQLServerManager SQL = new SQLServerManager(SqlCnxStr); string list = SQL.SP_GetTableList(SqlCnxStr); return(list); }
[HttpPost]// To update options of all the view public bool UpdatePreferenceColumnOfViewAll(int idView, string[] primaryList, string[] secondaryLsit) { SQLServerManager SQL = new SQLServerManager(SqlCnxStr); string primaryListStr = ""; string secondaryListStr = ""; if (primaryList != null) { foreach (string ele in primaryList) { primaryListStr += ele + ", "; } primaryListStr.Remove(primaryListStr.Length - 2, 2); } if (secondaryLsit != null) { foreach (string ele in secondaryLsit) { secondaryListStr += ele + ", "; } secondaryListStr.Remove(secondaryListStr.Length - 2, 2); } return(SQL.SP_UpdatePreferenceColumnOfViewAll(SqlCnxStr, idView, primaryListStr, secondaryListStr)); }
[HttpGet]// Return TOP 10 of the most imported order public string GetTop10ImportedOrder() { SQLServerManager SQL = new SQLServerManager(SqlCnxStr); string result = SQL.SP_GetTop10ImportedOrder(SqlCnxStr); return(result); }
[HttpGet] // To get the different type of line in the table public string GetTypeLineOfTable(string tableName) { SQLServerManager SQL = new SQLServerManager(SqlCnxStr); string primaryList = SQL.SP_GetTypeLineOfTable(SqlCnxStr, tableName); return(primaryList); }
[HttpGet]// Return color choosen by user by type of line in JSON text public string UpdateUserColorSetting(int ID_User, string ColorValueList) { SQLServerManager SQL = new SQLServerManager(SqlCnxStr); string result = SQL.SP_UpdateUserColorSetting(SqlCnxStr, ID_User, ColorValueList); return(result); }
[HttpGet] // Return the BOM of the order public string GetNomenclatureLines(long idOrder) { SQLServerManager SQL = new SQLServerManager(SqlCnxStr); string jsonOrder = SQL.SP_GetOrderComponents(SqlCnxStr, idOrder); return(jsonOrder); }
[HttpGet] // To load the list options of the table targeted public string getListOfTypeLine(string systemName, string libraryName, string tableName, int ID_SubLevel, int ID_View, int DetailLevel) { SQLServerManager SQL = new SQLServerManager(SqlCnxStr); string list = SQL.SP_GetListOfTypeLine(SqlCnxStr, systemName, libraryName, tableName, ID_SubLevel, ID_View, DetailLevel); return(list); }
[HttpGet]// Load chhid line data of the line number specified with the configuration of the current view public string GetCustomJsonAllLine(int ID_View, string TableName, int IdDataSource, int idTreeview, int tvLength) { SQLServerManager SQL = new SQLServerManager(SqlCnxStr); string JsonTreeview = SQL.SP_GetCustomJsonAllLine(SqlCnxStr, ID_View, TableName, IdDataSource, idTreeview, tvLength); return(JsonTreeview); }
[HttpGet] // Return all line number from order public string GetNumberOrderLineFromOrder(int orderNumber, string orderAgence, string systemName) { SQLServerManager sql = new SQLServerManager(SqlCnxStr); string result = sql.SP_GetNumberOrderLineFromOrder(SqlCnxStr, orderNumber, orderAgence, systemName); return(result); }
[HttpGet]// Return all the Sub levels of all table public string GetTableSubLevels() { SQLServerManager SQL = new SQLServerManager(SqlCnxStr); string lineList = SQL.SP_GetTableSubLevels(SqlCnxStr); return(lineList); }
[HttpGet]// Load order + line order data of the order specified with the configuration of the current view public string GetCustomJsonOrderFirstLine(int ID_Order, int ID_View, string OrderLine) { SQLServerManager SQL = new SQLServerManager(SqlCnxStr); string JsonTreeview = SQL.SP_GetCustomJsonOrderFirstLine(SqlCnxStr, ID_Order, ID_View, OrderLine); return(JsonTreeview); }
[HttpGet]// Return all the Sub levels of all table public bool UpdatePreferenceLineOfView(int ID_View, string ListLine) { SQLServerManager SQL = new SQLServerManager(SqlCnxStr); bool res = SQL.SP_UpdatePreferenceLineOfView(SqlCnxStr, ID_View, ListLine); return(res); }
[HttpGet]// Return all the Sub levels of all table public string GetPreferenceLineOfView(int ID_View) { SQLServerManager SQL = new SQLServerManager(SqlCnxStr); string lineList = SQL.SP_GetPreferenceLineOfView(SqlCnxStr, ID_View); return(lineList); }
[HttpGet]// Return all the Sub levels of all table public bool UpdateLastViewUsed(int ID_User, int ID_View) { SQLServerManager SQL = new SQLServerManager(SqlCnxStr); bool result = SQL.SP_UpdateLastViewUsed(SqlCnxStr, ID_User, ID_View); return(result); }
[HttpGet]// Return color choosen by user by type of line in JSON text public string GetSettingDisplayDeletedLine(int ID_User) { SQLServerManager SQL = new SQLServerManager(SqlCnxStr); string result = SQL.SP_GetSettingDisplayDeletedLine(SqlCnxStr, ID_User); return(result); }
[HttpGet]// Load every data of the version of the order specified with the configuration of the current view public string getOrderVersion(int idOrder, int idVersion, int idView) { SQLServerManager SQL = new SQLServerManager(SqlCnxStr); string JsonTreeview = SQL.SP_GetCustomJsonOrderVersion(SqlCnxStr, idOrder, idVersion, idView); return(JsonTreeview); }
[HttpGet]// Return color choosen by user by type of line in JSON text public string GetLastOrderDisplayed(int ID_User) { SQLServerManager SQL = new SQLServerManager(SqlCnxStr); string result = SQL.SP_GetLastOrderDisplayed(SqlCnxStr, ID_User); return(result); }
[HttpGet]// Retourne le nombre de version trouvé pour la commande public string GetNumberOrderVersion(string OrderAgence, int OrderNumber) { SQLServerManager SQL = new SQLServerManager(SqlCnxStr); string numberOrderVersion = SQL.SP_GetNumberOrderVersion(SqlCnxStr, OrderAgence, OrderNumber); return(numberOrderVersion); }
[HttpGet] // Copy the order in DB_BOM_VIEWER from AS400 public long ImportOrderLineFromAS400(Search recherche, int?idOrder) { SQLServerManager sql = new SQLServerManager(SqlCnxStr); long result = sql.SP_ImportOrderLineFromAS400(SqlCnxStr, recherche.agency, recherche.orderNumber, "MURPHY_CT", recherche.library.ToUpper(), recherche.line, idOrder); return(result); }
[HttpGet]// Load every data of the version of the order version specified public int GetSpecifiedOrderVersion(string orderAgence, int orderNumber, int orderVersion, int ID_View) { SQLServerManager SQL = new SQLServerManager(SqlCnxStr); int idOrder = SQL.SP_GetSpecifiedOrderVersion(SqlCnxStr, orderAgence, orderNumber, orderVersion, ID_View); return(idOrder); }
[HttpGet] // Return the BOM of the order public bool SetOrderIsComplete(int idOrder) { SQLServerManager SQL = new SQLServerManager(SqlCnxStr); bool res = SQL.SP_SetOrderIsComplete(SqlCnxStr, idOrder); return(res); }
[HttpGet]// Return detail line text with all field of the table public string GetDetailLineData(int ID_View, string TableSubLevelType, string TableName, string JsonField) { SQLServerManager SQL = new SQLServerManager(SqlCnxStr); string result = SQL.SP_GetDetailLineData(SqlCnxStr, ID_View, TableSubLevelType, TableName, JsonField); return(result); }
/// <summary> /// 根据条件查询日志分页信息 /// </summary> /// <param name="qModel">查询条件</param> /// <param name="pageM">分页对象</param> /// <returns>日志信息</returns> public MPagingData <List <LogModel> > GetInfoByWhere(LogQueryModel qModel, MPagingModel pageM) { DataSet ds = SQLServerManager.Pagination(qModel.GetQuerySQL(false), qModel.GetGroupStr(), pageM.PagingIndex, pageM.PagingSize); MPagingData <List <LogModel> > resM = new MPagingData <List <LogModel> >(); resM.Data = ConvertManager.DataTableToList <LogModel>(ds.Tables[0]); pageM.PagingIndex = Convert.ToInt32(ds.Tables[1].Rows[0][0]); pageM.DataCount = Convert.ToInt32(ds.Tables[1].Rows[0][1]); pageM.PagingCount = Convert.ToInt32(ds.Tables[1].Rows[0][2]); resM.PageInfo = pageM; return(resM); }
[HttpGet] // To update options of a selected SubLevel of view public bool UpdatePreferenceColumnOfView(int idView, int idSubLevel, string[] primaryList, string[] secondaryList) { SQLServerManager SQL = new SQLServerManager(SqlCnxStr); string primaryListStr = ""; string secondaryListStr = ""; if (primaryList != null) { foreach (string ele in primaryList) { primaryListStr += ele + ", "; } } if (secondaryList != null) { foreach (string ele in secondaryList) { secondaryListStr += ele + ", "; } } return(SQL.SP_UpdatePreferenceColumnOfView(SqlCnxStr, idView, idSubLevel, primaryListStr, secondaryListStr)); }
/// <summary> /// 修改一条日志 /// </summary> /// <param name="model">要修改的日志对象</param> public void Update(LogModel model) { SQLServerManager.Update(model); }
/// <summary> /// 根据条件查询日志信息 /// </summary> /// <param name="qModel">查询条件</param> /// <returns>日志信息</returns> public List <LogModel> GetInfoByWhere(LogQueryModel qModel) { DataSet ds = SQLServerManager.ExecuteQuery(qModel.GetQuerySQL(), qModel.ListParams.ToArray()); return(ConvertManager.DataTableToList <LogModel>(ds.Tables[0], true)); }
/// <summary> /// 删除一条日志 /// </summary> /// <param name="model">要删除的日志对象</param> public void Delete(LogModel model) { SQLServerManager.Delete(model); }