private void ImportAction_Execute(object sender, SimpleActionExecuteEventArgs e)
{
fmCFJSaleDoc obj = e.CurrentObject as fmCFJSaleDoc;
if (obj == null)
{
return;
}
OpenFileDialog dialog = new OpenFileDialog();
if (dialog.ShowDialog() == DialogResult.OK)
{
// obj.Name = dialog.FileName;
ExcelStorage provider = new ExcelStorage(typeof(fmSaleRecord));
provider.ErrorManager.ErrorMode = ErrorMode.ThrowException;
provider.StartRow = 3;
provider.StartColumn = 1;
provider.FileName = dialog.FileName;
fmSaleRecord[] res = (fmSaleRecord[])provider.ExtractRecords();
using (IObjectSpace os = this.ObjectSpace.CreateNestedObjectSpace()) {
foreach (fmSaleRecord sr in res)
{
fmCFJSaleDocLine oper = os.CreateObject <fmCFJSaleDocLine>();
oper.SaleDoc = os.GetObject <fmCFJSaleDoc>(obj);
oper.SaleOperation = os.FindObject <fmCFJSaleOperation>(new BinaryOperator("Code", sr.OperCode));
oper.AVTInvoiceNumber = sr.AVTInvoiceNumber;
oper.AVTInvoiceDate = sr.AVTInvoiceDate;
oper.DocBaseNumber = sr.DocBaseNumber;
//if (sr.DocBaseDate != null)
oper.DocBaseDate = sr.DocBaseDate;
oper.PartyCode = sr.PartyCode;
if (sr.ContractNumber == null)
{
sr.ContractNumber = "";
}
if (sr.ContractNumber.Trim().ToUpper() == "Ã/Ï")
{
oper.DealNumber = "Ã/Ï";
}
else
{
oper.DealNumber = sr.ContractNumber;
}
//if (sr.ContractDate != null)
oper.DealDate = sr.ContractDate;
oper.OrderNumber = sr.OrderCode;
oper.SummAVT = Decimal.Round(sr.SummAVT, 2);
oper.SummCost = Decimal.Round(sr.SummAll, 2) - oper.SummAVT;
// oper.Valuta = os.FindObject<csValuta>(new BinaryOperator("Code", sr.Valuta));
// oper.SummValuta = sr.SummValuta;
oper.PayNumber = sr.PayNumber;
}
os.CommitChanges();
}
}
}
private void ApproveAction_Execute(object sender, SimpleActionExecuteEventArgs e)
{
fmCFJSaleDoc doc = e.CurrentObject as fmCFJSaleDoc;
if (doc == null)
{
return;
}
ObjectSpace.CommitChanges();
foreach (fmCFJSaleDocLine line in doc.DocLines)
{
using (IObjectSpace os = this.ObjectSpace.CreateNestedObjectSpace()) {
fmCFJSaleDocLine curline = os.GetObject <fmCFJSaleDocLine>(line);
curline.Approve();
os.CommitChanges();
}
ObjectSpace.CommitChanges();
}
}
/// <summary>
///
/// </summary>
/// <param name="os"></param>
/// <param name="doc"></param>
static public void ExportTo(IObjectSpace os, fmCFJSaleDoc doc)
{
foreach (fmCFJSaleDocLine line in doc.DocLines)
{
using (IObjectSpace nos = os.CreateNestedObjectSpace()) {
fmCFJSaleDocLine curline = os.GetObject <fmCFJSaleDocLine>(line);
if (curline.IsSyncIBS)
{
continue;
}
if (!curline.IsApproved)
{
continue;
}
if (curline.SaleJurnalLine == null)
{
continue;
}
curline.SaleJurnalLine.SyncIBS();
// User currentUser = null;
IIBSSyncService syncservice = new HTTPSyncService(ConfigurationManager.AppSettings["IBS.SyncService"]);
FWSJXMIA msg_in = new FWSJXMIA();
msg_in.CMD = "UPDATE";
msg_in.OPERATION = curline.SaleOperation.Code;
msg_in.SJOID = curline.SaleJurnalLine.Oid.ToString();
////
Decimal code;
if (!Decimal.TryParse(curline.PartyCode, out code))
{
return;
}
msg_in.VOCODE = code;
msg_in.ZKCODE = curline.OrderNumber;
msg_in.SFNUMBER = curline.AVTInvoiceNumber;
msg_in.SFDATE = curline.AVTInvoiceDate;
msg_in.DGNUMBER = curline.DealNumber;
msg_in.DGDATE = curline.DealDate;
msg_in.FINUMBER = curline.DocBaseNumber;
msg_in.FIDATE = curline.DocBaseDate;
//// !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
if (curline.SaleOperation.IsNotAVTInvoice)
{
msg_in.PLNUMBER = "СФЗ" + curline.PayNumber;
}
else
{
msg_in.PLNUMBER = "СЧФ";
}
////
msg_in.SUMMCOST = curline.SummCost;
msg_in.AVTRATE = curline.AVTRate.Code;
msg_in.SUMMAVT = curline.SummAVT;
msg_in.SUMMALL = curline.SummAll;
if (curline.Valuta == null)
{
msg_in.VACODE = "";
}
else
{
msg_in.VACODE = curline.Valuta.Code;
}
msg_in.SUMMVALALL = curline.SummValuta;
////
msg_in.UOGCODE = 1000;
msg_in.PERIOD = curline.SaleDoc.Period;
msg_in.DOCPROV = curline.DocBuhProv;
msg_in.DOCPCK = curline.DocBuhPck;
msg_in.DOCNUMBER = curline.DocBuhNumber;
msg_in.DOCDATE = curline.DocBuhDate;
msg_in.ACCSALEDEBET = curline.AccRealDebet.ToString();
msg_in.ACCSALECREDIT = curline.AccRealCredit.ToString();
msg_in.ACCAVTDEBET = curline.AccAVTDebet.ToString();
msg_in.ACCAVTCREDIT = curline.AccAVTCredit.ToString();
//// !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
msg_in.CNTUSER = SecuritySystem.CurrentUserName;
////
FWSJXMOA msg_out = syncservice.FWSJXM0N(msg_in);
curline.IsSyncIBS = true;
//
nos.CommitChanges();
}
os.CommitChanges();
}
}