public string CreateGlCard(string FIRMA_KODU, string ophCode, string description)
{
UnityObjects.IData itemCodeObj = default(UnityObjects.IData);
UnityObjects.Query UnityQuery = default(UnityObjects.Query);
if (_GLOBAL_PARAMETERS.Global.UnityApp.Connected)
{
string[] OCODE = ophCode.Split('.');
if (OCODE[3].Length != 4)
{
OCODE[3] = OCODE[3].ToString().Substring(0, 4).ToString();
}
ophCode = OCODE[0] + "." + OCODE[1] + "." + OCODE[2] + "." + OCODE[3];
UnityQuery = _GLOBAL_PARAMETERS.Global.UnityApp.NewQuery();
string CARI_KONTROL = string.Empty;
UnityQuery.Statement = "Select CODE From LG_" + FIRMA_KODU + "_EMUHACC where CODE='" + ophCode + "'";
if (UnityQuery.OpenDirect())
{
if (UnityQuery.First())
{
return(ophCode);
}
else
{
itemCodeObj = _GLOBAL_PARAMETERS.Global.UnityApp.NewDataObject(UnityObjects.DataObjectType.doGLAccount);
itemCodeObj.New();
itemCodeObj.DataFields.FieldByName("CODE").Value = ophCode;
itemCodeObj.DataFields.FieldByName("DESCRIPTION").Value = description;
itemCodeObj.DataFields.FieldByName("ACCOUNT_TYPE").Value = 2;
itemCodeObj.DataFields.FieldByName("DATA_REFERENCE").Value = "~";
ValidateErrors err = itemCodeObj.ValidateErrors;
if (itemCodeObj.Post())
{
return(ophCode);
}
else
{
for (int i = 0; i < err.Count; i++)
{
ophCode = err[i].Error + "," + err[i].ID;
}
}
}
}
}
return(ophCode);
}
private void BTN_LOGO_SECILENLERI_AKATAR_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
UnityObjects.IData arpVoucher = default(UnityObjects.IData);
UnityObjects.IData invObj = default(UnityObjects.IData);
UnityObjects.Lines arpVoucherLines = default(UnityObjects.Lines);
UnityObjects.Lines arpPaymentLines = default(UnityObjects.Lines);
UnityObjects.Query UnityQuery = default(UnityObjects.Query);
int i, m, k, cnt;
int groupedRowCount = 0;
int sign = 0;
DateTime ficheDate;
DateTime tempdate;
for (int j = 0; j <= workTable.Rows.Count - 1; j++)
{
if ((bool)workTable.Rows[j]["DECPRDIFF"] == true)
{
arpVoucher = _GLOBAL_PARAMETERS.Global.UnityApp.NewDataObject(UnityObjects.DataObjectType.doARAPVoucher);
arpVoucher.New();
arpVoucher.DataFields.FieldByName("NUMBER").Value = "~"; //workTable.Rows[j]["DOCODE"].ToString(); logo numara çakışmasından dolayı bu alanı düzelttik
ficheDate = (DateTime)workTable.Rows[j]["DATE_"];
arpVoucher.DataFields.FieldByName("DATE").Value = ficheDate;
arpVoucher.DataFields.FieldByName("TYPE").Value = 5;
arpVoucher.DataFields.FieldByName("CURRSEL_TOTALS").Value = 1;
arpVoucher.DataFields.FieldByName("CURRSEL_DETAILS").Value = 1;
arpVoucher.DataFields.FieldByName("DATE_CREATED").Value = DateTime.Now.ToShortDateString();
arpVoucher.DataFields.FieldByName("NOTES1").Value = workTable.Rows[j]["DOCODE"].ToString();//= "FT-" + workTable.Rows[j]["DOCODE"].ToString() + " " + workTable.Rows[j]["NOTES1"].ToString();
arpVoucher.DataFields.FieldByName("DATA_REFERENCE").Value = "~";
arpVoucherLines = arpVoucher.DataFields.FieldByName("TRANSACTIONS").Lines;
///''''VİRMAN FİŞİ SATIR 1'''''''''''''''''''''''''''''''''''''''
///
if (arpVoucherLines.AppendLine())
{
arpVoucherLines[0].FieldByName("ARP_CODE").Value = btn_CARI_II.EditValue;
arpVoucherLines[0].FieldByName("GL_CODE1").Value = GL_CODE_II;//clientAcc_2;
arpVoucherLines[0].FieldByName("CURR_TRANS").Value = 0;
arpVoucherLines[0].FieldByName("CURRSEL_TRANS").Value = 1;
arpVoucherLines[0].FieldByName("TC_XRATE").Value = 1;
arpVoucherLines[0].FieldByName("TC_AMOUNT").Value = Convert.ToDouble(workTable.Rows[j]["TOTAL"].ToString());
arpVoucherLines[0].FieldByName("DESCRIPTION").Value = "FT-" + workTable.Rows[j]["DOCODE"].ToString() + " " + workTable.Rows[j]["NOTES1"].ToString();
arpVoucherLines[0].FieldByName("DATA_REFERENCE").Value = "~";
switch (workTable.Rows[j]["TYPE"].ToString())
{
case "6":
case "7":
case "8":
case "9":
case "10":
arpVoucherLines[0].FieldByName("DEBIT").Value = Convert.ToDouble(workTable.Rows[j]["TOTAL"].ToString());
sign = 1;
break;
default:
arpVoucherLines[0].FieldByName("CREDIT").Value = Convert.ToDouble(workTable.Rows[j]["TOTAL"].ToString());
sign = 0;;
break;
}
}
arpPaymentLines = arpVoucherLines._Item[0].FieldByName("PAYMENT_LIST").Lines;
if (arpPaymentLines.AppendLine())
{
if (workTable.Rows[j]["DUEDATE"].ToString() != "")
{
tempdate = Convert.ToDateTime(workTable.Rows[j]["DUEDATE"].ToString());
arpPaymentLines[0].FieldByName("MODULENR").Value = 5;
arpPaymentLines[0].FieldByName("DATE").Value = tempdate.ToShortDateString();
arpPaymentLines[0].FieldByName("TRCODE").Value = 5;
arpPaymentLines[0].FieldByName("SIGN").Value = sign;
arpPaymentLines[0].FieldByName("TOTAL").Value = Convert.ToDouble(workTable.Rows[j]["TOTAL"].ToString());
arpPaymentLines[0].FieldByName("DISCTRDELLIST").Value = 0;
arpPaymentLines[0].FieldByName("PAY_NO").Value = 1;
arpPaymentLines[0].FieldByName("MODIFIED").Value = 1;
arpPaymentLines[0].FieldByName("PROCDATE").Value = ficheDate;
arpPaymentLines[0].FieldByName("DISCOUNT_DUEDATE").Value = tempdate.ToShortDateString();
arpPaymentLines[0].FieldByName("TRCURR").Value = 0;
arpPaymentLines[0].FieldByName("TRRATE").Value = 1;
}
}
// ''''VİRMAN FİŞİ SATIR 2'''''''''''''''''''''''''''''''''''''''
if (arpVoucherLines.AppendLine())
{
arpVoucherLines[1].FieldByName("ARP_CODE").Value = btn_CARI_I.EditValue;
arpVoucherLines[1].FieldByName("GL_CODE1").Value = GL_CODE_I;// clientAcc_1;
arpVoucherLines[1].FieldByName("CURR_TRANS").Value = 0;
arpVoucherLines[1].FieldByName("CURRSEL_TRANS").Value = 1;
arpVoucherLines[1].FieldByName("TC_XRATE").Value = 1;
arpVoucherLines[1].FieldByName("TC_AMOUNT").Value = Convert.ToDouble(workTable.Rows[j]["TOTAL"].ToString());
arpVoucherLines[1].FieldByName("DESCRIPTION").Value = "FT-" + workTable.Rows[j]["DOCODE"].ToString() + " " + workTable.Rows[j]["NOTES1"].ToString();
switch (workTable.Rows[j]["TYPE"].ToString())
{
case "6":
case "7":
case "8":
case "9":
case "10":
arpVoucherLines[1].FieldByName("CREDIT").Value = Convert.ToDouble(workTable.Rows[j]["TOTAL"].ToString());
break;
default:
arpVoucherLines[1].FieldByName("DEBIT").Value = Convert.ToDouble(workTable.Rows[j]["TOTAL"].ToString());
break;
}
arpVoucherLines[1].FieldByName("DATA_REFERENCE").Value = "~";
}
arpPaymentLines = arpVoucherLines._Item[1].FieldByName("PAYMENT_LIST").Lines;
if (arpPaymentLines.AppendLine())
{
if (workTable.Rows[j]["DUEDATE"].ToString() != "")
{
tempdate = Convert.ToDateTime(workTable.Rows[j]["DUEDATE"].ToString());
arpPaymentLines[0].FieldByName("MODULENR").Value = 5;
arpPaymentLines[0].FieldByName("DATE").Value = tempdate.ToShortDateString();
arpPaymentLines[0].FieldByName("TRCODE").Value = 5;
arpPaymentLines[0].FieldByName("SIGN").Value = sign;
arpPaymentLines[0].FieldByName("TOTAL").Value = Convert.ToDouble(workTable.Rows[j]["TOTAL"].ToString());
arpPaymentLines[0].FieldByName("DISCTRDELLIST").Value = 0;
arpPaymentLines[0].FieldByName("PAY_NO").Value = 1;
arpPaymentLines[0].FieldByName("MODIFIED").Value = 1;
arpPaymentLines[0].FieldByName("PROCDATE").Value = ficheDate;
arpPaymentLines[0].FieldByName("DISCOUNT_DUEDATE").Value = tempdate.ToShortDateString();
arpPaymentLines[0].FieldByName("TRCURR").Value = 0;
arpPaymentLines[0].FieldByName("TRRATE").Value = 1;
}
}
// arpVoucher.ExportToXML("","c:\temp\aa.xml");
if (arpVoucher.Post())
{
// UnityObjects.IData invObj = default(UnityObjects.IData);
Query Querys = _GLOBAL_PARAMETERS.Global.UnityApp.NewQuery();
string Query_String = " SELECT LOGICALREF FROM dbo.LG_" + _GLOBAL_PARAMETERS._SIRKET_NO + "_01_INVOICE where (FICHENO='" + workTable.Rows[j]["FICHENO"].ToString() + "')";
Querys.Statement = Query_String;
if (Querys.OpenDirect())
{
Querys.First();
switch (workTable.Rows[j]["TYPE"].ToString())
{
case "6":
case "7":
case "8":
case "9":
case "10":
invObj = _GLOBAL_PARAMETERS.Global.UnityApp.NewDataObject(UnityObjects.DataObjectType.doSalesInvoice);
break;
default:
invObj = _GLOBAL_PARAMETERS.Global.UnityApp.NewDataObject(UnityObjects.DataObjectType.doPurchInvoice);
break;
}
if (invObj.Read(Querys.QueryFields[0].Value))
{
invObj.DataFields.FieldByName("TRADING_GRP").Value = "FAC";
workTable.Rows[j]["DURUMU"] = "AKTARILDI";
}
invObj.Post();
}
}
else
{
if (arpVoucher.ValidateErrors.Count > 0)
{
for (int ix = 0; ix <= arpVoucher.ValidateErrors.Count - 1; ix++)
{
MessageBox.Show("Error code : " + (arpVoucher.ValidateErrors[ix].ID) + "Error code : " + (char)10 + arpVoucher.ValidateErrors[ix].Error.ToString());
}
}
}
}
}
}
