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()); } } } } } }