protected void ASPxGridView1_CustomDataCallback(object sender, ASPxGridViewCustomDataCallbackEventArgs e)
{
string filter = e.Parameters;
ASPxTextBox oidCtr = this.ASPxGridView1.FindEditFormTemplateControl("txt_Oid") as ASPxTextBox;
//ASPxTextBox docN = this.ASPxGridView1.FindEditFormTemplateControl("txt_DocNo") as ASPxTextBox;
if (filter == "P")
{
SaveBill();
#region Post
string sql = @"SELECT AcYear, AcPeriod, DocType, DocNo, DocDate, DocCurrency, DocExRate, PartyTo, OtherPartyName, DocAmt, LocAmt, AcCode, AcSource, ChqNo, ChqDate, ExportInd,
BankName, Remark,GenerateInd FROM pay_doc";
sql += " WHERE Id='" + oidCtr.Text + "'";
DataTable dt = Manager.ORManager.GetDataSet(sql).Tables[0];
int acYear = 0;
int acPeriod = 0;
string docN = "";
string docType = "";
string acSource = "";
string acCode = "";
decimal locAmt = 0;
decimal docAmt = 0;
decimal exRate = 0;
string currency = "";
DateTime docDt = DateTime.Today;
string remarks = "";
string partyTo = "";
string otherPartyName = "";
string chqNo = "";
string generateInd = "";
if (dt.Rows.Count == 1)
{
acYear = SafeValue.SafeInt(dt.Rows[0]["AcYear"], 0);
acPeriod = SafeValue.SafeInt(dt.Rows[0]["AcPeriod"], 0);
acSource = dt.Rows[0]["AcSource"].ToString();
acCode = dt.Rows[0]["AcCode"].ToString();
docN = dt.Rows[0]["DocNo"].ToString();
docType = dt.Rows[0]["DocType"].ToString();
locAmt = SafeValue.SafeDecimal(dt.Rows[0]["LocAmt"].ToString(), 0);
docAmt = SafeValue.SafeDecimal(dt.Rows[0]["DocAmt"].ToString(), 0);
exRate = SafeValue.SafeDecimal(dt.Rows[0]["DocExRate"].ToString(), 0);
currency = dt.Rows[0]["DocCurrency"].ToString();
docDt = SafeValue.SafeDate(dt.Rows[0]["DocDate"], new DateTime(1900, 1, 1));
// partyId = dt.Rows[0][""].ToString();
remarks = dt.Rows[0]["Remark"].ToString();
partyTo = dt.Rows[0]["PartyTo"].ToString();
otherPartyName = dt.Rows[0]["OtherPartyName"].ToString();
chqNo = dt.Rows[0]["ChqNo"].ToString();
generateInd = SafeValue.SafeString(dt.Rows[0]["GenerateInd"]);
}
else
{
e.Result = "Can't find the ArReceipt!";
return;
}
if (generateInd.ToUpper() != "Y")
{
e.Result = "Have not generate no!";
return;
}
string sqlDet = string.Format("select count(Id) from pay_line where RepId='{0}'", oidCtr.Text);
int detCnt = SafeValue.SafeInt(Manager.ORManager.ExecuteScalar(sqlDet), 0);
if (detCnt == 0)
{
e.Result = "No Detail, Can't Post";
return;
}
sqlDet = string.Format("select max(docDate) from pay_line where RepId='{0}'", oidCtr.Text);
DateTime maxLineDocDate = SafeValue.SafeDate(Manager.ORManager.ExecuteScalar(sqlDet), new DateTime(1900, 1, 1));
if (maxLineDocDate > new DateTime(2000, 1, 1) && maxLineDocDate > docDt)
{
e.Result = "The bill's Date can't be greater than receipt date.";
return;
}
//check account period
if (acYear < 1 || acPeriod < 1)
{
e.Result = "Account year or Period Invalid!";
return;
}
string sql1 = "select CloseInd from XXAccPeriod where Year='" + acYear + "' and Period ='" + acPeriod + "'";
string closeInd = SafeValue.SafeString(Manager.ORManager.ExecuteScalar(sql1), "");
if (closeInd == "")
{
e.Result = "Can't find this account period!";
return;
}
else if (closeInd == "Y")
{
e.Result = "The account period is closed!";
return;
}
//mast.amt det.amt is match
sql = string.Format("select sum(locamt) from pay_line where RepId='{0}' and AcSource='CR'", oidCtr.Text);
decimal amt_detCr = SafeValue.SafeDecimal(Manager.ORManager.ExecuteScalar(sql), 0);
sql = string.Format("select sum(locamt) from pay_line where RepId='{0}' and AcSource='DB'", oidCtr.Text);
decimal amt_detDb = SafeValue.SafeDecimal(Manager.ORManager.ExecuteScalar(sql), 0);
if (docType == "RE" && locAmt != amt_detCr - amt_detDb)
{
e.Result = "Amount can't match, can't post";
return;
}
else if (docType == "PC" && locAmt != -amt_detCr + amt_detDb)
{
e.Result = "Amount can't match, can't post";
return;
}
sql = "select count(*) from pay_line where AcCode='' and RepId='" + oidCtr.Text + "'";
detCnt = SafeValue.SafeInt(C2.Manager.ORManager.ExecuteScalar(sql), 0);
if (detCnt > 0)
{
e.Result = "Some Item's Accode is blank, pls check";
return;
}
//delete old post data
sql = string.Format("SELECT SequenceId from XAGlEntry WHERE DocNo='{0}' and DocType='{1}'", docN, docType);
int glOldOid = SafeValue.SafeInt(Manager.ORManager.ExecuteScalar(sql), 0);
if (glOldOid > 0)
{
DeleteGl(glOldOid);
}
//Insert into gl entry
int glOid = 0;
try
{
C2.XAGlEntry gl = new XAGlEntry();
gl.AcPeriod = acPeriod;
gl.AcYear = acYear;
gl.ArApInd = "AR";
gl.DocType = docType;
gl.DocDate = docDt;
gl.DocNo = docN;
gl.CrAmt = docAmt;
gl.DbAmt = docAmt;
gl.CurrencyCrAmt = locAmt;
gl.CurrencyDbAmt = locAmt;
gl.CurrencyId = currency;
gl.EntryDate = DateTime.Now;
gl.ExRate = exRate;
gl.PostDate = DateTime.Now;
gl.PostInd = "N";
gl.Remark = remarks;
gl.UserId = HttpContext.Current.User.Identity.Name;
gl.CancelInd = "N";
gl.CancelDate = new DateTime(1900, 1, 1);
gl.PartyTo = partyTo;
gl.OtherPartyName = otherPartyName;
gl.ChqNo = chqNo;
gl.SupplierBillNo = "";
gl.SupplierBillDate = new DateTime(1900, 1, 1);
Manager.ORManager.StartTracking(gl, InitialState.Inserted);
Manager.ORManager.PersistChanges(gl);
glOid = gl.SequenceId;
//insert Detail
OPathQuery query = new OPathQuery(typeof(pay_line), "RepId='" + oidCtr.Text + "'");
ObjectSet set = Manager.ORManager.GetObjectSet(query);
int index = 1;
XAGlEntryDet det1 = new XAGlEntryDet();
det1.AcCode = acCode;
det1.ArApInd = "AR";
det1.AcPeriod = acPeriod;
det1.AcSource = acSource;
det1.AcYear = acYear;
det1.CrAmt = 0;
det1.CurrencyCrAmt = 0;
det1.DbAmt = docAmt;
det1.CurrencyDbAmt = locAmt;
det1.CurrencyId = currency;
det1.DocNo = docN;
det1.DocType = docType;
det1.ExRate = exRate;
det1.GlLineNo = index;
det1.GlNo = gl.SequenceId;
det1.Remark = remarks;
Manager.ORManager.StartTracking(det1, InitialState.Inserted);
Manager.ORManager.PersistChanges(det1);
for (int i = 0; i < set.Count; i++)
{
try
{
index++;
pay_line invDet = set[i] as pay_line;
XAGlEntryDet det = new XAGlEntryDet();
det.AcCode = invDet.AcCode;
det.ArApInd = "AR";
det.AcPeriod = acPeriod;
det.AcSource = invDet.AcSource;
det.AcYear = acYear;
if (invDet.AcSource == "DB")
{
det.DbAmt = invDet.DocAmt;
det.CurrencyDbAmt = invDet.LocAmt;
det.CrAmt = 0;
det.CurrencyCrAmt = 0;
}
else// if (det.AcSource == "CR")
{
det.CrAmt = invDet.DocAmt;
det.CurrencyCrAmt = invDet.LocAmt;
det.DbAmt = 0;
det.CurrencyDbAmt = 0;
}
det.CurrencyId = invDet.Currency;
det.DocNo = docN;
det.DocType = docType;
det.ExRate = invDet.ExRate;
det.GlLineNo = index;
det.GlNo = gl.SequenceId;
det.Remark = invDet.Remark1;
Manager.ORManager.StartTracking(det, InitialState.Inserted);
Manager.ORManager.PersistChanges(det);
}
catch
{
e.Result = "Posting Error, Please repost!";
DeleteGl(glOid);
}
}
UpdateArInv(oidCtr.Text);
EzshipLog.Log(docN, "", docType, "Post");
e.Result = "Post completely!";
}
catch
{
e.Result = "Posting Error, Please repost!";
DeleteGl(glOid);
}
#endregion
}
else if (filter == "DD")
{
#region delete receipt
try
{
string sql = "SELECT Id,DocId, DocType FROM pay_line where RepId ='" + oidCtr.Text + "'";
DataTable tab = C2.Manager.ORManager.GetDataSet(sql).Tables[0];
for (int i = 0; i < tab.Rows.Count; i++)
{
try
{
string id = tab.Rows[i]["Id"].ToString();
string docId = tab.Rows[i]["DocId"].ToString();
string docType = tab.Rows[i]["DocType"].ToString();
string sql_det = "delete from pay_line where Id='" + id + "'";
if (C2.Manager.ORManager.ExecuteCommand(sql_det) > 0)
{
UpdateMaster(docId, docType);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
#endregion
}
else if (filter == "Reverse")
{
#region reverse receipt 0:period is closed? 1:unpost 2:exportind='N' 3: delete all item
try
{
string sql1 = string.Format("select CloseInd from xxaccperiod where Year=(select AcYear from pay_doc where Id='{0}') and Period=(select top(1)AcPeriod from pay_doc where SequenceId='{0}')", oidCtr.Text);
if (SafeValue.SafeString(ConnectSql.ExecuteScalar(sql1)) != "N")
{
throw new Exception("Acc Period is Closed!");
}
string sql_invoice = string.Format("select sequenceid from xaglentry where ArApInd='AR' and docno=(select docno from pay_doc where id='{0}') and DocType=(select doctype from pay_doc where id='{0}') ", oidCtr.Text);
DeleteGl(SafeValue.SafeInt(ConnectSql.ExecuteScalar(sql_invoice), 0));
sql_invoice = "update pay_doc set IsReturn='true', ExportInd='N' where Id='" + oidCtr.Text + "'";
Manager.ORManager.ExecuteCommand(sql_invoice);
string sql = "SELECT Id,DocId, DocType FROM pay_line where RepId ='" + oidCtr.Text + "'";
DataTable tab = C2.Manager.ORManager.GetDataSet(sql).Tables[0];
for (int i = 0; i < tab.Rows.Count; i++)
{
try
{
string id = tab.Rows[i]["Id"].ToString();
string docId = tab.Rows[i]["DocId"].ToString();
string docType = tab.Rows[i]["DocType"].ToString();
string sql_det = "delete from pay_line where Id='" + id + "'";
if (C2.Manager.ORManager.ExecuteCommand(sql_det) > 0)
{
UpdateMaster(docId, docType);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
#endregion
}
else if (filter == "GainLoss")
{
#region GAIN LOSS
ASPxComboBox docType = this.ASPxGridView1.FindEditFormTemplateControl("cbo_DocType") as ASPxComboBox;
string sql = string.Format("select (select LocAmt from pay_doc where Id='{0}')-iSNULL(sum(case when AcSource='CR' then -LocAmt else LocAmt end),0) As LocAmt from pay_line where repid='{0}'", oidCtr.Text);
if (docType.Text == "RE")
{
sql = string.Format("select (select LocAmt from pay_doc where Id='{0}')-iSNULL(sum(case when AcSource='DB' then -LocAmt else LocAmt end),0) As LocAmt from pay_line where repid='{0}'", oidCtr.Text);
}
decimal balAmt = SafeValue.SafeDecimal(C2.Manager.ORManager.ExecuteScalar(sql), 0);
if (balAmt > 0)
{
string gainAccCode = System.Configuration.ConfigurationManager.AppSettings["GainLoseAcCode"];
pay_line det = new pay_line();
det.AcCode = gainAccCode;
if (docType.Text == "RE")
{
det.AcSource = "CR";
}
else
{
det.AcSource = "DB";
}
det.DocType = docType.Text;
det.RepType = docType.Text;
det.Currency = System.Configuration.ConfigurationManager.AppSettings["Currency"];
det.DocAmt = balAmt;
det.DocDate = new DateTime(1900, 1, 1);
det.DocId = 0;
det.DocNo = "";
det.ExRate = 1;
det.LocAmt = balAmt;
det.Remark1 = "GAIN AND LOSS";
det.Remark2 = "";
det.Remark3 = "";
det.RepId = SafeValue.SafeInt(oidCtr.Text, 0);
ASPxTextBox docN = this.ASPxGridView1.FindEditFormTemplateControl("txt_DocNo") as ASPxTextBox;
det.RepNo = docN.Text;
string sql_detCnt = "select count(DocNo) from pay_line where RepId='" + oidCtr.Text + "'";
int lineNo = SafeValue.SafeInt(Manager.ORManager.ExecuteScalar(sql_detCnt), 0) + 1;
det.RepLineNo = lineNo;
C2.Manager.ORManager.StartTracking(det, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(det);
}
else if (balAmt < 0)
{
string gainAccCode = System.Configuration.ConfigurationManager.AppSettings["GainLoseAcCode"];
pay_line det = new pay_line();
det.AcCode = gainAccCode;
if (docType.Text == "RE")
{
det.AcSource = "DB";
}
else
{
det.AcSource = "CR";
}
det.DocType = docType.Text;
det.RepType = docType.Text;
det.Currency = System.Configuration.ConfigurationManager.AppSettings["Currency"];
det.DocAmt = -balAmt;
det.DocDate = new DateTime(1900, 1, 1);
det.DocId = 0;
det.DocNo = "";
det.ExRate = 1;
det.LocAmt = -balAmt;
det.Remark1 = "GAIN AND LOSS";
det.Remark2 = "";
det.Remark3 = "";
det.RepId = SafeValue.SafeInt(oidCtr.Text, 0);
ASPxTextBox docN = this.ASPxGridView1.FindEditFormTemplateControl("txt_DocNo") as ASPxTextBox;
det.RepNo = docN.Text;
string sql_detCnt = "select count(DocNo) from pay_line where RepId='" + oidCtr.Text + "'";
int lineNo = SafeValue.SafeInt(Manager.ORManager.ExecuteScalar(sql_detCnt), 0) + 1;
det.RepLineNo = lineNo;
C2.Manager.ORManager.StartTracking(det, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(det);
}
#endregion
}
else if (filter == "Generate")
{
string sql = @"SELECT DocType, DocDate FROM pay_doc WHERE Id='" + oidCtr.Text + "'";
DataTable dt = Manager.ORManager.GetDataSet(sql).Tables[0];
if (dt.Rows.Count == 1)
{
DateTime docDate = SafeValue.SafeDate(dt.Rows[0]["DocDate"], DateTime.Today);
string docType = SafeValue.SafeString(dt.Rows[0]["DocType"]);
string invN = C2Setup.GetNextNo(docType, "AR-RECEIPT", docDate);
sql = string.Format("Update pay_doc set DocNo='{1}',GenerateInd='Y' where Id='{0}'", oidCtr.Text, invN);
if (ConnectSql.ExecuteSql(sql) > -1)
{
C2Setup.SetNextNo(docType, "AR-RECEIPT", invN, docDate);
}
e.Result = invN;
}
}
}
protected void ASPxGridView1_CustomDataCallback(object sender, ASPxGridViewCustomDataCallbackEventArgs e)
{
string filter = e.Parameters;
string[] _filter = filter.Split(',');
string p = _filter[0];
ASPxTextBox oidCtr = this.ASPxGridView1.FindEditFormTemplateControl("txt_Oid") as ASPxTextBox;
ASPxTextBox docNoCtr = this.ASPxGridView1.FindEditFormTemplateControl("txt_DocNo") as ASPxTextBox;
ASPxComboBox docType1 = this.ASPxGridView1.FindEditFormTemplateControl("cbo_DocType1") as ASPxComboBox;
//get informations from arinvoice
if (p.ToUpper() == "P")
{
#region Post
if (docNoCtr.Text.Trim().Length < 6)
{
e.Result = "Please Generate No First !";
return;
}
string sql = @"SELECT AcYear, AcPeriod, DocType, DocNo, DocDate, CurrencyId, ExRate, PartyTo, OtherPartyName, DocAmt, LocAmt, AcCode, AcSource, ChqNo, ChqDate, CloseInd, ExportInd,
BankRec, BankDate, Remark FROM XAApPayment";
sql += " WHERE SequenceId='" + oidCtr.Text + "'";
DataTable dt = Helper.Sql.List(sql);
int acYear = 0;
int acPeriod = 0;
string docN = "";
string docType = "";
string acSource = "";
string acCode = "";
decimal locAmt = 0;
decimal docAmt = 0;
decimal exRate = 0;
string currency = "";
DateTime docDt = DateTime.Today;
string partyTo = "";
string otherPartyName = "";
string remarks = "";
string chqNo = "";
if (dt.Rows.Count == 1)
{
acYear = SafeValue.SafeInt(dt.Rows[0]["AcYear"], 0);
acPeriod = SafeValue.SafeInt(dt.Rows[0]["AcPeriod"], 0);
acSource = dt.Rows[0]["AcSource"].ToString();
acCode = dt.Rows[0]["AcCode"].ToString();
docN = dt.Rows[0]["DocNo"].ToString();
docType = dt.Rows[0]["DocType"].ToString();
locAmt = SafeValue.SafeDecimal(dt.Rows[0]["LocAmt"].ToString(), 0);
docAmt = SafeValue.SafeDecimal(dt.Rows[0]["DocAmt"].ToString(), 0);
exRate = SafeValue.SafeDecimal(dt.Rows[0]["ExRate"].ToString(), 0);
currency = dt.Rows[0]["CurrencyId"].ToString();
docDt = SafeValue.SafeDate(dt.Rows[0]["DocDate"], new DateTime(1900, 1, 1));
// partyId = dt.Rows[0][""].ToString();
remarks = dt.Rows[0]["Remark"].ToString();
partyTo = dt.Rows[0]["PartyTo"].ToString();
otherPartyName = dt.Rows[0]["OtherPartyName"].ToString();
chqNo = dt.Rows[0]["ChqNo"].ToString();
}
else
{
e.Result = "Can't find the Payment!";
return;
}
string sqlDet = string.Format("select count(SequenceId) from XAApPaymentDet where PayId='{0}'", oidCtr.Text);
int detCnt = SafeValue.SafeInt(Manager.ORManager.ExecuteScalar(sqlDet), 0);
if (detCnt == 0)
{
e.Result = "No Detail, Can't Post";
return;
}
sqlDet = string.Format("select max(docDate) from XAApPaymentDet where PayId='{0}'", oidCtr.Text);
DateTime maxLineDocDate = SafeValue.SafeDate(Manager.ORManager.ExecuteScalar(sqlDet), new DateTime(1900, 1, 1));
if (maxLineDocDate > new DateTime(2000, 1, 1) && maxLineDocDate > docDt)
{
e.Result = "The bill's Date can't be greater than payment date.";
return;
}
//check account period
if (acYear < 1 || acPeriod < 1)
{
e.Result = "Account year or Period Invalid!";
return;
}
string sql1 = "select CloseInd from XXAccPeriod where Year='" + acYear + "' and Period ='" + acPeriod + "'";
string closeInd = SafeValue.SafeString(Manager.ORManager.ExecuteScalar(sql1), "");
if (closeInd == "")
{
e.Result = "Can't find this account period!";
return;
}
else if (closeInd == "Y")
{
e.Result = "The account period is closed!";
return;
}
sql = string.Format("select sum(locamt) from XAApPaymentDet where (AcSource = 'DB') AND (PayId = '{0}')", oidCtr.Text);
decimal amt_detDb = SafeValue.SafeDecimal(Manager.ORManager.ExecuteScalar(sql), 0);
sql = string.Format("select sum(locamt) from XAApPaymentDet where(AcSource = 'CR') AND (PayId = '{0}')", oidCtr.Text);
decimal amt_detCr = SafeValue.SafeDecimal(Manager.ORManager.ExecuteScalar(sql), 0);
if (locAmt != amt_detDb - amt_detCr)
{
e.Result = "Amount can't match, can't post";
return;
}
sql = "select count(*) from XAApPaymentDet where AcCode='' and PayId='" + oidCtr.Text + "'";
detCnt = SafeValue.SafeInt(C2.Manager.ORManager.ExecuteScalar(sql), 0);
if (detCnt > 0)
{
e.Result = "Some Item's Accode is blank, pls check";
return;
}
//delete old post data
sql = string.Format("SELECT SequenceId from XAGlEntry WHERE DocNo='{0}' and DocType='{1}'", docN, docType);
int glOldOid = SafeValue.SafeInt(Manager.ORManager.ExecuteScalar(sql), 0);
if (glOldOid > 0)
{
DeleteGl(glOldOid);
}
//Insert into gl entry
int glOid = 0;
try
{
C2.XAGlEntry gl = new XAGlEntry();
gl.AcPeriod = acPeriod;
gl.AcYear = acYear;
gl.ArApInd = "AP";
gl.DocType = docType;
gl.DocDate = docDt;
gl.DocNo = docN;
gl.CrAmt = docAmt;
gl.CurrencyCrAmt = locAmt;
gl.DbAmt = docAmt;
gl.CurrencyDbAmt = locAmt;
gl.CurrencyId = currency;
gl.EntryDate = DateTime.Now;
gl.ExRate = exRate;
gl.PostDate = DateTime.Now;
gl.PostInd = "N";
gl.Remark = remarks;
gl.UserId = HttpContext.Current.User.Identity.Name;
gl.CancelInd = "N";
gl.CancelDate = new DateTime(1900, 1, 1);
gl.PartyTo = partyTo;
gl.OtherPartyName = otherPartyName;
gl.ChqNo = chqNo;
gl.SupplierBillNo = "";
gl.SupplierBillDate = new DateTime(1900, 1, 1);
Manager.ORManager.StartTracking(gl, InitialState.Inserted);
Manager.ORManager.PersistChanges(gl);
glOid = gl.SequenceId;
//insert Detail
OPathQuery query = new OPathQuery(typeof(XAApPaymentDet), "PayId='" + oidCtr.Text + "'");
ObjectSet set = Manager.ORManager.GetObjectSet(query);
int index = 1;
XAGlEntryDet det1 = new XAGlEntryDet();
det1.AcCode = acCode;
det1.ArApInd = "AP";
det1.AcPeriod = acPeriod;
det1.AcSource = acSource;
det1.AcYear = acYear;
det1.CrAmt = docAmt;
det1.CurrencyCrAmt = locAmt;
det1.DbAmt = 0;
det1.CurrencyDbAmt = 0;
det1.CurrencyId = currency;
det1.DocNo = docN;
det1.DocType = docType;
det1.ExRate = exRate;
det1.GlLineNo = index;
det1.GlNo = gl.SequenceId;
det1.Remark = remarks;
Manager.ORManager.StartTracking(det1, InitialState.Inserted);
Manager.ORManager.PersistChanges(det1);
for (int i = 0; i < set.Count; i++)
{
try
{
index++;
XAApPaymentDet invDet = set[i] as XAApPaymentDet;
XAGlEntryDet det = new XAGlEntryDet();
det.AcCode = invDet.AcCode;
det.ArApInd = "AP";
det.AcPeriod = acPeriod;
det.AcSource = invDet.AcSource;
det.AcYear = acYear;
if (invDet.AcSource == "DB")
{
det.CrAmt = 0;
det.CurrencyCrAmt = 0;
det.DbAmt = invDet.DocAmt;
det.CurrencyDbAmt = invDet.LocAmt;
}
else if (invDet.AcSource == "CR")
{
det.CrAmt = invDet.DocAmt;
det.CurrencyCrAmt = invDet.LocAmt;
det.DbAmt = 0;
det.CurrencyDbAmt = 0;
}
det.CurrencyId = invDet.Currency;
det.DocNo = docN;
det.DocType = docType;
det.ExRate = invDet.ExRate;
det.GlLineNo = index;
det.GlNo = gl.SequenceId;
det.Remark = invDet.Remark1;
Manager.ORManager.StartTracking(det, InitialState.Inserted);
Manager.ORManager.PersistChanges(det);
}
catch
{
e.Result = "Posting Error, Please repost!";
DeleteGl(glOid);
}
}
UpdateApPayment(oidCtr.Text);
e.Result = "Post completely!";
}
catch
{
e.Result = "Posting Error, Please repost!";
DeleteGl(glOid);
}
#endregion
}
else if (p == "DD")
{
#region delete detail
try
{
string sql = "SELECT SequenceId,DocId, DocType FROM XAApPaymentDet where PayId='" + oidCtr.Text + "'";
DataTable tab = Helper.Sql.List(sql);
for (int i = 0; i < tab.Rows.Count; i++)
{
try
{
string sequenceId = tab.Rows[i]["SequenceId"].ToString();
string docId = tab.Rows[i]["DocId"].ToString();
string docType = tab.Rows[i]["DocType"].ToString();
string sql_det = "delete from XAApPaymentDet where SequenceId='" + sequenceId + "'";
if (C2.Manager.ORManager.ExecuteCommand(sql_det) > 0)
{
UpdateMaster(docId, docType);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
#endregion
}
else if (filter == "GainLoss")
{
#region GAIN LOSS
string sql = string.Format("select sum(case when AcSource='DB' then -LocAmt else LocAmt end) As LocAmt from XAApPaymentDet where PayId='{0}'", oidCtr.Text);
decimal balAmt = SafeValue.SafeDecimal(C2.Manager.ORManager.ExecuteScalar(sql), 0);
string gainAccCode = System.Configuration.ConfigurationManager.AppSettings["GainLoseAcCode"];
if (balAmt > 0)
{
XAApPaymentDet det = new XAApPaymentDet();
det.AcCode = gainAccCode;
det.AcSource = "DB";
det.Currency = System.Configuration.ConfigurationManager.AppSettings["Currency"];
det.DocAmt = balAmt;
det.DocDate = new DateTime(1900, 1, 1);
det.DocId = 0;
det.DocNo = "";
det.DocType = "PS";
det.ExRate = 1;
det.LocAmt = balAmt;
det.Remark1 = "GAIN AND LOSS";
det.Remark2 = "";
det.Remark3 = "";
det.PayId = SafeValue.SafeInt(oidCtr.Text, 0);
ASPxTextBox docN = this.ASPxGridView1.FindEditFormTemplateControl("txt_DocNo") as ASPxTextBox;
det.PayNo = docN.Text;
string sql_detCnt = "select count(DocNo) from XAApPaymentDet where PayId='" + oidCtr.Text + "'";
int lineNo = SafeValue.SafeInt(Manager.ORManager.ExecuteScalar(sql_detCnt), 0) + 1;
det.PayLineNo = lineNo;
det.PayType = "PS";
C2.Manager.ORManager.StartTracking(det, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(det);
}
else if (balAmt < 0)
{
XAApPaymentDet det = new XAApPaymentDet();
det.AcCode = gainAccCode;
det.AcSource = "CR";
det.Currency = System.Configuration.ConfigurationManager.AppSettings["Currency"];
det.DocAmt = -balAmt;
det.DocDate = new DateTime(1900, 1, 1);
det.DocId = 0;
det.DocNo = "";
det.DocType = "PS";
det.ExRate = 1;
det.LocAmt = -balAmt;
det.Remark1 = "GAIN AND LOSS";
det.Remark2 = "";
det.Remark3 = "";
det.PayId = SafeValue.SafeInt(oidCtr.Text, 0);
ASPxTextBox docN = this.ASPxGridView1.FindEditFormTemplateControl("txt_DocNo") as ASPxTextBox;
det.PayNo = docN.Text;
string sql_detCnt = "select count(DocNo) from XAApPaymentDet where PayId='" + oidCtr.Text + "'";
int lineNo = SafeValue.SafeInt(Manager.ORManager.ExecuteScalar(sql_detCnt), 0) + 1;
det.PayLineNo = lineNo;
det.PayType = "PS";
C2.Manager.ORManager.StartTracking(det, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(det);
}
#endregion
}
else if (filter == "Generate")
{
string invN = C2Setup.GetNextNo("AP-PAYMENT-" + docType1.Text);
string sql = string.Format("Update XAApPayment set DocNo='{1}',GenerateInd='Y' where SequenceId='{0}'", oidCtr.Text, invN);
if (ConnectSql.ExecuteSql(sql) > -1)
{
C2Setup.SetNextNo("AP-PAYMENT-" + docType1.Text, invN);
}
e.Result = invN;
}
}
protected void ASPxGridView1_CustomCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e)
{
ASPxTextBox oidCtr = this.ASPxGridView1.FindEditFormTemplateControl("txt_Oid") as ASPxTextBox;
//ASPxTextBox docNo = this.ASPxGridView1.FindEditFormTemplateControl("txt_DocNo") as ASPxTextBox;
ASPxComboBox arApInd = this.ASPxGridView1.FindEditFormTemplateControl("cbo_ArAPInd") as ASPxComboBox;
ASPxComboBox docType = this.ASPxGridView1.FindEditFormTemplateControl("cbo_DocType") as ASPxComboBox;
//ASPxTextBox acYear = this.ASPxGridView1.FindEditFormTemplateControl("txt_AcYear") as ASPxTextBox;
//ASPxTextBox acPeriod = this.ASPxGridView1.FindEditFormTemplateControl("txt_AcPeriod") as ASPxTextBox;
ASPxTextBox docCurr = this.ASPxGridView1.FindEditFormTemplateControl("txt_Currency") as ASPxTextBox;
ASPxDateEdit docDate = this.ASPxGridView1.FindEditFormTemplateControl("txt_DocDt") as ASPxDateEdit;
ASPxSpinEdit exRate = this.ASPxGridView1.FindEditFormTemplateControl("txt_DocExRate") as ASPxSpinEdit;
ASPxMemo rmk = this.ASPxGridView1.FindEditFormTemplateControl("txt_Remark") as ASPxMemo;
C2.XAGlEntry inv = Manager.ORManager.GetObject(typeof(XAGlEntry), SafeValue.SafeInt(oidCtr.Text, 0)) as XAGlEntry;
bool isNew = false;
if (inv == null)// first insert invoice
{
inv = new XAGlEntry();
inv.ArApInd = arApInd.Text;
//inv.DocNo = C2Setup.GetNextNo("GLENTRY");
inv.DocNo = C2Setup.GetNextNo("", "GLENTRY", docDate.Date);
inv.DocType = docType.Text;
inv.CancelDate = new DateTime(1900, 1, 1);
inv.CancelInd = "N";
inv.CrAmt = 0;
inv.CurrencyCrAmt = 0;
inv.CurrencyDbAmt = 0;
inv.CurrencyId = docCurr.Text.ToString();
inv.ExRate = SafeValue.SafeDecimal(exRate.Value, 1);
if (inv.ExRate <= 0)
{
inv.ExRate = 1;
}
inv.DbAmt = 0;
inv.PostInd = "N";
inv.Remark = rmk.Text;
inv.UserId = HttpContext.Current.User.Identity.Name;
inv.PartyTo = "";
inv.OtherPartyName = "";
inv.DocDate = docDate.Date;
string[] currentPeriod = EzshipHelper.GetAccPeriod(docDate.Date);
inv.AcYear = SafeValue.SafeInt(currentPeriod[1], docDate.Date.Year);
inv.AcPeriod = SafeValue.SafeInt(currentPeriod[0], docDate.Date.Month);
try
{
inv.DocDate = DateTime.Now;
inv.PostDate = DateTime.Now;
inv.EntryDate = DateTime.Now;
C2.Manager.ORManager.StartTracking(inv, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(inv);
isNew = true;
C2Setup.SetNextNo("", "GLENTRY", inv.DocNo, inv.DocDate);
}
catch
{
}
}
else
{
//inv.ArApInd = arApInd.Text;
inv.CurrencyId = docCurr.Text.ToString();
inv.ExRate = SafeValue.SafeDecimal(exRate.Value, 1);
if (inv.ExRate <= 0)
{
inv.ExRate = 1;
}
inv.Remark = rmk.Text;
inv.DocDate = docDate.Date;
string[] currentPeriod = EzshipHelper.GetAccPeriod(docDate.Date);
inv.AcYear = SafeValue.SafeInt(currentPeriod[1], docDate.Date.Year);
inv.AcPeriod = SafeValue.SafeInt(currentPeriod[0], docDate.Date.Month);
try
{
Manager.ORManager.PersistChanges(inv);
Manager.ORManager.StartTracking(inv, InitialState.Updated);
string sql = string.Format("Update XAGlEntryDet set AcYear='{0}',AcPeriod='{1}' where GlNo='{2}'", inv.AcYear, inv.AcPeriod, inv.SequenceId);
Manager.ORManager.ExecuteCommand(sql);
}
catch
{
}
}
Session["GlEntryWhere"] = "SequenceId=" + inv.SequenceId;
this.dsGlEntry.FilterExpression = Session["GlEntryWhere"].ToString();
if (isNew)
{
C2Setup.SetNextNo("GLENTRY", inv.DocNo);
if (this.ASPxGridView1.GetRow(0) != null)
{
this.ASPxGridView1.StartEdit(0);
}
}
}
protected void ASPxGridView1_CustomDataCallback1(object sender, ASPxGridViewCustomDataCallbackEventArgs e)
{
string filter = e.Parameters;
string[] _filter = filter.Split(',');
string p = _filter[0];
#region Post
//get informations from arinvoice
ASPxTextBox oidCtr = this.ASPxGridView1.FindEditFormTemplateControl("txt_Oid") as ASPxTextBox;
if (p.ToUpper() == "P")
{
string sql = @"SELECT AcYear, AcPeriod, AcCode, AcSource, DocType, DocNo, DocDate, PartyTo, OtherPartyName, MastType, CurrencyId, ExRate, Term, Description, LocAmt,
DocAmt,ChqNo as SupplierBillNo, ChqDate as SupplierBillDate FROM XAApPayable";
sql += " WHERE SequenceId='" + oidCtr.Text + "'";
DataTable dt = Helper.Sql.List(sql);
int acYear = 0;
int acPeriod = 0;
string docN = "";
string docType = "";
string acSource = "";
string acCode = "";
decimal locAmt = 0;
decimal docAmt = 0;
decimal exRate = 0;
string currency = "";
DateTime docDt = DateTime.Today;
string remarks = "";
string partyTo = "";
string otherPartyName = "";
string supplierBillNo = "";
DateTime supplierBillDate = new DateTime(1900, 1, 1);
if (dt.Rows.Count == 1)
{
acYear = SafeValue.SafeInt(dt.Rows[0]["AcYear"], 0);
acPeriod = SafeValue.SafeInt(dt.Rows[0]["AcPeriod"], 0);
acSource = dt.Rows[0]["AcSource"].ToString();
acCode = dt.Rows[0]["AcCode"].ToString();
docN = dt.Rows[0]["DocNo"].ToString();
docType = dt.Rows[0]["DocType"].ToString();
locAmt = SafeValue.SafeDecimal(dt.Rows[0]["LocAmt"].ToString(), 0);
docAmt = SafeValue.SafeDecimal(dt.Rows[0]["DocAmt"].ToString(), 0);
exRate = SafeValue.SafeDecimal(dt.Rows[0]["ExRate"].ToString(), 0);
currency = dt.Rows[0]["CurrencyId"].ToString();
docDt = SafeValue.SafeDate(dt.Rows[0]["DocDate"], new DateTime(1900, 1, 1));
remarks = dt.Rows[0]["Description"].ToString();
partyTo = dt.Rows[0]["PartyTo"].ToString();
otherPartyName = SafeValue.SafeString(dt.Rows[0]["OtherPartyName"], "");
supplierBillNo = dt.Rows[0]["SupplierBillNo"].ToString();
supplierBillDate = SafeValue.SafeDate(dt.Rows[0]["SupplierBillDate"], new DateTime(1900, 1, 1));
}
else
{
e.Result = "Can't find the Voucher!";
return;
}
string sqlDet = string.Format("select count(SequenceId) from XAApPayableDet where DocId='{0}'", oidCtr.Text);
int detCnt = SafeValue.SafeInt(Manager.ORManager.ExecuteScalar(sqlDet), 0);
if (detCnt == 0)
{
e.Result = "No Detail, Can't Post";
return;
}
//check account period
if (acYear < 1 || acPeriod < 1)
{
e.Result = "Account year or Period Invalid!";
return;
}
string sql1 = "select CloseInd from XXAccPeriod where Year='" + acYear + "' and Period ='" + acPeriod + "'";
string closeInd = SafeValue.SafeString(Manager.ORManager.ExecuteScalar(sql1), "");
if (closeInd == "")
{
e.Result = "Can't find this account period!";
return;
}
else if (closeInd == "Y")
{
e.Result = "The account period is closed!";
return;
}
sql = "select SUM(LocAmt) from XAApPayableDet where AcSource='DB' and DocId='" + oidCtr.Text + "'";
decimal amt_det = SafeValue.SafeDecimal(C2.Manager.ORManager.ExecuteScalar(sql), 0);
sql = "select SUM(LocAmt) from XAApPayableDet where AcSource='CR' and DocId='" + oidCtr.Text + "'";
amt_det -= SafeValue.SafeDecimal(C2.Manager.ORManager.ExecuteScalar(sql), 0);
if (docAmt != amt_det)
{
e.Result = "Loc Amount can't match, can't post,Please first resave it,";
return;
}
sql = "select count(LocAmt) from XAApPayableDet where AcCode='' and DocId='" + oidCtr.Text + "'";
detCnt = SafeValue.SafeInt(C2.Manager.ORManager.ExecuteScalar(sql), 0);
if (detCnt > 0)
{
e.Result = "Some Item's Accode is blank, pls check";
return;
}
//delete old post data
sql = string.Format("SELECT SequenceId from XAGlEntry WHERE DocNo='{0}' and DocType='{1}'", docN, docType);
int glOldOid = SafeValue.SafeInt(Manager.ORManager.ExecuteScalar(sql), 0);
if (glOldOid > 0)
{
DeleteGl(glOldOid);
}
//Insert into gl entry
int glOid = 0;
try
{
C2.XAGlEntry gl = new XAGlEntry();
gl.AcPeriod = acPeriod;
gl.AcYear = acYear;
gl.ArApInd = "AP";
gl.DocType = docType;
gl.DocDate = docDt;
gl.DocNo = docN;
gl.CrAmt = docAmt;
gl.DbAmt = docAmt;
gl.CurrencyCrAmt = locAmt;
gl.CurrencyDbAmt = locAmt;
gl.CurrencyId = currency;
gl.EntryDate = DateTime.Now;
gl.ExRate = exRate;
gl.PostDate = DateTime.Now;
gl.PostInd = "N";
gl.Remark = remarks;
gl.UserId = HttpContext.Current.User.Identity.Name;
gl.CancelInd = "N";
gl.CancelDate = new DateTime(1900, 1, 1);
gl.PartyTo = partyTo;
gl.OtherPartyName = otherPartyName;
gl.ChqNo = supplierBillNo;
gl.ChqDate = supplierBillDate;
gl.SupplierBillNo = "";
gl.SupplierBillDate = new DateTime(1900, 1, 1);
Manager.ORManager.StartTracking(gl, InitialState.Inserted);
Manager.ORManager.PersistChanges(gl);
glOid = gl.SequenceId;
//insert Detail
OPathQuery query = new OPathQuery(typeof(XAApPayableDet), "DocId='" + oidCtr.Text + "'");
ObjectSet set = Manager.ORManager.GetObjectSet(query);
int index = 1;
XAGlEntryDet det1 = new XAGlEntryDet();
det1.AcCode = acCode;
det1.ArApInd = "AP";
det1.AcPeriod = acPeriod;
det1.AcSource = acSource;
det1.AcYear = acYear;
det1.CrAmt = docAmt;
det1.CurrencyCrAmt = locAmt;
det1.DbAmt = 0;
det1.CurrencyDbAmt = 0;
det1.CurrencyId = currency;
det1.DocNo = docN;
det1.DocType = docType;
det1.ExRate = exRate;
det1.GlLineNo = index;
det1.GlNo = gl.SequenceId;
det1.Remark = remarks;
Manager.ORManager.StartTracking(det1, InitialState.Inserted);
Manager.ORManager.PersistChanges(det1);
decimal gstCrAmt = 0;
decimal gstDbAmt = 0;
string gstAcc = SafeValue.SafeString(Manager.ORManager.ExecuteScalar("SELECT AcCode FROM XXGstAccount where GstSrc='AP'"), "4053");
for (int i = 0; i < set.Count; i++)
{
try
{
index++;
XAApPayableDet invDet = set[i] as XAApPayableDet;
XAGlEntryDet det = new XAGlEntryDet();
if (invDet.AcCode == gstAcc)
{
if (invDet.AcSource == "DB")
{
gstDbAmt += invDet.LocAmt;
}
else
{
gstCrAmt += invDet.LocAmt;
}
}
else
{
det.AcCode = invDet.AcCode;
det.ArApInd = "AP";
det.AcPeriod = acPeriod;
det.AcSource = invDet.AcSource;
det.AcYear = acYear;
if (invDet.AcSource == "DB")
{
det.CrAmt = 0;
det.CurrencyCrAmt = 0;
det.DbAmt = SafeValue.ChinaRound(SafeValue.ChinaRound(invDet.Qty * invDet.Price, 2) * invDet.ExRate, 2);
det.CurrencyDbAmt = SafeValue.ChinaRound(det.DbAmt * exRate, 2);
gstDbAmt += invDet.GstAmt;
}
else
{
det.DbAmt = 0;
det.CurrencyDbAmt = 0;
det.CrAmt = SafeValue.ChinaRound(SafeValue.ChinaRound(invDet.Qty * invDet.Price, 2) * invDet.ExRate, 2);
det.CurrencyCrAmt = SafeValue.ChinaRound(det.CrAmt * exRate, 2);
gstCrAmt += invDet.GstAmt;
}
det.CurrencyId = invDet.Currency;
det.DocNo = docN;
det.DocType = docType;
det.ExRate = invDet.ExRate;
det.GlLineNo = index;
det.GlNo = gl.SequenceId;
det.Remark = invDet.ChgCode;
Manager.ORManager.StartTracking(det, InitialState.Inserted);
Manager.ORManager.PersistChanges(det);
}
}
catch
{
e.Result = "Posting Error, Please repost!";
DeleteGl(glOid);
}
}
if (gstDbAmt - gstCrAmt != 0)
{
XAGlEntryDet det = new XAGlEntryDet();
det.AcCode = gstAcc;
det.ArApInd = "AP";
det.AcPeriod = acPeriod;
det.AcSource = "DB";
det.AcYear = acYear;
det.DbAmt = gstDbAmt - gstCrAmt;
det.CurrencyDbAmt = gstDbAmt - gstCrAmt;
det.CrAmt = 0;
det.CurrencyCrAmt = 0;
det.CurrencyId = System.Configuration.ConfigurationManager.AppSettings["Currency"];
det.DocNo = docN;
det.DocType = docType;
det.ExRate = 1;
det.GlLineNo = index + 1;
det.GlNo = gl.SequenceId;
det.Remark = "GST";
Manager.ORManager.StartTracking(det, InitialState.Inserted);
Manager.ORManager.PersistChanges(det);
}
UpdateArInv(oidCtr.Text);
e.Result = "Post completely!";
}
catch
{
e.Result = "Posting Error, Please repost!";
DeleteGl(glOid);
}
}
else if (p == "V")
{
string sql = string.Format(@"SELECT count(*) FROM XAApPaymentDet WHERE (DocId = '{0}')", oidCtr.Text);
int cnt = SafeValue.SafeInt(Manager.ORManager.ExecuteScalar(sql), 0);
if (cnt > 0)
{
e.Result = "Have Pay this bill, can't void it.";
return;
}
else
{
sql = string.Format("update XAApPayable set CancelInd='Y',Description=Description+' Void by {1}' where Sequenceid='{0}'", oidCtr.Text, HttpContext.Current.User.Identity.Name);
int res = Manager.ORManager.ExecuteCommand(sql);
if (res > 0)
{
e.Result = "Success";
}
else
{
e.Result = "Fail";
}
}
}
#endregion
}
private static void UpdateAcReturnEarning_1(int year)
{
// create a new gl year=new year, period=1,
//actype=p,
return;
string currency = System.Configuration.ConfigurationManager.AppSettings["Currency"];
C2.XAGlEntry inv = new XAGlEntry();
string sql1 = string.Format("select GlNo from XXAccPeriod where Year='{0}' and Period='1'", year + 1);
string oldGlNo = SafeValue.SafeString(Manager.ORManager.ExecuteScalar(sql1));
if (oldGlNo.Length > 0)
{
OPathQuery query = new OPathQuery(typeof(XAGlEntry), string.Format("DocNo = '{0}' AND DocType = 'GE'", oldGlNo));
inv = Manager.ORManager.GetObject(query) as XAGlEntry;
}
else
{
inv.ArApInd = "GL";
inv.DocNo = C2Setup.GetNextNo("GLENTRY");
inv.DocType = "GE";
inv.CancelDate = new DateTime(1900, 1, 1);
inv.CancelInd = "N";
inv.CrAmt = 0;
inv.CurrencyCrAmt = 0;
inv.CurrencyDbAmt = 0;
inv.CurrencyId = currency;
inv.ExRate = 1;
inv.DbAmt = 0;
inv.PostInd = "N";
inv.Remark = "";
inv.UserId = HttpContext.Current.User.Identity.Name;
inv.PartyTo = "";
inv.OtherPartyName = "";
inv.DocDate = new DateTime(year + 1, SafeValue.SafeInt(System.Configuration.ConfigurationManager.AppSettings["AccountFirstMonth"], 1), 1);
inv.AcYear = year + 1;
inv.AcPeriod = 1;
try
{
inv.PostDate = DateTime.Now;
inv.EntryDate = DateTime.Now;
C2.Manager.ORManager.StartTracking(inv, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(inv);
C2Setup.SetNextNo("GLENTRY", inv.DocNo);
}
catch(Exception ex)
{ throw new Exception(ex.Message + ex.StackTrace); }
}
//throw new Exception(inv.DocNo);
string sql = string.Format(@"SELECT ac.Code,ac.AcDorc,ac.AcType, ac.AcSubType, sta.OpenBal, sta.CurrBal, sta.CloseBal
FROM XXChartAcc AS ac INNER JOIN XXAccStatus AS sta ON ac.Code = sta.AcCode
WHERE ((ac.AcType = 'P') or ac.AcType='R') AND (sta.Year = '{0}') AND (sta.AcPeriod = '1') and sta.OpenBal<>0", year + 1);
decimal amt = 0;
DataTable tab = Helper.Sql.List(sql);
string code = C2.Manager.ORManager.ExecuteScalar("SELECT Code FROM XXChartAcc WHERE (AcType = 'R')").ToString();
int index = 0;
for (int i = 0; i < tab.Rows.Count; i++)
{
DataRow row = tab.Rows[i];
string subType = row["AcSubType"].ToString();
decimal closeBal = SafeValue.SafeDecimal(row["OpenBal"], 0);
if (row["AcType"].ToString() == "R")
{
//amt += closeBal;
continue;
}
else
{
if (subType == "S")
{
amt += closeBal;
}
else
{
amt -= closeBal;
}
}
string dbCrInd = row["AcDorc"].ToString();
decimal lineAmt = SafeValue.SafeDecimal(row["OpenBal"], 0);
if (dbCrInd == "DB")
{
dbCrInd = "CR";
}
else if (dbCrInd == "CR")
{
dbCrInd = "DB";
}
else
continue;
index++;
C2.XAGlEntryDet invDet = new XAGlEntryDet();
invDet.AcCode = row["Code"].ToString();
invDet.AcPeriod = 1;
invDet.AcSource = dbCrInd;
invDet.AcYear = year + 1;
invDet.ArApInd = inv.ArApInd;
invDet.CrAmt = 0;
invDet.CurrencyCrAmt = 0;
invDet.CurrencyDbAmt = 0;
invDet.DbAmt = 0;
if (invDet.AcSource == "DB")
{
invDet.CurrencyDbAmt = lineAmt;
invDet.DbAmt = lineAmt;
}
else
{
invDet.CrAmt = lineAmt;
invDet.CurrencyCrAmt = lineAmt;
}
invDet.DocNo = inv.DocNo;
invDet.DocType = inv.DocType;
invDet.CurrencyId = currency;
invDet.ExRate = 1;
invDet.GlLineNo = index;
invDet.GlNo = inv.SequenceId;
invDet.Remark = "";
C2.Manager.ORManager.StartTracking(invDet, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(invDet);
}
C2.XAGlEntryDet invDet_r = new XAGlEntryDet();
invDet_r.AcCode = code;
invDet_r.AcPeriod = 1;
invDet_r.AcSource = "CR";
invDet_r.AcYear = year + 1;
invDet_r.ArApInd = "GE";
invDet_r.CrAmt = amt;
invDet_r.CurrencyCrAmt = amt;
invDet_r.DbAmt = 0;
invDet_r.CurrencyDbAmt = 0;
invDet_r.CurrencyId = currency;
invDet_r.DocNo = inv.DocNo;
invDet_r.DocType = inv.DocType;
invDet_r.ExRate = 1;
invDet_r.GlLineNo =index + 1;
invDet_r.GlNo = inv.SequenceId;
invDet_r.Remark = "";
C2.Manager.ORManager.StartTracking(invDet_r, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(invDet_r);
sql = string.Format("Update XXAccPeriod Set GlNo='{1}' where Year='{0}' and Period='1'", year + 1, inv.DocNo);
C2.Manager.ORManager.ExecuteCommand(sql);
}
