#region Auto generated code blocks
//Changes to this region may cause incorrect behavior and will be lost if the code is regenerated.
#region Atama1 Method
//Owner : hakan.ak
//CreateDate : 17/12/2018 10:14
//Modifier : hakan.ak
//ModifyDate : 23/01/2019 05:45
//Description:
private void Atama1() {
if ((bool) chkDemirbas.isChecked) {
FormData.Set("TALEP_TURU", "DM");
}
}
#endregion
#region Gorunurluk2 Method
//Owner : hakan.ak
//CreateDate : 08/01/2019 05:07
//Modifier : hakan.ak
//ModifyDate : 23/01/2019 05:45
//Description:
private void Gorunurluk2() {
AvansToplam.Visible = true;
txtKalan.Visible = true;
AvansHesapla();
}
#endregion
#region Gorunurluk1 Method
//Owner : hakan.ak
//CreateDate : 14/01/2019 05:54
//Modifier : hakan.ak
//ModifyDate : 23/01/2019 05:45
//Description:
private void Gorunurluk1() {
//DurumSorgula();
SAPMetoduCalistir1();
}
#endregion
#region SAPMetoduCalistir1 Method
//Owner : hakan.ak
//CreateDate : 21/01/2019 11:32
//Modifier : hakan.ak
//ModifyDate : 23/01/2019 05:45
//Description:
private void SAPMetoduCalistir1() {
#if(SILVERLIGHT)
Current.Instance.productivity.rIntegration.GetSapFunction("ZFIASB_MASTLM_GET_BUTDUR_MY", "", "", "SAP_CANLI", ((s2, cb1) => {
SapTables _row = null;
SapFields _field = null;
cb1.Result.GetElement("IBUTDUR").Tables.Clear();
_row = new SapTables();
_field = cb1.Result.GetElement("IBUTDUR").GetDetail("KOSTL");
_field.SetValue(GetComboSelectedRow(cmbMASRAF_YERI).Key1);
_row.Detail.Add(new SapTableFields(1, _field));
_field = cb1.Result.GetElement("IBUTDUR").GetDetail("SETNAME");
_field.SetValue(GetComboSelectedRow(cmbBUTCE_GRUBU).Key1);
_row.Detail.Add(new SapTableFields(1, _field));
cb1.Result.GetElement("IBUTDUR").Tables.Add(_row);
cb1.Result.GetElement("PBUTDUR").Tables.Clear();
cb1.Result.GetElement("RETURN").Tables.Clear();
cb1.Result.GetElement("PUSNAM").SetValue("D_DMS");
cb1.Result.GetElement("PBUDAT").SetValue(DateTime.Now.Date);
cb1.Result.GetElement("PBUKRS").SetValue(GetComboSelectedRow(cmbSIRKET).Key1);
Current.Instance.productivity.rIntegration.CallSapFunction(cb1.Result, "", "", "SAP_CANLI", ((s, cb) => {
SapFunction sp2 = cb.Result;
EventHandler<WindowClosedEventArgs> onRowSelected = ((s3, ex) => {
var selector = (CustomSelection) s3;
if ((bool) ex.DialogResult) {
DTextBox102.Value = selector.GetCell("BUTYTD") as String;
tLog.Value = selector.GetCell("BEK") as String;
//FormData.Set("CEYREK_BUTCE",selector.GetCell("BUTYTD") as String);
//FormData.Set("HARCANAN_BUTCE",selector.GetCell("BEK") as String);
DTextBox99.Value = selector.GetCell("BUTASIM") as String;
}
});
SapElements el = sp2.GetElement("PBUTDUR");
//----
PDataTable dt = new PDataTable();
foreach (SapFields pc in el.Detail) {
switch (pc.DataType) {
case "C": dt.Columns.Add(new PDataColumn() {
ColumnName = pc.Name, DataType = typeof (string)
}); break;
case "N": dt.Columns.Add(new PDataColumn() {
ColumnName = pc.Name, DataType = typeof (string)
}); break;
default: dt.Columns.Add(new PDataColumn() {
ColumnName = pc.Name, DataType = typeof (string)
}); break;
}
}
for (int i = 0; i < el.Tables.Count; i++) {
PDataRow dr = dt.NewRow();
SapTables st = el.Tables[i];
foreach (PDataColumn dc in dt.Columns) {
SapTableFields stf = st.Detail.Where(c => c.Name.Equals(dc.ColumnName)).FirstOrDefault();
SapFields sf = el.Detail.Where(c => c.Name.Equals(dc.ColumnName)).FirstOrDefault();
if (stf != null) {
switch (sf.DataType) {
case "C": dr[dc.ColumnName] = stf.Value.ToString(); break;
case "N": dr[dc.ColumnName] = stf.Value.ToString(); break;
default : dr[dc.ColumnName] = stf.Value; break;
}
}
}
dt.Rows.Add(dr);
}
//----
var RowSelector = new CustomSelection(CustomSelectionTypes.Object, dt, string.Empty, el.Headers);
RowSelector.Closed += new EventHandler<WindowClosedEventArgs>(onRowSelected);
RowSelector.ShowDialog();
}));
}));
#else
var cb1 = Current.Instance.productivity.rIntegration.GetSapFunction("ZFIASB_MASTLM_GET_BUTDUR_MY", "", "", "SAP_CANLI");
cb1.Result.GetElement("IBUTDUR").Tables.Clear();
cb1.Result.GetElement("PBUTDUR").Tables.Clear();
cb1.Result.GetElement("RETURN").Tables.Clear();
cb1.Result.GetElement("PUSNAM").SetValue("D_DMS");
cb1.Result.GetElement("PBUDAT").SetValue(DateTime.Now.Date);
cb1.Result.GetElement("PBUKRS").SetValue(GetComboSelectedRow(cmbSIRKET).Key1);
SapFunction sp2 = Current.Instance.productivity.rIntegration.CallSapFunction(cb1.Result, "", "", "SAP_CANLI");
SapElements sapTable = sp2.GetElement("PBUTDUR");
//----
var table = new DataTable();
table.TableName = sapTable.Name;
foreach (SapFields pc in sapTable.Detail) {
switch (pc.DataType) {
case "C": table.Columns.Add(new DataColumn() {
ColumnName = pc.Name, DataType = typeof (string), Caption = getSapTitle(pc.Name)
}); break;
case "N": table.Columns.Add(new DataColumn() {
ColumnName = pc.Name, DataType = typeof (string), Caption = getSapTitle(pc.Name)
}); break;
default: table.Columns.Add(new DataColumn() {
ColumnName = pc.Name, DataType = typeof (string), Caption = getSapTitle(pc.Name)
}); break;
}
}
foreach (var row in sapTable.Tables) {
var dr = table.NewRow();
foreach (DataColumn dc in table.Columns) {
SapTableFields stf = row.Detail.Where(c => c.Name.Equals(dc.ColumnName)).FirstOrDefault();
SapFields sf = sapTable.Detail.Where(c => c.Name.Equals(dc.ColumnName)).FirstOrDefault();
if (stf != null) {
switch (sf.DataType) {
case "C": dr[dc.ColumnName] = stf.Value.ToString(); break;
case "N": dr[dc.ColumnName] = stf.Value.ToString(); break;
default: dr[dc.ColumnName] = stf.Value; break;
}
}
}
table.Rows.Add(dr);
}
var ds = new DataSet();
ds.Tables.Add(table);
//----
using (ds) {
var headers = sapTable.Detail.Select(f => new GridHeader() {
Name = f.Name
}).ToList();
OpenCustomDialog(CustomSelectionTypes.DataSet, ds, headers, ((sender1, data, evnt) => {
if (data != null) {
DTextBox102.Value = GetPropertyValue(data, "BUTYTD") as String;
tLog.Value = GetPropertyValue(data, "BUTONC") as String;
DTextBox99.Value = GetPropertyValue(data, "BUTASIM") as String;
}
}));
}
#endif
}
#endregion
#endregion
public void AvansHesapla(){
string txt1 = (String) FormData.Get("ONAYLI_FORM_ID");
string sql1 = "SELECT ODENECEK_TOPLAM_TUTAR as Toplam FROM [T_SEYAHAT_TALEP] WHERE OBJECT_ID='"+txt1+"' UNION SELECT AVANS_TUTARI as Toplam FROM [T_AVANS_TALEP] WHERE OBJECT_ID='"+txt1+"'";
Current.Instance.productivity.rAdo.Query(sql1,-1,false,(s1,e1) => {
System.Data.DataSet ds = Paperwork.Library.Assembly.DataTableSerializer.DeSerializeDataTable(e1.Result.Result);
if(ds.Tables[0].Rows.Count > 0)
{
AvansToplam.Text = ds.Tables[0].Rows[0]["Toplam"].ToString();
}
},string.Empty);
string query = "SELECT ISNULL(SUM(TALEP_TUTARI),0) AS TOPLAM FROM [T_MASRAF_TALEP] WHERE ONAYLI_FORM_ID='"+txt1+"' ";
Current.Instance.productivity.rAdo.Query(query,-1,false,(s1,e1) => {
System.Data.DataSet ds = Paperwork.Library.Assembly.DataTableSerializer.DeSerializeDataTable(e1.Result.Result);
if(ds.Tables[0].Rows.Count > 0)
{
txtKalan.Text = ds.Tables[0].Rows[0]["TOPLAM"].ToString();
}
},string.Empty);
}
public void DurumSorgula(){
string MASRAF_YERI = (String) FormData.Get("MASRAF_YERI");
string BUTCE_GRUBU = (String) FormData.Get("BUTCE_GRUBU");
double ONAY_TOPLAM_SQL =0;
//string sql0 = "SELECT ISNULL(SUM([TALEP_EUR]),0) AS ONAY_TOPLAM FROM [T_MASRAF_TALEP] WHERE MASRAF_YERI='" + MASRAF_YERI + "' AND BUTCE_GRUBU ='" + BUTCE_GRUBU + "' AND TALEP_TARIHI BETWEEN '2019-01-01' AND '2019-03-31' AND ONAY_SURECINDE_MI ='T'";
//tLog.Value = sql0.ToString();
// Current.Instance.productivity.rAdo.Query(sql0,-1,false,(s1, e1) => {
// System.Data.DataSet dss = Paperwork.Library.Assembly.DataTableSerializer.DeSerializeDataTable(e1.Result.Result);
// if(dss.Tables[0].Rows.Count > 0)
// {
// ONAY_TOPLAM_SQL = double.Parse(dss.Tables[0].Rows[0]["ONAY_TOPLAM"].ToString());
//Dialogs.ShowInfo("", "ONAY_TOPLAM_SQL" + ONAY_TOPLAM_SQL.ToString(), this);
//FormData.Set("ONAY_BEKLEYEN_BUTCE", ONAY_TOPLAM_SQL);
//}
// },string.Empty);
string sql1 = "SELECT [CEYREK] ,[HARCANAN] ,[SONGUNCELLEME] FROM [PWL_MASRAF_BUTCE_DURUMLARI] WHERE MASRAF_YERI='"+MASRAF_YERI+"' and BUTCE_GRUBU='"+BUTCE_GRUBU+"'";
tLog.Value = sql1.ToString();
Current.Instance.productivity.rAdo.Query(sql1,-1,false,(s1,e1) => {
System.Data.DataSet ds = Paperwork.Library.Assembly.DataTableSerializer.DeSerializeDataTable(e1.Result.Result);
if(ds.Tables[0].Rows.Count > 0)
{
//AvansToplam.Text = ds.Tables[0].Rows[0]["Toplam"].ToString();
DTextBox102.Value = ds.Tables[0].Rows[0]["CEYREK"].ToString();
FormData.Set("CEYREK_BUTCE",double.Parse(ds.Tables[0].Rows[0]["CEYREK"].ToString()));
FormData.Set("HARCANAN_BUTCE",double.Parse(ds.Tables[0].Rows[0]["HARCANAN"].ToString()));
double CEYREK = double.Parse(ds.Tables[0].Rows[0]["CEYREK"].ToString());
double HARCANAN = double.Parse(ds.Tables[0].Rows[0]["HARCANAN"].ToString());
//Dialogs.ShowInfo("", "CEYREK" + CEYREK.ToString(), this);
//Dialogs.ShowInfo("", "HARCANAN" + HARCANAN.ToString(), this);
double BAKIYE = Convert.ToDouble(CEYREK) - Convert.ToDouble(HARCANAN) - Convert.ToDouble(ONAY_TOPLAM_SQL);
//Dialogs.ShowInfo("", "BAKIYE" + BAKIYE, this);
FormData.Set("BUTCE_BAKIYESI", BAKIYE);
}
},string.Empty);
}
No comment