Oct 21, 2009, 5:43 AM
records to the client side does not
all fields by adMasterStore object Functions.CreateDataStore method under JsonReader type is generated.
WebService Code :
private void CreateDataStore()
{
Store adMasterStore = Functions.CreateDataStore("adMasterStore", this.ROW_NO, dataSource);
adMasterStore.WriteBaseParams.Add(new Coolite.Ext.Web.Parameter("KeyField", MasterKeyField));
adMasterStore.WriteBaseParams.Add(new Coolite.Ext.Web.Parameter("KeyValue", MasterRecID));
adMasterStore.WriteBaseParams.Add(new Coolite.Ext.Web.Parameter("PAGENAME", MasterPageName + "|" + PageName));
adMasterStore.WriteBaseParams.Add(new Coolite.Ext.Web.Parameter("SESSION_USERID", UserInfo.UserID));
adMasterStore.WriteBaseParams.Add(new Coolite.Ext.Web.Parameter("SESSION_USERNAME", UserInfo.UserName));
adMasterStore.WriteBaseParams.Add(new Coolite.Ext.Web.Parameter("SESSION_SUBEID", UserInfo.UserLoginSubeID));
adMasterStore.WriteBaseParams.Add(new Coolite.Ext.Web.Parameter("SESSION_CARIYIL", UserInfo.CariYil));
adMasterStore.AutoLoad = true;
adMasterStore.AutoLoadParams.Add(new Coolite.Ext.Web.Parameter("start", "={0}"));
adMasterStore.AutoLoadParams.Add(new Coolite.Ext.Web.Parameter("limit", "={20}"));
adMasterStore.AutoLoadParams.Add(new Coolite.Ext.Web.Parameter("sort", ""));
adMasterStore.AutoLoadParams.Add(new Coolite.Ext.Web.Parameter("dir", ""));
adMasterStore.AutoLoadParams.Add(new Coolite.Ext.Web.Parameter("KeyField", MasterKeyField));
adMasterStore.AutoLoadParams.Add(new Coolite.Ext.Web.Parameter("KeyValue", MasterRecID));
adMasterStore.AutoLoadParams.Add(new Coolite.Ext.Web.Parameter("PAGENAME", MasterPageName + "|" + PageName));
adMasterStore.AutoLoadParams.Add(new Coolite.Ext.Web.Parameter("SESSION_USERID", UserInfo.UserID));
adMasterStore.AutoLoadParams.Add(new Coolite.Ext.Web.Parameter("SESSION_USERNAME", UserInfo.UserName));
adMasterStore.AutoLoadParams.Add(new Coolite.Ext.Web.Parameter("SESSION_SUBEID", UserInfo.UserLoginSubeID));
adMasterStore.AutoLoadParams.Add(new Coolite.Ext.Web.Parameter("SESSION_CARIYIL", UserInfo.CariYil));
adMasterStore.RemoteSort = true;
adMasterStore.ShowWarningOnFailure = false;
adMasterStore.AjaxEventConfig.Timeout = 60000;
if (WebServiceMode)
{
adMasterStore.UpdateProxy.Add(new Coolite.Ext.Web.HttpWriteProxy()
{
Method = Coolite.Ext.Web.HttpMethod.POST,
Url = Constants.ApplicationConst.ApplicationBaseDir + "DataEntity/WriteDataService.asmx/WriteProccess"
});
Coolite.Ext.Web.HttpProxy httpProxy = new Coolite.Ext.Web.HttpProxy();
httpProxy.Json = true;
httpProxy.Url = Constants.ApplicationConst.ApplicationBaseDir + "DataEntity/ReadDataService.asmx/ReadData";
httpProxy.Method = Coolite.Ext.Web.HttpMethod.POST;
httpProxy.Headers.Add(new Coolite.Ext.Web.Parameter("Content-Type", "application/json; charset=utf-8", Coolite.Ext.Web.ParameterMode.Value));
adMasterStore.Proxy.Add(httpProxy);
adMasterStore.SkipIdForNewRecords = true;
adMasterStore.Listeners.DataChanged.AutoPostBack = false;
adMasterStore.Listeners.DataChanged.Handler =
"\n var record = this.getAt(0); \n" +
" if (record){ \n"+
"BeforeLoadFormRecords(record); \n" +
"var items = Ext.ComponentMgr.all.items; \n" +
"for (i = 0; i < items.length; i++) { \n" +
" if (items[i].dataIndex) { \n" +
" if (items[i].dataIndex != '') { \n" +
" if (items[i].xtype != 'checkbox') { \n" +
" items[i].setValue(record.get(items[i].dataIndex)); \n" +
" } else { \n" +
" items[i].setValue(record.get(items[i].dataIndex) == items[i].inputValue); \n" +
" } \n" +
" } \n" +
" } \n" +
"} \n" +
"AfterLoadFormRecords(record); } return true;";
}
else
{
adMasterStore.Proxy.Add(new Coolite.Ext.Web.DataSourceProxy());
adMasterStore.RefreshData += new Coolite.Ext.Web.Store.AjaxRefreshDataEventHandler(adMasterStore_RefreshData);
}
Page.Form.Controls.AddAt(2, adMasterStore);
}
WebService Code :
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Web.UI.WebControls;
using System.Data;
using MWO;
namespace MogazWeb.DataEntity
{
/// <summary>
/// Summary description for ReadDataService
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.ComponentModel.ToolboxItem(false)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
[System.Web.Script.Services.ScriptService]
public class ReadDataService : System.Web.Services.WebService
{
[WebMethod]
public DataTable ReadData()
{
SqlDataSource ds = new SqlDataSource();
Scripts_User(ds);
DataView DataList = (DataView)ds.Select(System.Web.UI.DataSourceSelectArguments.Empty);
return DataList.Table;
}
public void Scripts_User(SqlDataSource dsData)
{
string sSQL = "\nSET NOCOUNT ON " +
"\n " +
"\nIF OBJECT_ID ('tempdb..{0}') IS NOT NULL DROP TABLE {0} " +
"\nIF OBJECT_ID ('tempdb..{1}') IS NOT NULL DROP TABLE {1} " +
"\n " +
"\nSELECT " +
"\n T.GUNCELLEME_NO, TC.* , " +
"\nCAST(NULL AS VARCHAR(55)) AS TAM_FIRMA_ADI_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS VERGI_DAIRESI_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS TAM_ADRES_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS SEHIR_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS TEL11_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS TEL12_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS TICARET_KISILIK_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS TICARET_ODASI_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS SANAYI_ODASI_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS MUSTERI_TEMSILCISI_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS OZEL_KODU1_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS OZEL_KODU4_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS OZEL_KODU7_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS PASIF_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS KAPANIS_TIPI_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS BOSSAHA1_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS BAGLANTI_ID_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS LISANS_NUMARASI_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS KISA_ADRES_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS SEHIR2_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS SNPMAHALI2_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS TEL21_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS NAKLIYEKOD2_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS SEVK_ADRES2_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS SEHIR3_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS SNPMAHALI3_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS TEL31_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS NAKLIYEKOD3_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS GAZ_ALIS_AMBARI_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS BAGLANTI_KODU_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS FIYAT_TIPI_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS P_FIYATTIPI_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS N_FIYATTIPI_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS C_FIYATTIPI_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS FAALIYET_TARIHI_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS SOZLESME_BITIM_TARIHI_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS UST_BAYI_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS MUSTERI_TIPI_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS ODEME_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS DOKME_UST_BAYI_TIPI_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS UST_BAYI_NAZIM_KOD_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS ODEMEGUNUGRIDI_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS DIGER_TICARI_UNVAN_CHK_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS KISITLAMALARGRIDI_X1, " +
"\nCAST(NULL AS VARCHAR(55)) AS UNVANGRIDI_X1 " +
"\nINTO {0} " +
"\nFROM {5} TC " +
"\n LEFT OUTER JOIN {6} T ON T.KAYIT_NO = TC.KAYIT_NO " +
"\nwhere T.KAYIT_NO = @KAYIT_NO " +
"\norder by T.GUNCELLEME_NO " +
"\n " +
"\nDECLARE @KAYIT_NO2 NUMERIC(14,0) " +
"\nDECLARE @FIELD_ISMI VARCHAR(22) " +
"\nDECLARE @DURUM VARCHAR(1) " +
"\nDECLARE @KAYITDURUM VARCHAR(1) " +
"\nDECLARE @DUZENLEYEN VARCHAR(15) " +
"\nDECLARE @ONAYLAYAN VARCHAR(15) " +
"\nDECLARE @DUZENLEME_TARIHI VARCHAR(15) " +
"\nDECLARE @ONAYLAMA_TARIHI VARCHAR(40) " +
"\nDECLARE @MUHASEBELESTIRME_TARIHI VARCHAR(40) " +
"\nDECLARE @MUHASEBELESTIREN VARCHAR(40) " +
"\nDECLARE @SUPDSTR VARCHAR(150) " +
"\nDECLARE @STOPUPDSTR VARCHAR(8000) " +
"\nDECLARE @OLDKAYIT_NO NUMERIC(14,0) " +
"\n " +
"\nSET @STOPUPDSTR = '' " +
"\n " +
"\n SELECT KAYIT_NO, FIELD_ISMI, UCD.FULL_NAME DUZENLEYEN, UCO.FULL_NAME ONAYLAYAN, UCM.FULL_NAME MUHASEBELESTIREN, " +
"\n DUZENLEME_TARIHI, ONAYLAMA_TARIHI, MUHASEBELESTIRME_TARIHI, TYC.DURUM " +
"\n INTO {1} " +
"\n FROM {3} TYC " +
"\n LEFT OUTER JOIN " + MWOC.GTN("UserConnections") + " UCD ON UCD.USER_NAME = TYC.DUZENLEYEN " +
"\n LEFT OUTER JOIN " + MWOC.GTN("UserConnections") + " UCO ON UCO.USER_NAME = TYC.ONAYLAYAN " +
"\n LEFT OUTER JOIN " + MWOC.GTN("UserConnections") + " UCM ON UCM.USER_NAME = TYC.MUHASEBELESTIREN " +
"\n WHERE KAYIT_NO IN (SELECT KAYIT_NO FROM {0} ) " +
"\n ORDER BY KAYIT_NO " +
"\n DECLARE ycursor CURSOR READ_ONLY FOR " +
"\n SELECT * from {1} " +
"\n OPEN ycursor " +
"\n FETCH NEXT FROM {4} INTO @KAYIT_NO2 , @FIELD_ISMI, @DUZENLEYEN, @ONAYLAYAN, @MUHASEBELESTIREN, @DUZENLEME_TARIHI, @ONAYLAMA_TARIHI, @MUHASEBELESTIRME_TARIHI, @KAYITDURUM " +
"\n SET @OLDKAYIT_NO = @KAYIT_NO2 " +
"\n WHILE @@FETCH_STATUS = 0 " +
"\n BEGIN " +
"\n IF (CHARINDEX(@FIELD_ISMI +'_X1', @STOPUPDSTR)=0) " +
"\n BEGIN " +
"\n IF @KAYITDURUM = 'G' " +
"\n SET @DURUM = 'G' " +
"\n ELSE IF @DUZENLEME_TARIHI IS NOT NULL " +
"\n SET @DURUM = 'T' " +
"\n ELSE " +
"\n SET @DURUM = 'Y' " +
"\n SET @SUPDSTR = ', '+ @FIELD_ISMI +'_X1='''+ + @DUZENLEYEN + '(' + @DURUM + ')' " +
"\n IF ISNULL(@ONAYLAYAN, '')<>'' " +
"\n BEGIN " +
"\n IF @KAYITDURUM = 'G' " +
"\n SET @DURUM = 'G' " +
"\n ELSE IF @ONAYLAMA_TARIHI IS NOT NULL " +
"\n SET @DURUM = 'T' " +
"\n ELSE " +
"\n SET @DURUM = 'Y' " +
"\n SET @SUPDSTR = @SUPDSTR + ';' + @ONAYLAYAN + '(' + @DURUM + ')' " +
"\n END " +
"\n IF ISNULL(@MUHASEBELESTIREN, '')<>'' " +
"\n BEGIN " +
"\n IF @KAYITDURUM = 'G' " +
"\n SET @DURUM = 'G' " +
"\n ELSE IF @MUHASEBELESTIRME_TARIHI IS NOT NULL " +
"\n SET @DURUM = 'T' " +
"\n ELSE " +
"\n SET @DURUM = 'Y' " +
"\n SET @SUPDSTR = @SUPDSTR + ';' + @MUHASEBELESTIREN + '(' + @DURUM + ')' " +
"\n END " +
"\n SET @SUPDSTR = @SUPDSTR + ''' ' " +
"\n SET @STOPUPDSTR = @STOPUPDSTR + @SUPDSTR " +
"\n END " +
"\n FETCH NEXT FROM {4} INTO @KAYIT_NO2, @FIELD_ISMI, @DUZENLEYEN, @ONAYLAYAN, @MUHASEBELESTIREN, @DUZENLEME_TARIHI, @ONAYLAMA_TARIHI, @MUHASEBELESTIRME_TARIHI, @KAYITDURUM " +
"\n IF (LEN(@STOPUPDSTR)>=5500) OR (@OLDKAYIT_NO <> @KAYIT_NO2) " +
"\n BEGIN " +
"\n SET @STOPUPDSTR = 'UPDATE {0} SET SIRA_NO = SIRA_NO' + @STOPUPDSTR+ ' WHERE KAYIT_NO=' + CAST(@OLDKAYIT_NO AS VARCHAR) " +
"\n EXEC(@STOPUPDSTR) " +
"\n SET @OLDKAYIT_NO = @KAYIT_NO2 " +
"\n SET @STOPUPDSTR = '' " +
"\n END " +
"\n END " +
"\n " +
"\n CLOSE ycursor " +
"\n DEALLOCATE ycursor " +
"\n " +
"\n IF @STOPUPDSTR <> '' " +
"\n BEGIN " +
"\n SET @STOPUPDSTR = 'UPDATE {0} SET SIRA_NO = SIRA_NO' + @STOPUPDSTR+ ' WHERE KAYIT_NO=' + CAST(@KAYIT_NO2 AS VARCHAR) + ' ' " +
"\n EXEC(@STOPUPDSTR) " +
"\n SET @STOPUPDSTR = '' " +
"\n END " +
"\n " +
"\nselect * from {0} " +
"\n ";
sSQL = string.Format(sSQL,
"#541SEdit",
"#tmp",
"",
MWOC.GFTNM("T541SYCarii"),
"ycursor",
MWOC.GFTNM("T541SYCari"),
MWOC.GFTNM("T541SY")
);
MWOC.WriteSQLToTmp("T541SSelect", sSQL);
dsData.SelectCommand = sSQL;
}
}
}