public void NccPack()
{
Int32 year = 2016;
Int32 month = 2;
BillPackDb billPackDb = new BillPackDb();
var wb2 = new XLWorkbook(@"C:\temp\ЕИРЦ_Пачки\NCC_Out_num.xlsx");
int num = Convert.ToInt32(wb2.Worksheet(1).Row(1).Cell(1).Value) + 1;
wb2.Worksheet(1).Row(1).Cell(1).Value = num;
wb2.Save();
StreamWriter outPack = new StreamWriter(@"C:\Temp\ЕИРЦ_Пачки\ncc_out.txt", false, Encoding.GetEncoding("cp866"));
outPack.WriteLine("<smpay_load_hdr><format_id>smpay_load_data</format_id><format_version>1</format_version><file_id>" + num + "</file_id></smpay_load_hdr>");
List <string> prefs = new List <string>()
{
"bill01", "bill02"
};
DataTable dt = billPackDb.SelectSaldoForNCC(year, month, prefs);
for (int i = 0; i < dt.Rows.Count; i++)
{
const string uniqNumOrg = "00103198";
string id = uniqNumOrg + Convert.ToString(dt.Rows[i][0]).PadRight(20, ' ');
string address = Convert.ToString(dt.Rows[i][1]).PadRight(40, ' ');
decimal d = Math.Round(Convert.ToDecimal(dt.Rows[i][2]), 2);
int saldo = Convert.ToInt32(d * 100) > 0 ? Convert.ToInt32(d * 100) : 0;
outPack.WriteLine(id + address + saldo.ToString().PadLeft(12, '0'));
//outPack.WriteLine(id + address);
}
outPack.Close();
}
public void AvtovazbankPack()
{
BillPackDb billPackDb = new BillPackDb();
Int32 year = 2016;
Int32 month = 2;
StreamWriter outPack = new StreamWriter(@"C:\Temp\avtovazbank.csv", false, Encoding.UTF8);
List <string> prefs = new List <string>()
{
"bill01", "bill02"
};
DataTable dt = billPackDb.SelectSaldoForAvtovazbank2(year, month, prefs);
for (int i = 0; i < dt.Rows.Count; i++)
{
string id = Convert.ToString(dt.Rows[i][0]);
string address = Convert.ToString(dt.Rows[i][1]);
string fio = Convert.ToString(dt.Rows[i][3]);
string d = Math.Round(Convert.ToDecimal(dt.Rows[i][2]) > 0 ? Convert.ToDecimal(dt.Rows[i][2]) : 0, 2).ToString().Replace(',', '.');
outPack.WriteLine(id + ";" + address + ";" + fio + ";" + d);
}
outPack.Close();
}
public void SberbankPack()
{
BillPackDb billPackDb = new BillPackDb();
String fileName = "6321388192_40702810754400005587_001_y01";
StreamWriter outPack = new StreamWriter(@"C:\Temp\" + fileName + ".txt", false, Encoding.GetEncoding("windows-1251"));
string db = "192.168.1.25";
List <string> prefs = new List <string>()
{
"bill01", "bill02"
};
DataTable dt = billPackDb.SelectSaldoForSberbank(db, 2, 2016, prefs);
for (int i = 0; i < dt.Rows.Count; i++)
{
string num_ls = Convert.ToString(dt.Rows[i][0]).PadLeft(6, '0');
string fio = Convert.ToString(dt.Rows[i][1]);
string address = Convert.ToString(dt.Rows[i][2]);
string period = Convert.ToString(dt.Rows[i][3]);
string d = Math.Round(Convert.ToDecimal(dt.Rows[i][4]), 2) >= 0 ? Math.Round(Convert.ToDecimal(dt.Rows[i][4]), 2).ToString().Replace(',', '.') : "0";
outPack.WriteLine(num_ls + ";" + fio + ";" + address + ";" + period + ";" + d);
}
outPack.Close();
}
public void DymokPack()
{
BillPackDb billPackDb = new BillPackDb();
Int32 year = 2016;
Int32 month = 2;
StreamWriter outPack = new StreamWriter(@"C:\Temp\dymok.csv", false, Encoding.UTF8);
List <string> prefs = new List <string>()
{
"bill01", "bill02"
};
DataTable dt = billPackDb.SelectSaldoForAvtovazbank(year, month, prefs);
for (int i = 0; i < dt.Rows.Count; i++)
{
string eirc = Convert.ToString(dt.Rows[i][4]);
string id = Convert.ToString(dt.Rows[i][0]);
string address = Convert.ToString(dt.Rows[i][1]);
string d = Math.Round(Convert.ToDecimal(dt.Rows[i][2]) > 0 ? Convert.ToDecimal(dt.Rows[i][2]) : 0, 2).ToString().Replace(',', '.');
string fio = Convert.ToString(dt.Rows[i][3]);
string[] objsObj = fio.Split(new[] { " " }, StringSplitOptions.RemoveEmptyEntries);
fio = "";
foreach (string word in objsObj.ToList <string>())
{
if (fio != "")
{
fio = fio + word.Substring(0, 1) + ". ";
}
else
{
fio = word.Substring(0, 1) + ". ";
}
}
outPack.WriteLine(eirc + id + ";" + address + ";" + d + ";" + fio);
}
outPack.Close();
}
