private static void LoadPaymentsFromDbf(PayReester payReester, System.IO.FileInfo sourceFile)
{
string str = System.IO.Path.Combine(System.IO.Path.GetTempPath(), "PAY.DBF");
System.IO.FileInfo info = sourceFile.CopyTo(str, true);
System.Data.DataTable table = DALOdbc.ExecuteDataTable(DbfFormat.dBaseIV, info.get_DirectoryName(), "select * from " + info.get_Name());
info.Delete();
if (table.Rows.get_Count() > 0)
{
System.Data.DataTable insertData = new System.Data.DataTable();
insertData.Columns.Add("reesterId", System.Type.GetType("System.Int64"));
insertData.Columns.Add("apx", System.Type.GetType("System.String"));
insertData.Columns.Add("statusId", System.Type.GetType("System.Int64"));
foreach (System.Data.DataRow row in table.Rows)
{
System.Data.DataRow row2 = insertData.NewRow();
row2.set_Item("reesterId", (long) payReester.Id);
row2.set_Item("statusId", (int) payReester.StatusId);
System.Text.StringBuilder builder = new System.Text.StringBuilder();
foreach (System.Data.DataColumn column in table.Columns)
{
builder.Append(column.get_Caption());
builder.Append("=");
builder.Append(row.get_Item(column).ToString().Replace(";", "").Replace("=", ""));
builder.Append(';');
}
row2.set_Item("apx", builder.ToString());
insertData.Rows.Add(row2);
}
DALSql.BulkCopy("pay.ReesterRecords", insertData);
payReester.Prepare();
}
}
private static void LoadPaymentsFromFile(PayReester payReester, System.IO.FileInfo sourceFile, string encoding)
{
payReester.ReeTypeId = FasetItem.FindByName(FasetsEnum.PaymentsReestrType, "Наличные платежи").Id;
using (System.IO.StreamReader reader = new System.IO.StreamReader(sourceFile.get_FullName(), System.Text.Encoding.GetEncoding(string.IsNullOrEmpty(encoding) ? ((string) "CP866") : encoding)))
{
string str;
while ((str = reader.ReadLine()) != null)
{
str = str.Trim();
new PayReesterRecord { ReesterId = payReester.Id, StatusId = payReester.StatusId, Apx = str }.SaveChanges();
}
payReester.Prepare();
}
}
public static PayReester SaveCityReesterToDatabase(Reester248 fileRee, PayPaymentSystem paymentSystem, AIS.SN.Model.DomainObjects.Organization agent)
{
PayReester reester = new PayReester {
PaymentSystem = "Система \"Город\"",
PaymentSystemId = paymentSystem.Id,
Number = ((int) fileRee.Number).ToString()
};
FasetItem item = FasetItem.FindByName(FasetsEnum.PaymentsReestrType, Reester.GetTypeDescription(fileRee.ReeType));
reester.ReeTypeId = item.Id;
FasetItem item2 = FasetItem.FindByName(FasetsEnum.PaymentReestrStatus, "Загружен");
reester.StatusId = item2.Id;
reester.Created = fileRee.Created;
reester.FromDate = fileRee.FromDate;
reester.ToDate = fileRee.ToDate;
reester.Organization = ((int) fileRee.AgentId).ToString();
reester.OrganizationId = agent.Id;
reester.Summ = fileRee.ReeSumm;
reester.Records = fileRee.RecCount;
reester.PaymentService = ((int) fileRee.Service).ToString();
reester.SaveChanges();
foreach (Record record in fileRee.Records)
{
PayReesterRecord record2;
new PayReesterRecord { ReesterId = reester.Id, StatusId = reester.StatusId, AccountNumber = record.acc_pu, AbonentName = record.fio, Address = record.address, SubService = record.sub_srv_pu, PaymentSumm = record.summ, Period = record.dateb.get_HasValue() ? record.dateb.Value : record2.Period, Apx = record.apx, PaymentDate = record.created.get_HasValue() ? record.created.Value : record2.PaymentDate, ExternalTransactionId = record.uno.ToString() }.SaveChanges();
}
reester.Prepare();
return reester;
}