//Personel Listesi public void PersonelListData() { var CaniasWebServiceYeni = new iasWebServiceImplService(); string sessionid = CaniasWebServiceYeni.login("00", "T", "NEW", "CANIAS", "192.168.1.50:27499/S2", "WSLIZAY", "Ws-123lizay"); //object resp = CaniasWebServiceYeni.callIASService(sessionid, "mobilExpenseList", "1,40,16.01.2018,20.02.2018,1,1", "STRING", true); object resp = CaniasWebServiceYeni.callIASService(sessionid, "mobilExpenseList", "1,40,16.01.2018,20.02.2018,1,1", "STRING", true); //object resp = CaniasWebServiceYeni.callIASService(sessionid, "mobilExpenseList", "2,40,01.01.2018,20.03.2018,1,1,2018,02", "STRING", true); string jsonString = resp.ToString(); CaniasWebServiceYeni.logout(sessionid); JArray jsonVal = JArray.Parse(jsonString) as JArray; dynamic lizaylist = jsonVal; JSONData d = new JSONData(); //foreach (dynamic x in lizaylist) //{ // Lizay.dll.method.MOBILUSERLIST.AddUserData(new Lizay.dll.entity.MOBILUSERLIST() // { // PERSID = x.PERSID.ToString(), // DISPLAY = x.PERSTEXT.ToString(), // DEPARTMENT = x.PERSBUSA.ToString(), // DEPARTMENTT = x.PERSBUSATEXT.ToString(), // BIRTHDAY = "", // NAME = x.PERSTEXT.ToString(), // SURNAME = x.PERSTEXT.ToString(), // PAY = x.PERSPAY.ToString(), // }); // Lizay.dll.method.MOBILUSERLIST.AddCompanyData(new Lizay.dll.entity.MOBILUSERLIST() // { // DEPARTMENT = x.PERSBUSA.ToString(), // DEPARTMENTT = x.PERSBUSATEXT.ToString(), // }); //} Label2.Text = jsonVal.Count.ToString() + " Adet personel ve mağaza kaydı aktarılmıştır."; }
//Mağaza Hedef Dataları public void CompanySalesTargetData() { var CaniasWebServiceYeni = new iasWebServiceImplService(); string sessionid = CaniasWebServiceYeni.login("00", "T", "NEW", "CANIAS", "192.168.1.50:27499/S2", "WSLIZAY", "Ws-123lizay"); //object resp = CaniasWebServiceYeni.callIASService(sessionid, "mobilExpenseList", "1,40,01.01.2018,20.03.2018,1,1,2018,02", "STRING", true); object resp = CaniasWebServiceYeni.callIASService(sessionid, "mobilExpenseList", "2,40,01.03.2018,21.03.2018,1,1,2018,03", "STRING", true); string jsonString = resp.ToString(); CaniasWebServiceYeni.logout(sessionid); JArray jsonVal = JArray.Parse(jsonString) as JArray; dynamic lizaylist = jsonVal; JSONData d = new JSONData(); foreach (dynamic x in lizaylist) { Lizay.dll.method.COMPANYTARGETRATE.AddCompanyTargetData(new Lizay.dll.entity.COMPANYTARGETRATE() { CLIENT = x.CLIENT.ToString(), COMPANY = x.COMPANY.ToString(), FINYEAR = x.FINYEAR.ToString(), FINPERIOD = x.FINPERIOD.ToString(), TOTALORAN = x.TOTALORAN.ToString(), BUSAREA = x.BUSAREA.ToString(), STEXT = x.STEXT.ToString(), PLAIN = x.PLAIN.ToString(), MAGAZAORAN = x.MAGAZAORAN.ToString(), CURRENCY = "TL", }); } Label2.Text = jsonVal.Count.ToString() + " Adet mağaza hedef kaydı aktarılmıştır."; }
protected void Page_Load(object sender, EventArgs e) { if (CurrentUser.USERNAME == "") { FormsAuthentication.RedirectToLoginPage(); } if (IsPostBack) { return; } if (string.IsNullOrEmpty(Page.Request.QueryString["Barkod"])) { Response.Redirect("urunarama.aspx"); } var barcodeData = Page.Request.QueryString["Barkod"]; if (string.IsNullOrEmpty(barcodeData)) { Response.Redirect("urunarama.aspx"); } var sessionId = ""; List <BarcodeViewModel> barcode; var caniasWebService = new iasWebServiceImplService(); try { //var arg = "IYILMAZ," + barcodeData; var arg = CurrentUser.USERNAME + "," + barcodeData; sessionId = caniasWebService.login("00", "T", "NEW", "CANIAS", "192.168.1.50:27499/S2", "WSLIZAY", "Ws-123lizay"); var resp = caniasWebService.callIASService(sessionId, "RetailBatchCheck", arg, "STRING", true); var json = resp.ToString().Replace("[]", "''").Replace("\"ROW\":", ""); json = json.Remove(0, 1); json = "[" + json; json = json.Remove(json.Length - 1, 1); json = json + "]"; barcode = JsonConvert.DeserializeObject <List <BarcodeViewModel> >(json); } catch (Exception ex) { Console.WriteLine(ex); if (!string.IsNullOrEmpty(sessionId)) { caniasWebService.logout(sessionId); } return; } finally { if (!string.IsNullOrEmpty(sessionId)) { caniasWebService.logout(sessionId); } } switch (barcode) { case null: return; case List <BarcodeViewModel> list: { var mainProduct = list.SingleOrDefault(x => x.IsTp == "1"); if (mainProduct == null) { Response.Redirect("urunarama.aspx"); } var alternativeProduct = list.Where(x => x.IsTp == "0").ToList(); CreateHtmlMainProduct(mainProduct); CreateHtmlAlternativeProduct(alternativeProduct); break; } } }
//Personel Satış Dataları public void PersonData() { var CaniasWebServiceYeni = new iasWebServiceImplService(); string sessionid = CaniasWebServiceYeni.login("00", "T", "NEW", "CANIAS", "192.168.1.50:27499/S2", "WSLIZAY", "Ws-123lizay"); //object resp = CaniasWebServiceYeni.callIASService(sessionid, "mobilExpenseList", "40,16.01.2018,16.01.2018,1,1", "STRING", true); object resp = CaniasWebServiceYeni.callIASService(sessionid, "mobilExpenseList", "0,40,01.03.2018,31.03.2018,0,1", "STRING", true); string jsonString = resp.ToString(); CaniasWebServiceYeni.logout(sessionid); JArray jsonVal = JArray.Parse(jsonString) as JArray; dynamic lizaylist = jsonVal; JSONData d = new JSONData(); foreach (dynamic x in lizaylist) { Lizay.dll.method.MOBILEXPENSELIST.AddData(new Lizay.dll.entity.MOBILEXPENSELIST() { SATISD = x.SATISD.ToString(), SALDEPT = x.SALDEPT.ToString(), COMPANY = x.COMPANY.ToString(), DOCTYPE = x.DOCTYPE.ToString(), DOCNUM = x.DOCNUM.ToString(), DOCDATE = x.DOCDATE.ToString(), CUSTOMER = x.CUSTOMER.ToString(), NAME1 = x.NAME1.ToString(), CUSTGRP = x.CUSTGRP.ToString(), COUNTRY = x.COUNTRY.ToString(), DISCAMNT = x.DISCAMNT.ToString(), CURRENCY = x.CURRENCY.ToString(), ITEMNUM = x.ITEMNUM.ToString(), MATERIAL = x.MATERIAL.ToString(), MTEXT = x.MTEXT.ToString(), QUANTITY = x.QUANTITY.ToString(), QUNIT = x.QUNIT.ToString(), BUSAREA = x.BUSAREA.ToString(), SPRICE = x.SPRICE.ToString(), PRICEFACTOR = x.PRICEFACTOR.ToString(), GROSS = x.GROSS.ToString(), TDISCAMNT = x.TDISCAMNT.ToString(), DISCFROMHEAD = x.DISCFROMHEAD.ToString(), SUBTOTAL = x.SUBTOTAL.ToString(), ITENDORSE = x.ITENDORSE.ToString(), MATTYPE = x.MATTYPE.ToString(), MATGRP = x.MATGRP.ToString(), EXHM = x.EXHM.ToString(), EXHR = x.EXHR.ToString(), MONTSUBTOTAL = x.MONTSUBTOTAL.ToString(), YEARSUBTOTAL = x.YEARSUBTOTAL.ToString(), MONTHQUANTITY = x.MONTHQUANTITY.ToString(), YEARQUANTITY = x.YEARQUANTITY.ToString(), ISVARIANT = x.ISVARIANT.ToString(), QUANTITYX = x.QUANTITYX.ToString(), TCOST = x.TCOST.ToString(), BATCHNUM = x.BATCHNUM.ToString(), TOTPROF = x.TOTPROF.ToString(), TOTRATE = x.TOTRATE.ToString(), PRINTEDINVNUM = x.PRINTEDINVNUM.ToString(), MAINMATGRP = x.MAINMATGRP.ToString(), PAYMCOND = x.PAYMCOND.ToString(), PAYMTYPE = x.PAYMTYPE.ToString(), SCMADEN = x.SCMADEN.ToString(), SCGRUP = x.SCGRUP.ToString(), SCTEMEL = x.SCTEMEL.ToString(), SALDEPTX = x.SALDEPTX.ToString(), PUAN = x.PUAN.ToString(), TEGI = x.TEGI.ToString(), TERW = x.TERW.ToString(), INVTYPE = x.INVTYPE.ToString(), DATATYPE = "PERSONEL", }); } Label2.Text = jsonVal.Count.ToString() + " Adet personel kaydı aktarılmıştır."; }
public static string GetData(int pageIndex) { var sessionId = ""; var caniasWebService = new iasWebServiceImplService(); var sb = new StringBuilder(); try { var a = pageIndex * 10; var countFilter = ""; if (pageIndex == 1) { countFilter = "1," + a; } if (pageIndex > 1) { countFilter = (a + 1) + "," + (a + 10); } //var arg = "3,IYILMAZ,AMML,,,,,,1,10"; //var arg = "3,IYILMAZ,AMML,,,,,," + countFilter; //var arg = "3,IYILMAZ,ALYM,AU,AL,05,1,10"; var arg = "3," + ActiveSession.ActiveUserName + ActiveSession.ActiveUrunFilter + "," + countFilter; sessionId = caniasWebService.login("00", "T", "NEW", "CANIAS", "192.168.1.50:27499/S2", "WSLIZAY", "Ws-123lizay"); var resp = caniasWebService.callIASService(sessionId, "RetailMatCheck", arg, "STRING", true); var json = resp.ToString().Replace("[]", "''").Replace("\"ROW\":", ""); json = json.Remove(0, 1); json = "[" + json; json = json.Remove(json.Length - 1, 1); json = json + "]"; var list = JsonConvert.DeserializeObject <List <BarcodeListViewModel> >(json); var i = 0; foreach (var d in list.ToList()) { sb.AppendLine("<div class=\"row\">"); sb.AppendLine("<div class=\"col-lg-12 col-xs-12\" style = \"margin-top: 15px;border-bottom: groove;\">"); sb.AppendLine("<div class=\"col-lg-3 col-xs-6\"> "); sb.AppendLine("<img src=\"data:image/png;base64," + d.Pict.Replace("-----BEGIN CERTIFICATE-----", "").Replace("-----END CERTIFICATE-----", "") + "\" class=\"img-responsive\" alt =\"\" />"); sb.AppendLine("</div>"); sb.AppendLine("<div class=\"col-lg-9 col-xs-6\"> "); //sb.AppendLine("<div class=\"col-lg-12 col-xs-12\" style =\"margin-top: 10px;\">"); //sb.AppendLine("<div class=\"urunlistsol\">Taş:</div>"); //sb.AppendLine("<p class=\"urunlistsag\">" + d.IsMatText.Trim() + "</p>"); //sb.AppendLine("</div>"); sb.AppendLine("<div class=\"col-lg-12 col-xs-12\" style =\"margin-top: 10px;\">"); sb.AppendLine("<div class=\"urunlistsol\">Taş Özellikleri:</div>"); sb.AppendLine("<p class=\"urunlistsag\">" + d.IsTasDet.Trim() + "</p>"); sb.AppendLine("</div>"); sb.AppendLine("<div class=\"col-lg-12 col-xs-12\" style =\"margin-top: 10px;\">"); sb.AppendLine("<div class=\"urunlistsol\">Barkod:</div>"); sb.AppendLine("<p class=\"urunlistsag\">" + d.Batch.Trim() + "</p>"); sb.AppendLine("</div>"); sb.AppendLine("<div class=\"col-lg-12 col-xs-12\" style =\"margin-top: 10px;\">"); sb.AppendLine("<div class=\"urunlistsol\"> Montür:</div>"); sb.AppendLine("<p class=\"urunlistsag\">" + d.DetColor.Trim() + "</p>"); sb.AppendLine("</div>"); sb.AppendLine("<div class=\"col-lg-12 col-xs-12\" style =\"margin-top: 10px;\"> "); sb.AppendLine("<div class=\"urunlistsol\">Ağırlık:</div>"); sb.AppendLine("<p class=\"urunlistsag\">" + d.QuantityX.Trim() + "gr</p>"); sb.AppendLine("</div>"); //sb.AppendLine("<div class=\"col-lg-12 col-xs-12\" style =\"margin-top: 10px;\"> "); //sb.AppendLine("<div class=\"urunlistsol\">Kesim:</div>"); //sb.AppendLine("<p class=\"urunlistsag\">" + d.IsMatText.Trim() + "</p>"); //sb.AppendLine("</div>"); sb.AppendLine("<div class=\"col-lg-12 col-xs-12\" style =\"margin-top: 10px;\"> "); sb.AppendLine("<div class=\"urunlistsol\">Fiyat:</div>"); sb.AppendLine("<p class=\"urunlistsag\">" + d.Lastprice.Trim() + "</p>"); sb.AppendLine("</div>"); sb.AppendLine("<div class=\"col-lg-12 col-xs-12\" style =\"margin-top: 10px;\"> "); sb.AppendLine("<div class=\"urunlistsol\">Fiyat Kuru:</div>"); sb.AppendLine("<p class=\"urunlistsag\">" + d.Spricecurrency.Trim() + "</p>"); sb.AppendLine("</div>"); sb.AppendLine("<div class=\"col-lg-12 col-xs-12\" style =\"margin-top: 10px;\" > "); sb.AppendLine("<div class=\"urunlistsol\">E:</div>"); sb.AppendLine("<p class=\"urunlistsag ustucizik\"> " + d.Mameti.Trim() + "</p>"); sb.AppendLine("</div>"); //sb.AppendLine("<div class=\"col-lg-12 col-xs-12\" style =\"margin-top: 10px;\">"); //sb.AppendLine("<div class=\"urunlistsol\"> Maliyet Kuru:</div>"); //sb.AppendLine("<p class=\"urunlistsag\">" + d.Costcurrency.Trim() + "</p>"); //sb.AppendLine("</div>"); sb.AppendLine("<div class=\"col-lg-12 col-xs-12\" style =\"margin-top: 10px;\">"); sb.AppendLine("<div class=\"urunlistsol\"> Bulunduğu Mağaza:</div>"); sb.AppendLine("<p class=\"urunlistsag\">" + d.IsWare.Trim() + "</p>"); sb.AppendLine("</div>"); sb.AppendLine("</div>"); sb.AppendLine("</div>"); sb.AppendLine("</div>"); //if (i > 10) // break; i++; } return(sb.ToString()); } catch (Exception ex) { Console.WriteLine(ex); if (!string.IsNullOrEmpty(sessionId)) { caniasWebService.logout(sessionId); } } finally { if (!string.IsNullOrEmpty(sessionId)) { caniasWebService.logout(sessionId); } } return(""); }