public static string FormAnnualContractInsertTechlist(string name, string cityId, string cityName, string visible, string minPrice, int time)
{
ExcelWorker ex = new ExcelWorker(Environment.TlAnnualInsertPath);
int i = 1;
while (i <= time + 1)
{
ex.SetCell("A" + (i + 1), "1");
ex.SetCell("B" + (i + 1), name);
ex.SetCell("C" + (i + 1), cityId);
ex.SetCell("D" + (i + 1), cityName);
ex.SetCell("E" + (i + 1), visible);
ex.SetCell("F" + (i + 1), "N");
ex.SetCell("G" + (i + 1), minPrice);
ex.SetCell("H" + (i + 1), time.ToString());
if (i != time + 1)
{
ex.SetCell("K" + (i + 1), i.ToString());
}
ex.SetCell("L" + (i + 1), (i + 5).ToString());
i++;
}
return(Techlist.SaveAndClose(ref ex, "annual_ins"));
}
/// <summary>
///
/// </summary>
/// <param name="status">
/// Статус:
/// A - активный публичный,
/// N - публичный только для новых,
/// R - непубличный, подключения только в HD,
/// P - непубличный для партнеров, подключения только в HD и IDMS
/// O - архивный,
/// S - служебный
/// </param>
/// <param name="serviceName"></param>
/// <returns></returns>
public static string FormFttbUpdateTechlist(string idService, string status, string serviceName)
{
ExcelWorker ex = new ExcelWorker(Environment.TlFttbUpdatePath);
ex.SetCell("D2", idService);
ex.SetCell("C2", status);
ex.SetCell("E2", serviceName);
return(Techlist.SaveAndClose(ref ex, "fttb_upd"));
}
public static string FormNetphoneServicesUpdateTechlist(string serviceId, string serviceName, string visible)
{
ExcelWorker ex = new ExcelWorker(Environment.TlNetphoneUpdatePath);
ex.SetCell("A2", serviceId);
ex.SetCell("B2", serviceName);
ex.SetCell("C2", visible);
return(Techlist.SaveAndClose(ref ex, "netphone_serv_upd"));
}
public static string FormIptvServicesInsertTechlist(string cityId, string cityName, string type, string serviceName, string price)
{
ExcelWorker ex = new ExcelWorker(Environment.TlIptvServicesInsertPath);
ex.SetCell("A2", cityId);
ex.SetCell("B2", cityName);
ex.SetCell("C2", type);
ex.SetCell("E2", serviceName);
ex.SetCell("F2", price);
return(Techlist.SaveAndClose(ref ex, "iptv_serv_ins"));
}
public static string FromBundlesUpdateTechlist(string bundleId, string cityId, string cityName, string visible, string bundleName)
{
ExcelWorker ex = new ExcelWorker(Environment.TlBundlesUpdatePath);
ex.SetCell("A2", bundleId);
ex.SetCell("B2", cityId);
ex.SetCell("C2", cityName);
ex.SetCell("D2", visible);
ex.SetCell("E2", "Игнорировать");
ex.SetCell("F2", bundleName);
ex.SetCell("G2", "Игнорировать");
ex.SetCell("H2", "Игнорировать");
ex.SetCell("I2", "Игнорировать");
ex.SetCell("J2", "Игнорировать");
return(Techlist.SaveAndClose(ref ex, "bundle_upd"));
}
/// <summary>
/// Создание техлиста загрузки новых VDPN тарифов
/// </summary>
/// <param name="status">
/// Статус:
/// A - активный публичный,
/// N - публичный только для новых,
/// R - непубличный, подключения только в HD,
/// P - непубличный для партнеров, подключения только в HD и IDMS
/// O - архивный,
/// S - служебный
/// </param>
/// <param name="category">
/// Категория L- лимитный, S - с понижением скорости, U - безлимитный
/// </param>
/// <param name="debtPeriod">
/// период списания абон. платы:
/// D - ежедневно,
/// M - ежемесячно
///</param>
/// <returns></returns>
public static string FormFttbInsertTechlist(string status, string category, string debtPeriod, string price, string serviceName)
{
ExcelWorker ex = new ExcelWorker(Environment.TlFttbInsertPath);
ex.SetCell("A2", "12042");
ex.SetCell("B2", "Москва");
ex.SetCell("C2", status);
ex.SetCell("E2", serviceName);
ex.SetCell("F2", category);
ex.SetCell("G2", debtPeriod);
ex.SetCell("H2", price);
ex.SetCell("K2", "3520");
ex.SetCell("L2", "3520");
return(Techlist.SaveAndClose(ref ex, "fttb_ins"));
}
private static void FormEqualString(ref ExcelWorker ex, int index, string cityId, string cityName,
string visible, string effectivePrice, string bundleName)
{
ex.SetCell("A" + index, "1");
ex.SetCell("B" + index, cityId);
ex.SetCell("C" + index, cityName);
ex.SetCell("D" + index, visible);
ex.SetCell("F" + index, effectivePrice);
ex.SetCell("G" + index, bundleName);
ex.SetCell("H" + index, "SERVICE_TYPE");
}
public static string FormAnnualContractUpdateTechlist(string serviceId, string cityId, string cityName, string visible, string serviceName)
{
ExcelWorker ex = new ExcelWorker(Environment.TlAnnualUpdatePath);
ex.SetCell("A2", serviceId);
ex.SetCell("B2", cityId);
ex.SetCell("C2", cityName);
ex.SetCell("D2", visible);
ex.SetCell("E2", "N");
ex.SetCell("F2", serviceName);
return(Techlist.SaveAndClose(ref ex, "annual_upd"));
}
public static string FormNetphoneServicesInsertTechlist(string cityId, string cityName, string visible, string serviceName, string price, string atlId)
{
ExcelWorker ex = new ExcelWorker(Environment.TlNetphoneInsertPath);
ex.SetCell("A2", cityId);
ex.SetCell("B2", cityName);
ex.SetCell("C2", serviceName);
ex.SetCell("D2", atlId);
ex.SetCell("E2", price);
ex.SetCell("F2", visible);
return(Techlist.SaveAndClose(ref ex, "netphone_serv_ins"));
}
public static string FromBundlesInsertTechlist(string cityId, string cityName, string visible,
string effectivePrice, string bundleName)
{
ExcelWorker ex = new ExcelWorker(Environment.TlBundlesInsertPath);
FormEqualString(ref ex, 2, cityId, cityName, visible, effectivePrice, bundleName);
FormEqualString(ref ex, 3, cityId, cityName, visible, effectivePrice, bundleName);
FormEqualString(ref ex, 4, cityId, cityName, visible, effectivePrice, bundleName);
FormEqualString(ref ex, 5, cityId, cityName, visible, effectivePrice, bundleName);
ex.SetCell("J2", "VPDN");
ex.SetCell("J3", "W_STOPPABLE_RENT");
ex.SetCell("J4", "IPTV");
ex.SetCell("J5", "STOPPABLE_RENT");
ex.SetCell("L2", "SWITCH");
ex.SetCell("L3", "KEEP");
ex.SetCell("L4", "KEEP");
ex.SetCell("L5", "KEEP");
return(Techlist.SaveAndClose(ref ex, "bundle_ins"));
}
public static string FormIptvPacketsUpdateTechlist(string pkt_id, string pkt_name, string externalId, string effectivePrice)
{
ExcelWorker ex = new ExcelWorker(Environment.TlIptvPacketsUpdatePath);
ex.ChangeSheet(3);
ex.SetCell("A2", pkt_id);
ex.SetCell("B2", pkt_name);
ex.SetCell("C2", "Игнорировать");
ex.SetCell("D2", externalId);
ex.SetCell("E2", "Игнорировать");
ex.SetCell("F2", effectivePrice);
return(Techlist.SaveAndClose(ref ex, "iptv_packet_upd"));
}
public static string FormIptvPacketsInsertTechlist(string basePacketName, string visible, string effectivePrice, string cityId, string cityName)
{
ExcelWorker ex = new ExcelWorker(Environment.TlIptvPacketsInsertPath);
string basePacketNumber = "1";
int line = 2;
int outId = 1;
ex.SetCell("A" + line, (line - 1).ToString());
ex.SetCell("B" + line, basePacketNumber);
ex.SetCell("C" + line, visible);
ex.SetCell("D" + line, basePacketName);
ex.SetCell("H" + line, "0");
ex.SetCell("I" + line, effectivePrice);
ex.SetCell("M" + line, outId.ToString());
outId++;
int typesCount = new Random().Next(1, 7);
int typeIter = 0;
while (typeIter < typesCount)
{
line++;
ex.SetCell("A" + line, (line - 1).ToString());
ex.SetCell("B" + line, basePacketNumber);
ex.SetCell("E" + line, "type_" + typeIter);
ex.SetCell("J" + line, "1");
ex.SetCell("K" + line, "N");
int subtypesCount = new Random().Next(1, 7);
int subtypeIter = 0;
while (subtypeIter < subtypesCount)
{
line++;
ex.SetCell("A" + line, (line - 1).ToString());
ex.SetCell("B" + line, basePacketNumber);
ex.SetCell("F" + line, "type_" + typeIter + "_subtype_" + subtypeIter);
int elementsCount = new Random().Next(1, 7);
int elementIter = 0;
var rnd = new Random();
while (elementIter < elementsCount)
{
var price = rnd.Next(100, 999).ToString();
line++;
ex.SetCell("A" + line, (line - 1).ToString());
ex.SetCell("B" + line, basePacketNumber);
ex.SetCell("C" + line, visible);
ex.SetCell("G" + line, "type_" + typeIter + "_subtype_" + subtypeIter + "_element_" + elementIter);
ex.SetCell("H" + line, price);
ex.SetCell("M" + line, outId.ToString());
outId++;
elementIter++;
}
subtypeIter++;
}
typeIter++;
}
ex.ChangeSheet(4);
ex.SetCell("A2", basePacketNumber);
ex.SetCell("B2", basePacketName);
ex.SetCell("C2", cityId);
ex.SetCell("D2", cityName);
return(Techlist.SaveAndClose(ref ex, "iptv_packet_ins"));
}
