public Object GetFieldValueList() { Object result = null; RequestPackage rqp = RequestPackage.ParseRequest(Request.InputStream, Request.ContentEncoding); String fieldName = rqp["field"] as String; if (!String.IsNullOrWhiteSpace(fieldName)) { String term = rqp["term"] as String; if (!String.IsNullOrWhiteSpace(term)) { rqp.Command = "Goods.dbo.get_field_value_list"; //rqp.AddSessionIdToParameters(); ResponsePackage rsp = rqp.GetResponse("http://" + NskdEnv.DATA_SERVICE_HOST + ":" + NskdEnv.DATA_SERVICE_HOST_SQL_PORT_V12 + "/"); DataTable dt = rsp.GetFirstTable(); if (dt != null && dt.Rows.Count > 0 && dt.Columns.Count > 1 && dt.Columns[1].DataType == typeof(String)) { String[] list = new String[dt.Rows.Count]; for (Int32 ri = 0; ri < dt.Rows.Count; ri++) { list[ri] = dt.Rows[ri][1] as String; } result = list; } } } return(Nskd.JsonV2.ToString(result)); }
public FilteredData(F0Model m) { if (m.Rqp != null && m.Rqp.SessionId != null) { RequestPackage rqp = new RequestPackage(); rqp.SessionId = m.Rqp.SessionId; rqp.Command = "Supply.dbo.отчёт_мдв_1"; rqp.Parameters = new RequestParameter[] { new RequestParameter() { Name = "session_id", Value = m.Rqp.SessionId }, //new RequestParameter() { Name = "все", Value = m.Filter.все } }; //if (!String.IsNullOrWhiteSpace(m.Filter.дата_min)) rqp["дата_min"] = m.Filter.дата_min; //if (!String.IsNullOrWhiteSpace(m.Filter.дата_max)) rqp["дата_max"] = m.Filter.дата_max; //if (!String.IsNullOrWhiteSpace(m.Filter.менеджер)) rqp["менеджер"] = m.Filter.менеджер; ResponsePackage rsp = rqp.GetResponse("http://127.0.0.1:11012"); if (rsp != null) { dt = rsp.GetFirstTable(); } } }
public СтрокаДанных GetTableDetail() { СтрокаДанных row = null; if (rqp != null && rqp.SessionId != null) { Guid.TryParse(rqp["uid"] as String, out Guid uid); RequestPackage rqp1 = new RequestPackage() { SessionId = rqp.SessionId, Command = "Supply.dbo.заказы_у_поставщиков_таблица__получить", Parameters = new RequestParameter[] { new RequestParameter() { Name = "session_id", Value = rqp.SessionId }, new RequestParameter() { Name = "uid", Value = uid } } }; ResponsePackage rsp1 = rqp1.GetResponse("http://127.0.0.1:11012"); if (rsp1 != null) { ТаблицаДанных table = new ТаблицаДанных(rsp1.GetFirstTable()); if (table != null && table.RowsCount > 0) { row = table[0]; } } } return(row); }
private ТаблицаДанных ПолучитьЗаказыУПоставщиковШапка(Guid sessionId, Guid order_uid) { ТаблицаДанных table = null; RequestPackage rqp1 = new RequestPackage(); rqp1.SessionId = sessionId; rqp1.Command = "Supply.dbo.заказы_у_поставщиков_шапка__получить"; rqp1.Parameters = new RequestParameter[] { new RequestParameter() { Name = "session_id", Value = sessionId }, new RequestParameter() { Name = "uid", Value = order_uid } }; ResponsePackage rsp1 = rqp1.GetResponse("http://127.0.0.1:11012"); if (rsp1 != null) { table = new ТаблицаДанных(rsp1.GetFirstTable()); } return(table); }
public Dictionary <String, String> FilterFields; // словарь с данными по полям для фильтрации private void ApplyFilter(RequestPackage rqp) { rqp.Command = "[dbo].[спецификации_get_by_filter_v2]"; rqp.SetDBNullValueForNullOrEmptyOrWhiteSpaceParameterValue(); rqp.AddSessionIdToParameters(); ResponsePackage rsp = rqp.GetResponse("http://" + NskdEnv.DATA_SERVICE_HOST + ":" + NskdEnv.DATA_SERVICE_HOST_SQL_PORT_V12 + "/"); FilteredData = rsp.GetFirstTable(); }
public Object DetailSave() { Object r = null; RequestPackage rqp = RequestPackage.ParseRequest(Request.InputStream, Request.ContentEncoding); rqp.AddSessionIdToParameters(); rqp.Command = "[Pharm-Sib].[dbo].[спецификации_шапка_update_from_not_null_values]"; ResponsePackage rsp = rqp.GetResponse("http://" + NskdEnv.DATA_SERVICE_HOST + ":" + NskdEnv.DATA_SERVICE_HOST_SQL_PORT + "/"); if (rsp != null) { r = PartialView("~/Areas/Prep/Views/F0/Detail.cshtml", rsp.GetFirstTable()); } return(r); }
public Object SaveDocsRetComm() { Object r = "Reports.Controllers.R1Controller.SaveDocsRetComm()\n"; RequestPackage rqp = RequestPackage.ParseRequest(Request.InputStream, Request.ContentEncoding); rqp.AddSessionIdToParameters(); r += Nskd.JsonV3.ToString(rqp) + "\n"; ResponsePackage rsp = rqp.GetResponse("http://127.0.0.1:11012/"); DataTable dt = rsp.GetFirstTable(); if (dt != null && dt.Columns.Contains("docs_ret_comm") && dt.Rows.Count > 0) { r = dt.Rows[0]["docs_ret_comm"] as String; } return(r); }
private DataTable ПолучитьСписокСостоянийЗаказа(F0Model m) { DataTable dt = null; RequestPackage rqp = new RequestPackage { SessionId = m.rqp.SessionId, Command = "Supply.dbo.состояния_заказа__получить", Parameters = new RequestParameter[] { new RequestParameter() { Name = "session_id", Value = m.rqp.SessionId } } }; ResponsePackage rsp = rqp.GetResponse("http://127.0.0.1:11012"); if (rsp != null) { dt = rsp.GetFirstTable(); } return(dt); }
public static DataTable F1GetДоговоры(String f4, String f13, String f15) { DataTable dt = null; RequestPackage rqp = new RequestPackage { Command = "[dbo].[договоры_покупатели_select_from_Garza_with__or_filter__]", Parameters = new RequestParameter[] { new RequestParameter { Name = "f4", Value = f4 }, new RequestParameter { Name = "f13", Value = f13 }, new RequestParameter { Name = "f15", Value = f15 } } }; ResponsePackage rsp = rqp.GetResponse("http://127.0.0.1:11012/"); dt = rsp.GetFirstTable(); return(dt); }
public F1Model(Guid sessionId) { Status = "FNet.Settings.Models.F1Model(): "; DataTable dt = new DataTable(); RequestPackage rqp = new RequestPackage() { SessionId = sessionId, Command = "[Grls].[dbo].[Ссылки на РУ сравнение дат]", Parameters = new RequestParameter[] { new RequestParameter() { Name = "session_id", Value = sessionId } } }; ResponsePackage rsp = rqp.GetResponse("http://127.0.0.1:11012"); if (rsp != null) { dt = rsp.GetFirstTable(); } Data = new DataTable(); // Data Columns { DataColumn dc0 = Data.Columns.Add("Ссылка", typeof(String)); dc0.Caption = "Ссылка"; dc0.ExtendedProperties.Add("Width", 120d); DataColumn dc1 = Data.Columns.Add("Номер", typeof(String)); dc1.Caption = "Номер"; dc1.ExtendedProperties.Add("Width", 20d); DataColumn dc2 = Data.Columns.Add("Дата FILE", typeof(String)); dc2.Caption = "Дата FILE"; dc2.ExtendedProperties.Add("Width", 14d); DataColumn dc3 = Data.Columns.Add("Дата GRLS", typeof(String)); dc3.Caption = "Дата GRLS"; dc3.ExtendedProperties.Add("Width", 14d); DataColumn dc4 = Data.Columns.Add("Обновить", typeof(String)); dc4.Caption = "Обновить"; dc4.ExtendedProperties.Add("Width", 7d); } TotalRowsCount = dt.Rows.Count; NeedToRefreshRowsCount = 0; foreach (DataRow dr in dt.Rows) { String dr0 = dr[0] as String; if (dr0 == null) { dr0 = String.Empty; } String dr1 = dr[1] as String; if (dr1 == null) { dr1 = String.Empty; } Object dateFile = dr[2]; String dateFileAsString = (dateFile == DBNull.Value) ? "" : ((DateTime)dateFile).ToString("dd.MM.yyyy"); Object dateGrls = dr[3]; String dateGrlsAsString = (dateGrls == DBNull.Value) ? "" : ((DateTime)dateGrls).ToString("dd.MM.yyyy"); Boolean needToRefresh = false; if (dateFile != DBNull.Value && dateGrls != DBNull.Value && (DateTime)dateFile < (DateTime)dateGrls) { needToRefresh = true; NeedToRefreshRowsCount++; } Data.Rows.Add(new Object[] { dr0, dr1, dateFileAsString, dateGrlsAsString, (needToRefresh ? "v" : "") }); } }