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