public static DataSet GetINVOICEDETAIL_ENTRYByListInvoiceID(PUBDOCUMENT doc, string ListinvoiceID, string ListNewInvoiceID, string ObjectID, string MoneyAccount, bool IsPayment, bool IsNew, Int16 Cur_AutoID)
{
DataSet ds = new DataSet();
SqlHelper.ExecuteDataset(ds, "spGetINVOICEDETAIL_ENTRYByListInvoiceID",
doc.DOC_DOCUMENTID
, doc.ORG_AUTOID
, doc.DOC_OFSUBSYSTEM
, doc.DOC_DOCUMENTNO
, doc.DOC_REFDOCUMENTNO
, doc.DOC_DOCUMENTDATE
, doc.DOC_DESCRIPTION
, doc.DOC_CREATEBY
, doc.DOC_CREATEDATE
, doc.DOC_APPROVEBY
, doc.DOC_APPROVEDATE
, doc.DOC_DELETEBY
, doc.DOC_DELETEDATE
, doc.DOC_LEVEL
, doc.DOC_PATH
, doc.DOC_ISACTIVE
, doc.DOC_LASTUPDATE
, doc.DOC_UPDATEBY
, doc.DOC_OFSYSTEM
, doc.DOC_INSTANTID
, ListinvoiceID
, ListNewInvoiceID
, ObjectID
, MoneyAccount
, IsPayment
, IsNew
, Cur_AutoID);
if (ds != null)
{
if (ds.Tables.Count > 0)
{
return(ds);
}
}
return(null);;
}
private void codeMakeInvoice_ExecuteCode(object sender, EventArgs e)
{
PUBDOCUMENT PUBDOCUMENT = (PUBDOCUMENT)ObjParent;
if (PUBDOCUMENT != null && PUBDOCUMENT.DOC_DOCUMENTID > 0)
{
PUBDOCUMENT.DOC_ISACTIVE = true;
PUBDOCUMENT.DOC_DOCUMENTDATE = DateTime.Now;
PUBDOCUMENT.DOC_LASTUPDATE = DateTime.Now;
PUBDOCUMENT.DOC_DOCUMENTNO = DOCUMENTCONFIGIDDAO.getVoucher((short)eziposModule.IV);
long DOCID = PUBDOCUMENTDAO.Insert(PUBDOCUMENT, true);
if (DOCID > 0)
{
INVOICE newInvoice = new INVOICE();
newInvoice.OBJ_AUTOID = PUBDOCUMENT.DOC_CREATEBY;
newInvoice.CUR_AUTOID = CurID;
newInvoice.IV_DOCUMENTNUM = PUBDOCUMENT.DOC_DOCUMENTNO;
newInvoice.IV_DOCUMENTID = DOCID;
newInvoice.ST_AUTOID = (short)Status.Draft;
if (DocType == DOCOFTYPE.AP || DocType == DOCOFTYPE.Payment)
{
newInvoice.DOTY_AUTOID = (short)DOCOFTYPE.Buy;
}
else if (DocType == DOCOFTYPE.AR || DocType == DOCOFTYPE.Receive)
{
newInvoice.DOTY_AUTOID = (short)DOCOFTYPE.Sale;
}
// newInvoice.DOTY_AUTOID =
if (INVOICEDAO.InserttoTemp(newInvoice))
{
DOCUMENTRELATION rltdoc = new DOCUMENTRELATION();
rltdoc.DJ_DOPARENTID = PUBDOCUMENT.DOC_DOCUMENTID;
rltdoc.DJ_DOCUMENTID = DOCID;
if (DOCUMENTRELATIONDAO.Insert(rltdoc, true))
{
if (ListIDDetail.TrimEnd(';').Length > 0)
{
DataSet ds = null;
if (DocType == DOCOFTYPE.AP || DocType == DOCOFTYPE.Payment)
//if (rdoPayment.Checked | rdoAP.Checked)
{
ds = PUBPROPOSEPAYDAO.GetDetailPOSO(ListIDDetail.TrimEnd(';'), true);
if (ds != null && ds.Tables.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
try
{
INVOICEDETAIL ivd = new INVOICEDETAIL();
ivd.IV_DOCUMENTID = DOCID;
ivd.ITT_AUTOID = clsFormat.Int16Convert(dr[SALDETAIL.COLUMN_ITT_AUTOID]);
ivd.PIT_AUTOID = clsFormat.IntConvert(dr[SALDETAIL.COLUMN_PIT_AUTOID]);
//ivd.PIT_ITEMNO = clsFormat.StringConvert(dr[SALDETAIL.COLUMN_SALD_ITEMNO]);
//ivd.PIT_ITEMNAME = clsFormat.StringConvert(dr[SALDETAIL.COLUMN_SALD_ITEMNAME]);
ivd.IVD_QUANTITYREAL = clsFormat.DecimalConvert(dr[SALDETAIL.COLUMN_SALD_QUANTITY]);
//ivd.IVD_UOM = clsFormat.Int16Convert(dr[SALDETAIL.COLUMN_SALD_UOM]);
ivd.IVD_UNITPRICE = clsFormat.DecimalConvert(dr[SALDETAIL.COLUMN_SALD_UNITPRICE]);
ivd.IVD_TOTALAMOUNT = clsFormat.DecimalConvert(dr[SALDETAIL.COLUMN_SALD_TOTALAMOUNT]);
//ivd.IVD_PERCENTTAX = clsFormat.DecimalConvert(dr[SALDETAIL.COLUMN_SALD_TAXPERCENT]);
ivd.IVD_REDUCEPER = clsFormat.DecimalConvert(dr[SALDETAIL.COLUMN_SALD_PERREDUCE]);
//ivd.IVD_REDUCEMONEY = clsFormat.DecimalConvert(dr[SALDETAIL.]);
ivd.COT_AUTOID = clsFormat.IntConvert(dr[SALDETAIL.COLUMN_COT_AUTOID]);
//ivd.IVD_SOPO = clsFormat.Int64Convert(dr[SALDETAIL.COLUMN_SO_DOCUMENTID]);
// ivd.ITET_AUTOID = clsFormat.Int16Convert(getValueNodeAt(xml, INVOICEDETAIL.COLUMN_ITET_AUTOID));
//ivd.IVD_ISACTIVE = true;
INVOICEDETAILDAO.InserttoTemp(ivd);
}
catch (Exception ex)
{
continue;
}
}
}
}
else if (DocType == DOCOFTYPE.AR || DocType == DOCOFTYPE.Receive)
//else if (rdoAR.Checked | rdoReceive.Checked)
{
ds = PUBPROPOSEPAYDAO.GetDetailPOSO(ListIDDetail.TrimEnd(';'), false);
if (ds != null && ds.Tables.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
try
{
INVOICEDETAIL ivd = new INVOICEDETAIL();
ivd.IV_DOCUMENTID = DOCID;
ivd.PIT_AUTOID = clsFormat.IntConvert(dr[PURORDERDETAIL.COLUMN_PIT_AUTOID]);
ivd.PIT_ITEMNO = clsFormat.StringConvert(dr[PURORDERDETAIL.COLUMN_PIT_ITEMNO]);
ivd.PIT_ITEMNAME = clsFormat.StringConvert(dr[PURORDERDETAIL.COLUMN_PIT_ITEMNAME]);
//ivd.IVD_UOM = clsFormat.Int16Convert(dr[PURORDERDETAIL.COLUMN_POD_IVUOM]);
ivd.IVD_UNITPRICE = clsFormat.DecimalConvert(dr[PURORDERDETAIL.COLUMN_POD_UNITPRICE]);
ivd.IVD_TOTALAMOUNT = clsFormat.DecimalConvert(dr[PURORDERDETAIL.COLUMN_POD_TOTALAMOUNT]);
//ivd.IVD_PERCENTTAX = clsFormat.DecimalConvert(dr[PURORDERDETAIL.COLUMN_POD_TAXPERCENT]);
ivd.IVD_REDUCEPER = clsFormat.DecimalConvert(dr[PURORDERDETAIL.COLUMN_POD_PERREDUCE]);
//ivd.IVD_REDUCEMONEY = clsFormat.DecimalConvert(dr[PURORDERDETAIL.COLUMN_POD_REDUCEAMOUNT]);
ivd.COT_AUTOID = clsFormat.IntConvert(dr[PURORDERDETAIL.COLUMN_COT_AUTOID]);
//ivd.IVD_SOPO = clsFormat.Int64Convert(dr[PURORDERDETAIL.COLUMN_PURO_DOCUMENTID]);
// ivd.ITET_AUTOID = clsFormat.Int16Convert(getValueNodeAt(xml, INVOICEDETAIL.COLUMN_ITET_AUTOID));
//ivd.IVD_ISACTIVE = true;
INVOICEDETAILDAO.InserttoTemp(ivd);
}
catch (Exception ex)
{
continue;
}
}
}
}
}
if (INVOICEDAO.insertIVtoReal(newInvoice.IV_DOCUMENTID))
{
_IDResult = DOCID;
}
}
}
}
}
}
