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