get Dynimic gridpane's value from code behid

  1. #1

    get Dynimic gridpane's value from code behid

    Click image for larger version. 

Name:	Dynimic gui.PNG 
Views:	11 
Size:	29.7 KB 
ID:	7191I Create all contrls in code behid ,How can I get values of the gridpanle

    private void SftCreateGui1(string strPageUrl,Page pgCtrl, List<SftGuiStruMain> lstSftGuiM, List<SftGuiStruDetail> lstSftGuiD,Ext.Net.Panel ctrlPanelMain,string strUserNum)
    {
    try
    {
    int nGuiAreCounts = 0, nGuiAreaNum = 0, nRedAreNum = 0, nFirstPosX = 0, nFirstPosY = 0, nCtrlHorDist = 0, nctrlVerDist = 0, nCtrlPoX = 0,nCtrlPoY =0,nCtrlHeightRow = 0;
    nGuiAreCounts = lstGuiMStru.Count;//界面区域数
    int nCtrlsRow = 0,nIfOthRow =0,nCtrlColumn = 0,nLastRowsCtrlX= 0,nCtrlAreNum = 0,nCtrlAreVerDis=0;
    int nCtrlCounts = lstSftGuiD.Count;
    if (nCtrlCounts == 0) return;
    sftGuiToolbar = new Ext.Net.Toolbar();
    sftGuiToolbar.ID = "gSoftToolBar";
    ctrlPanelMain.Layout = "absolute";
    ctrlPanelMain.X = 0;
    ctrlPanelMain.Y = 0;
    ctrlPanelMain.Width = 1600;
    ctrlPanelMain.Height = 1000;
    ctrlPanelMain.Border = false;
    ctrlPanelMain.BodyBorder = 0;
    ctrlPanelMain.Items.Add(sftGuiToolbar);
    nGuiAreaNum = lstSftGuiD[0]._nUidARN;//区域号
    nFirstPosX = lstGuiMStru[nRedAreNum]._nUimFCX;//第一控件的X坐标
    nFirstPosY = lstGuiMStru[nRedAreNum]._nUimFCY;//第一控件的Y坐标
    nctrlVerDist = lstGuiMStru[nRedAreNum]._nUimVDI;//控件间的垂直距离
    #region 开始创建控件
    for (int nCtrls = 0; nCtrls < nCtrlCounts; nCtrls++)
    {
    nIfOthRow = lstSftGuiD[nCtrls]._nUidOTL;//是否换另外一行
    int nCtrlType = lstGuiDStru[nCtrls]._nUidCTY;//控件类型
    nCtrlColumn = lstGuiDStru[nCtrls]._nUidCOL-1;//控件所在的列号
    nCtrlAreNum = lstGuiDStru[nCtrls]._nUidARN;//所在区域号
    if (nCtrlAreNum == 9)//是否交换区域,一定换行
    {
    nCtrlAreVerDis = lstGuiMStru[nRedAreNum]._nUimADI;//区域间的垂直间距
    }
    if(nCtrlsRow ==0)
    {
    nCtrlPoY = nFirstPosY+nctrlVerDist+16;
    }
    if (nIfOthRow == 1)//如果控制换行
    {
    nLastRowsCtrlX = nCtrlPoX;//一行最后一个控件的位置
    nCtrlsRow++;
    nCtrlPoX = nFirstPosX;
    nCtrlPoY = nCtrlPoY + nCtrlHeightRow + nctrlVerDist;
    if (nCtrlAreNum == 9)
    {
    nCtrlPoY += nCtrlAreVerDis;
    nCtrlAreVerDis = 0;
    }

    nCtrlHorDist = 0;
    }
    if (nCtrlColumn == 1)
    {
    nCtrlHorDist = lstGuiMStru[nRedAreNum]._nUimHDI;
    }
    else if(nCtrlColumn == 2)
    {
    nCtrlHorDist = lstGuiMStru[nRedAreNum]._nUimSHD ;
    }
    else if (nCtrlColumn == 3)
    {
    nCtrlHorDist = lstGuiMStru[nRedAreNum]._nUimHDI + lstGuiMStru[nRedAreNum]._nUimSHD + lstGuiMStru[nRedAreNum]._nUimTHD;
    }
    else if (nCtrlColumn == 9)//把控件放在最后列时,的X坐标
    {
    nCtrlPoX = nLastRowsCtrlX - lstSftGuiD[nCtrls - 1]._nUidTLW;
    }
    if (nCtrlType == 1)//控件类型Button
    {
    Ext.Net.ToolbarSeparator sftTblSeptor = new ToolbarSeparator();
    sftGuiToolbar.Items.Add(sftTblSeptor);
    Ext.Net.Button sftGuiBtn = new Ext.Net.Button();
    sftGuiBtn.ID = lstSftGuiD[nCtrls]._nUidFTY.ToString();
    sftGuiBtn.Text = lstSftGuiD[nCtrls]._strUidCDS;
    sftGuiBtn.StandOut = false ;//按钮凸出
    sftGuiBtn.DirectEvents.Click.Event += btnCreate_DirectClick;
    sftGuiBtn.DirectEvents.Click.Timeout = 900000000;
    sftGuiBtn.X = nCtrlPoX;
    sftGuiBtn.Y = nCtrlPoY;

    if(lstSftGuiD[nCtrls]._nUidFTY ==1 || lstSftGuiD[nCtrls]._nUidFTY ==11)
    {
    sftGuiBtn.Icon = Ext.Net.Icon.Add;
    }
    if (lstSftGuiD[nCtrls]._nUidFTY == 2 || lstSftGuiD[nCtrls]._nUidFTY == 12)
    {
    sftGuiBtn.Icon = Ext.Net.Icon.BasketEdit;
    }
    if (lstSftGuiD[nCtrls]._nUidFTY == 3)//删除
    {
    sftGuiBtn.Icon = Ext.Net.Icon.Cross;
    }
    if (lstSftGuiD[nCtrls]._nUidFTY == 4 )
    {
    sftGuiBtn.Icon = Ext.Net.Icon.PageSave;
    }
    if (lstSftGuiD[nCtrls]._nUidFTY == 7)
    {
    sftGuiBtn.Icon = Ext.Net.Icon.ZoomIn;
    }
    if (lstSftGuiD[nCtrls]._nUidFTY == 16)
    {
    sftGuiBtn.Icon = Ext.Net.Icon.Printer;
    }
    if (lstSftGuiD[nCtrls]._nUidFTY == 5)
    {
    sftGuiBtn.Icon = Ext.Net.Icon.DatabaseRefresh;
    }
    if (lstSftGuiD[nCtrls]._nUidFTY == 19)
    {
    sftGuiBtn.Icon = Ext.Net.Icon.UserHome;
    }

    sftGuiToolbar.Items.Add(sftGuiBtn);
    }
    else if (nCtrlType == 2)//控件类型Text
    {
    Ext.Net.Label sftLbl = new Ext.Net.Label();
    sftLbl.ID = "lbl" + lstSftGuiD[nCtrls]._strUidFNA.ToString();
    sftLbl.Width = lstSftGuiD[nCtrls]._nUidTLW;
    nCtrlPoX = nCtrlPoX + nCtrlHorDist;//计算控件位置X坐标的值
    sftLbl.X = nCtrlPoX ;
    sftLbl.Y = nCtrlPoY+3;
    sftLbl.Text = lstSftGuiD[nCtrls]._strUidCDS;
    ctrlPanelMain.Items.Add(sftLbl);
    nCtrlPoX += lstSftGuiD[nCtrls]._nUidTLW;//变换X坐标

    Ext.Net.TextField sftFldTxt = new TextField();
    sftFldTxt.ID = lstSftGuiD[nCtrls]._strUidFNA.ToString();
    sftFldTxt.Width = lstSftGuiD[nCtrls]._nUidCLW;
    sftFldTxt.Height = lstSftGuiD[nCtrls]._nUidCLH;
    if (nCtrlHeightRow == 0)
    {
    nCtrlHeightRow = lstSftGuiD[nCtrls]._nUidCLH;
    }
    else
    {
    if (nCtrlHeightRow < lstSftGuiD[nCtrls]._nUidCLH)
    {
    nCtrlHeightRow = lstSftGuiD[nCtrls]._nUidCLH;
    }
    }
    sftFldTxt.X = nCtrlPoX;
    sftFldTxt.Y = nCtrlPoY;
    int nBindEvent = lstSftGuiD[nCtrls]._nUidEVT;
    if (nBindEvent == 1)//绑定TextField控件事件
    {
    sftFldTxt.DirectEvents.Blur.Event += ctrlTextField_LostFocus;
    sftFldTxt.DirectEvents.Blur.Timeout = 900000000;
    }
    if (nBindEvent == 2)//绑定TextField控件事件
    {
    sftFldTxt.DirectEvents.Blur.Event += ctrlTextField_GetFocus;
    sftFldTxt.DirectEvents.Blur.Timeout = 900000000;
    }
    ctrlPanelMain.Items.Add(sftFldTxt);
    }
    else if (nCtrlType == 3)//控件类型Combox
    {
    Ext.Net.Label sftLbl = new Ext.Net.Label();
    sftLbl.ID = "lbl" + lstSftGuiD[nCtrls]._strUidFNA.ToString();
    sftLbl.Width = lstSftGuiD[nCtrls]._nUidTLW;
    nCtrlPoX = nCtrlPoX + nCtrlHorDist;//计算控件位置X坐标的值
    sftLbl.X = nCtrlPoX;
    sftLbl.Y = nCtrlPoY+3;
    sftLbl.Text = lstSftGuiD[nCtrls]._strUidCDS;
    ctrlPanelMain.Items.Add(sftLbl);//添加控件到Panelk中
    nCtrlPoX += lstSftGuiD[nCtrls]._nUidTLW;//变换X坐标

    Ext.Net.ComboBox ctrlComBox = new ComboBox();
    ctrlComBox.ID = lstSftGuiD[nCtrls]._strUidFNA.ToString();
    ctrlComBox.X = nCtrlPoX;
    ctrlComBox.Y = nCtrlPoY;
    ctrlComBox.Width = lstSftGuiD[nCtrls]._nUidCLW;
    ctrlComBox.Height = lstSftGuiD[nCtrls]._nUidCLH;
    int nBindEvent = lstSftGuiD[nCtrls]._nUidEVT;
    if (nBindEvent == 1)
    {
    ctrlComBox.DirectEvents.Blur.Event += ComBoxSelectChange;
    ctrlComBox.DirectEvents.Blur.Timeout = 90000000;
    }
    if (nBindEvent == 2)
    {
    ctrlComBox.DirectEvents.Focus.Event += ComBoxSelectChange;
    ctrlComBox.DirectEvents.Focus.Timeout = 90000000;
    }
    if (nBindEvent == 3)
    {
    ctrlComBox.DirectEvents.Select.Event += ComBoxSelectChange;
    ctrlComBox.DirectEvents.Select.Timeout = 90000000;
    }
    ctrlPanelMain.Items.Add(ctrlComBox);

    }
    else if (nCtrlType == 4 || nCtrlType == 5 || nCtrlType == 6 )//控件类型日期类型控件
    {
    Ext.Net.Label sftLbl = new Ext.Net.Label();
    sftLbl.ID = "lbl" + lstSftGuiD[nCtrls]._strUidFNA.ToString();
    sftLbl.Width = lstSftGuiD[nCtrls]._nUidTLW;
    nCtrlPoX = nCtrlPoX + nCtrlHorDist;//计算控件位置X坐标的值
    sftLbl.X = nCtrlPoX;
    sftLbl.Y = nCtrlPoY+3;
    sftLbl.Text = lstSftGuiD[nCtrls]._strUidCDS;
    ctrlPanelMain.Items.Add(sftLbl);
    nCtrlPoX += lstSftGuiD[nCtrls]._nUidTLW;//变换X坐标

    Ext.Net.DateField sftDate = new DateField();
    sftDate.ID = lstSftGuiD[nCtrls]._strUidFNA.ToString();
    sftDate.X = nCtrlPoX;
    sftDate.Y = nCtrlPoY;
    sftDate.Width = lstSftGuiD[nCtrls]._nUidCLW;
    sftDate.Height = lstSftGuiD[nCtrls]._nUidCLH;
    if (nCtrlType == 4)//年月日
    {
    sftDate.Format = "yyyyMMdd";
    }
    if (nCtrlType == 5)//年月
    {
    sftDate.Format = "yyyyMM";
    }
    if (nCtrlType == 6)//年
    {
    sftDate.Format = "yyyy";
    }
    ctrlPanelMain.Items.Add(sftDate);
    }
    else if (lstGuiDStru[nCtrls]._nUidCTY == 7)//控件类型TextArea
    {
    Ext.Net.Label sftLbl = new Ext.Net.Label();
    sftLbl.ID = "lbl" + lstSftGuiD[nCtrls]._strUidFNA.ToString();
    sftLbl.Width = lstSftGuiD[nCtrls]._nUidTLW;
    nCtrlPoX = nCtrlPoX + nCtrlHorDist;//计算控件位置X坐标的值
    sftLbl.X = nCtrlPoX;
    sftLbl.Y = nCtrlPoY + 3;
    sftLbl.Text = lstSftGuiD[nCtrls]._strUidCDS;
    ctrlPanelMain.Items.Add(sftLbl);
    nCtrlPoX += lstSftGuiD[nCtrls]._nUidTLW;//变换X坐标

    Ext.Net.TextArea sftTxtArea = new TextArea();
    sftTxtArea.ID = lstSftGuiD[nCtrls]._strUidFNA.ToString();
    sftTxtArea.X = nCtrlPoX;
    sftTxtArea.Y = nCtrlPoY;
    sftTxtArea.Width = lstSftGuiD[nCtrls]._nUidCLW;
    sftTxtArea.Height = lstSftGuiD[nCtrls]._nUidCLH;
    if (nCtrlHeightRow == 0)
    {
    nCtrlHeightRow = lstSftGuiD[nCtrls]._nUidCLH;
    }
    else
    {
    if (nCtrlHeightRow < lstSftGuiD[nCtrls]._nUidCLH)
    {
    nCtrlHeightRow = lstSftGuiD[nCtrls]._nUidCLH;
    }
    }
    ctrlPanelMain.Items.Add(sftTxtArea);
    }
    else if (lstGuiDStru[nCtrls]._nUidCTY == 9)//图片控件
    {
    Ext.Net.Image sftImage = new Image();
    sftImage.ID = lstSftGuiD[nCtrls]._strUidFNA.ToString();
    sftImage.X = nCtrlPoX;
    sftImage.Y = nCtrlPoY;
    sftImage.Width = lstSftGuiD[nCtrls]._nUidCLW;
    sftImage.Height = lstSftGuiD[nCtrls]._nUidCLH;
    ctrlPanelMain.Items.Add(sftImage);
    nCtrlPoX = nCtrlPoX + nCtrlHorDist;//计算控件位置X坐标的值
    }

    }
    #endregion 开始创建控件
    ////===创建列表控件并做初始化====Start()====/////
    Ext.Net.Store gSoftMainStore = new Store();
    gSoftMainStore.ID = "gSoftMainStore";
    Ext.Net.GridPanel gSoftGridPanel = new GridPanel();
    gSoftGridPanel.ID ="gSoftGridPanel";
    Ext.Net.CheckboxSelectionModel gSoftSelectMode = new CheckboxSelectionModel();
    gSoftSelectMode.ID = "gSoftSelectMode";
    gSoftSelectMode.Mode = SelectionMode.Single;
    gSoftGridPanel.SelectionModel.Add(gSoftSelectMode) ;
    gSoftGridPanel.DirectEvents.CellClick.Event += gSoftGridPanel_DirectClick;
    gSoftGridPanel.DirectEvents.CellClick.Timeout = 900000000;
    Ext.Net.Parameter gSoftExtraParams = new Ext.Net.Parameter ()
    {
    Name="Values",
    Value = "Ext.encode(#{gSoftGridPanel}.getRowsValues({selec tedOnly:true}))",
    Mode = ParameterMode.Value
    };
    gSoftGridPanel.DirectEvents.CellClick.ExtraParams. Add(gSoftExtraParams);

    gSoftGridPanel.Y = nCtrlPoY +50;
    gSoftGridPanel.Width = 1200;
    gSoftGridPanel.Height = 500;
    gSoftGridPanel.Store.Add(gSoftMainStore);
    ctrlPanelMain.Items.Add(gSoftGridPanel);
    SoftComDataManager softDataMan = new SoftComDataManager ();
    softDataMan.SoftGetListDataset(strPageUrl, "SFTDB", "", gSoftGridPanel, gSoftMainStore, strUserNum);

    public bool SoftGetListDataset(string strUrlId, string strBussDbNam, string strWhere, Ext.Net.GridPanel GridPanelMain, Ext.Net.Store StoreMain, string strUserId)
    {
    DataSet dsCom = null;
    List<gSoftGuiManager.sftListStru> lstStru = new List<gSoftGuiManager.sftListStru>();
    try
    {
    string strUrl = strUrlId.Substring(strUrlId.LastIndexOf("/") + 1);
    if (strUrlId.IndexOf("?") != -1)
    {
    strUrl = strUrl.Substring(0, strUrl.LastIndexOf("?"));
    }
    #region 构造列表的数据sql
    string strTableName = "", strInitListSql = "", strLstAreNum = "", strOrderBy = "";//数据表名

    strComSql = "select * from SFTUIM where UIMURL='" + strUrl + "' and UIMLST ='1'";
    dsCom = DbSQLOperator.Query(strComSql);
    if (dsCom.Tables[0].Rows.Count != 1) return false;

    strTableName = dsCom.Tables[0].Rows[0]["UIMDTN"].ToString();//表名
    strLstAreNum = dsCom.Tables[0].Rows[0]["UIMAUN"].ToString();//区号
    strOrderBy = dsCom.Tables[0].Rows[0]["UIMDOL"].ToString();//数据排序字段集合
    if (strTableName.IndexOf(".DBO.") != -1)
    {
    strTableName = strBussDbNam + strTableName;
    }
    DataSet dsTemp = null;
    strComSql = "select * from SFTRGD where UIDURL='" + strUrl + "' and UIDUSN ='" + strUserId + "' and UIDARN='" + strLstAreNum + "' and UIDLSI=1 order by UIDORD";
    dsTemp = DbSQLOperator.Query(strComSql);
    int nRows = dsTemp.Tables[0].Rows.Count;
    if (nRows == 0)
    {
    strComSql = "select * from SFTUID where UIDURL='" + strUrl + "' and UIDARN='" + strLstAreNum + "' and UIDLSI=1 order by UIDORD";
    dsTemp = DbSQLOperator.Query(strComSql);
    nRows = dsTemp.Tables[0].Rows.Count;
    }
    for (int nRow = 0; nRow < nRows; nRow++)
    {
    string strFieldName = dsTemp.Tables[0].Rows[nRow]["UIDFNA"].ToString();
    string strListTitle = dsTemp.Tables[0].Rows[nRow]["UIDCDS"].ToString();
    int nListWidth = int.Parse(dsTemp.Tables[0].Rows[nRow]["UIDCWH"].ToString());
    string strIsKey = dsTemp.Tables[0].Rows[nRow]["UIDKEY"].ToString();
    string strEdit = dsTemp.Tables[0].Rows[nRow]["UIDEDT"].ToString();
    if (string.IsNullOrEmpty(strEdit))
    {
    strEdit = "0";
    }
    string strLocked = dsTemp.Tables[0].Rows[nRow]["UIDLCK"].ToString();
    if (string.IsNullOrEmpty(strLocked))
    {
    strLocked = "0";
    }
    if (nRow == 0)
    {
    strInitListSql = strFieldName;
    }
    else
    {
    strInitListSql += "," + strFieldName;
    }
    gSoftGuiManager.sftListStru lstStrue = new gSoftGuiManager.sftListStru(strFieldName, strListTitle, nListWidth, strIsKey, int.Parse(strEdit), int.Parse(strLocked));
    lstStru.Add(lstStrue);

    }
    if (string.IsNullOrEmpty(strWhere))
    {
    strInitListSql = "select top(200) " + strInitListSql + " from " + strTableName;
    }
    else
    {
    strInitListSql = "select " + strInitListSql + " from " + strTableName;
    }

    if (!string.IsNullOrEmpty(strWhere))
    {
    strInitListSql += " where " + strWhere;
    }
    string strRightWhere = SoftMakeUserDataGradeRight(strUrl, strUserId);//构造数据条件
    if (!string.IsNullOrEmpty(strRightWhere))
    {
    if (strInitListSql.IndexOf("where") > -1)
    {
    strInitListSql += " and " + strRightWhere;
    }
    else
    {
    strInitListSql += " where " + strRightWhere;
    }
    }
    if (!string.IsNullOrEmpty(strOrderBy))
    {
    strInitListSql += " order by " + strOrderBy;
    }
    #endregion 构造列表数据Sql

    #region 初始化数据列表
    Ext.Net.Model gSoftModel = new Model();
    StoreMain.Model.Add(gSoftModel);
    if (StoreMain.Model[0].Fields.Count == 0)
    {
    ModelField ModeField;
    int nColmns = lstStru.Count;
    if (nColmns <= 0) return false;

    for (int nColmn = 0; nColmn < nColmns; nColmn++)
    {
    ModeField = new ModelField();
    StoreMain.Model[0].Fields.Add(ModeField);
    StoreMain.Model[0].Fields[nColmn].Name = lstStru[nColmn]._strFieldName;
    GridPanelMain.ColumnModel.Columns.Add(new ColumnBase[] {
    new Column
    {
    Text = lstStru[nColmn]._strColumnTitle,
    DataIndex =lstStru[nColmn]._strFieldName,
    Width = lstStru[nColmn]._nWidth,

    }

    });

    /*if (lstStru[nColmn]._nEdit == 1)
    {
    Ext.Net.TextField txtFld = new TextField();
    column.SetEditor(txtFld);
    column.Editor.Add(txtFld);
    }
    if (lstStru[nColmn]._nLocked == 1)//set Locked Column
    {
    column.Sortable = false;
    column.Locked = true;
    }
    GridPanelMain.ColumnModel.Columns.Add(column);
    }*/
    }
    GridPanelMain.ColumnLines = true;


    }
    dsCom = DbSQLOperator.Query(strInitListSql);
    nRows = dsCom.Tables[0].Rows.Count;
    StoreMain.DataSource = dsCom;
    StoreMain.DataBind();
    Last edited by softlcx; Nov 10, 2013 at 12:47 AM.
  2. #2
    Hello!

    Welcome to our forum!

    At first, there are some rules about posting, please read the following threads:

    http://forums.ext.net/showthread.php?3440
    http://forums.ext.net/showthread.php?10205
    About your question, you can use getRowsValues method of the GridPanel:

    App.GridPanel1.getRowsValues()
  3. #3

    Gridpanel Without paging reload data from behind code ,click Query button ,can't reload data to the gridpanel

    <html>
    <head id="Head1" runat="server">
    <link href="../../../resources/Css/gSoft.css" rel="stylesheet" />
    <title></title>
    </head>
    <body>
    <form id="form1" runat="server">
    <ext:ResourceManager
    ID="ResourceManager1"
    runat="server"
    DirectMethodNamespace="CompanyX"
    CleanResourceUrl="false"
    />
    <ext:Window ID="WinLoadExec" runat="server"
    Hidden="true" Modal="true"
    CloseAction="Hide" Constrain="true"
    >

    <DirectEvents>
    <Hide OnEvent="onWinLoadExecClose" Timeout="90000000" />
    </DirectEvents>
    </ext:Window>

    <ext:Store ID="StoreMain"
    runat="server"
    Buffered="true"
    PageSize="100"
    OnReadData="Store_ReadData"
    >
    <Proxy>
    <ext:PageProxy>
    <Reader>
    <ext:JsonReader Root="data" />
    </Reader>
    </ext:PageProxy>
    </Proxy>

    <Model>
    <ext:Model runat="server">
    <Fields>
    <ext:ModelField Name="IASINU" />
    <ext:ModelField Name="IASINA" />
    <ext:ModelField Name="IASINS" />
    <ext:ModelField Name="IASIEA" />
    <ext:ModelField Name="IASSCD" />
    <ext:ModelField Name="IASIDE" />
    <ext:ModelField Name="IASSPM" />
    <ext:ModelField Name="IASRPS" />
    <ext:ModelField Name="IASBUA" />
    <ext:ModelField Name="IASITS" />
    <ext:ModelField Name="IASILS" />
    <ext:ModelField Name="IASPRS" />
    <ext:ModelField Name="IASLIA" />
    <ext:ModelField Name="IASCNS" />
    <ext:ModelField Name="IASUPI" />
    <ext:ModelField Name="IASICU" />
    <ext:ModelField Name="IASINW" />
    <ext:ModelField Name="IASIRW" />
    <ext:ModelField Name="IASPUP" />
    <ext:ModelField Name="IASSBI" />
    <ext:ModelField Name="IASSMI" />
    <ext:ModelField Name="IASCPS" />
    <ext:ModelField Name="IASCMU" />
    <ext:ModelField Name="IASPDS" />
    <ext:ModelField Name="IASSTS" />
    <ext:ModelField Name="IASFSR" />
    <ext:ModelField Name="IASQCN" />
    <ext:ModelField Name="IASIRS" />
    <ext:ModelField Name="IASISS" />
    <ext:ModelField Name="IASKIA" />
    <ext:ModelField Name="IASRFC" />
    <ext:ModelField Name="IASIFU" />
    </Fields>
    </ext:Model>
    </Model>
    </ext:Store>
    <menu>
    <ext:Menu ID="ContexMenu" runat="server" >
    <Defaults>
    <ext:Parameter Name="Width" Value="100" />
    <ext:Parameter Name="Scale" Value="large" />
    <ext:Parameter Name="Handler" Value="function(){#{DirectMethods}.ConMenu_Click(t his.id);}" Mode="Raw" />
    </Defaults>
    </ext:Menu>
    </menu>
    <ext:Viewport ID="ViewportMain" runat="server" Layout="absolute" AutoScroll="true" ContextMenuID="ContexMenu">
    <Items>
    <ext:Panel ID="TPanelChild" runat="server"
    Header="false"
    Border="false"
    Title="Query Panel"
    Padding="5"
    X="0"
    Y ="0"
    Height="560"
    BodyStyle="background:transparent;"
    >
    <TopBar>
    <ext:Toolbar ID="ToolbarTop" Flat ="true" runat="server">
    <Items>

    <ext:ToolbarSeparator ID="ToolbarSeparator3" runat="server" />
    <ext:Button ID="BtnQuery" runat="server" Text="Query" Icon="Zoom">
    <DirectEvents>
    <Click OnEvent="BtnQuery_Click " Timeout="90000000" >
    <EventMask ShowMask="true" Msg="Querying ..." />
    </Click>
    </DirectEvents>
    </ext:Button>

    <ext:ToolbarFill />
    <ext:Button ID="ButtonRefresh" runat="server" Text="Refresh" Icon="DatabaseRefresh" >
    <DirectEvents>
    <Click OnEvent="ButtonRefresh_Click" Timeout="90000000">

    </Click>
    </DirectEvents>
    </ext:Button>
    <ext:ToolbarSeparator ID="ToolbarSeparator6" runat="server" />
    <ext:Button ID="BtnClose" runat="server" Text="Close" Icon="DoorOut">
    <DirectEvents>
    <Click OnEvent="BtnClose_Click" Timeout="90000000" />

    </DirectEvents>
    </ext:Button>
    </Items>
    </ext:Toolbar>
    </TopBar>

    <Content>
    <table border="0" style="padding:10px; ">
    <tr>
    <td style="width:10px"/>
    <td style="width:100px; height:24px">
    <ext:Label ID="Label1" runat="server" Text="item's Number:" />
    </td>
    <td style="width:auto;">
    <ext:TextField ID ="IASINU" runat="server" Width = "120px" />
    </td>
    <td style="width:60px"/>
    <td style="width:100px;height:24px">
    <ext:Label ID="Label2" runat="server" Text="item's Name:" />
    </td>
    <td style="width:auto;">
    <ext:TextField ID ="IASINA" runat="server" Width = "280px" />
    </td>

    </tr>

    </table>
    </Content>
    </ext:Panel>
    <ext:GridPanel ID="GridPanelMain"
    runat="server"
    Closable="false"
    Layout="Fit"
    ColumnLines="true"
    StoreID ="StoreMain"
    AutoDataBind="true"
    X="0"
    Y ="130"
    Height="560"
    >
    <ColumnModel runat="server">
    <Columns>
    <ext:Column
    runat="server"
    Text="物料编ç*"
    DataIndex="IASINU"
    Width="80" />
    <ext:Column
    runat="server"
    Text="物料名称"
    DataIndex="IASINA"
    Width="260"
    Align="Left" />
    <ext:Column
    runat="server"
    Text="物料别名"
    DataIndex="IASINS"
    Width="80">
    </ext:Column>
    <ext:Column
    runat="server"
    Text="英文名称"
    DataIndex="IASIEA"
    Width="120">
    </ext:Column>
    <ext:Column
    runat="server"
    Text="简ç*"
    DataIndex="IASSCD"
    Width="60">
    </ext:Column>
    <ext:Column
    runat="server"
    Text="描述"
    DataIndex="IASIDE"
    Width="120">
    </ext:Column>
    <ext:Column
    runat="server"
    Text="规æ*¼åž‹å·"
    DataIndex="IASSPM"
    Width="80">
    </ext:Column>
    <ext:Column
    runat="server"
    Text="负责人"
    DataIndex="IASRPS"
    Width="80">
    </ext:Column>
    <ext:Column
    runat="server"
    Text="计量单位"
    DataIndex="IASBUA"
    Width="60">
    </ext:Column>
    <ext:Column
    runat="server"
    Text="物料类型"
    DataIndex="IASITS"
    Width="120">
    </ext:Column>
    <ext:Column
    runat="server"
    Text="物料类别"
    DataIndex="IASILS"
    Width="130">
    </ext:Column>
    <ext:Column
    runat="server"
    Text="产品组"
    DataIndex="IASPRS"
    Width="80">
    </ext:Column>
    <ext:Column
    runat="server"
    Text="产品系列"
    DataIndex="IASLIA"
    Width="130">
    </ext:Column>
    <ext:Column
    runat="server"
    Text="来源ç*"
    DataIndex="IASCNS"
    Width="80">
    </ext:Column>
    <ext:Column
    runat="server"
    Text="IASUPI"
    DataIndex="库å*˜å•ä»·"
    Width="80">
    </ext:Column>
    <ext:Column
    runat="server"
    Text="体积"
    DataIndex="IASICU"
    Width="80">
    </ext:Column>
    <ext:Column
    runat="server"
    Text="净重"
    DataIndex="IASINW"
    Width="80">
    </ext:Column>
    <ext:Column
    runat="server"
    Text="毛重"
    DataIndex="IASIRW"
    Width="80">
    </ext:Column>
    <ext:Column
    runat="server"
    Text="采è´*ä»·"
    DataIndex="IASPUP"
    Width="80">
    </ext:Column>
    <ext:Column
    runat="server"
    Text="批发单价"
    DataIndex="IASSBI"
    Width="80">
    </ext:Column>
    <ext:Column
    runat="server"
    Text="会员价"
    DataIndex="IASSMI"
    Width="80">
    </ext:Column>
    <ext:Column
    runat="server"
    Text="计价方法"
    DataIndex="IASCPS"
    Width="80">
    </ext:Column>
    <ext:Column
    runat="server"
    Text="过期"
    DataIndex="IASCMU"
    Width="80">
    </ext:Column>
    <ext:Column
    runat="server"
    Text="保质期"
    DataIndex="IASPDS"
    Width="80">
    </ext:Column>
    <ext:Column
    runat="server"
    Text="IASSTS"
    DataIndex="状态"
    Width="60">
    </ext:Column>
    <ext:Column
    runat="server"
    Text="退货期"
    DataIndex="IASFSR"
    Width="60">
    </ext:Column>
    <ext:Column
    runat="server"
    Text="质检ç*"
    DataIndex="IASQCN"
    Width="50">
    </ext:Column>
    <ext:Column
    runat="server"
    Text="接收方法"
    DataIndex="IASIRS"
    Width="80">
    </ext:Column>
    <ext:Column
    runat="server"
    Text="销售物料"
    DataIndex="IASISS"
    Width="80">
    </ext:Column>
    <ext:Column
    runat="server"
    Text="虚拟物料"
    DataIndex="IASKIA"
    Width="80">
    </ext:Column>
    <ext:Column
    runat="server"
    Text="税率"
    DataIndex="IASRFC"
    Width="80">
    </ext:Column>
    <ext:Column
    runat="server"
    Text="使用状态"
    DataIndex="IASIFU"
    Width="80">
    </ext:Column>
    </Columns>
    </ColumnModel>
    <SelectionModel>
    <ext:CheckboxSelectionModel ID="CheckboxSelectionModel1" runat="server">

    </ext:CheckboxSelectionModel>
    </SelectionModel>
    </ext:GridPanel>

    </Items>
    </ext:Viewport>

    </form>
    </body>
    </html>

    namespace GSOFT.Main.ERP.SftCom
    {
    public partial class SftCom001899 : System.Web.UI.Page
    {
    gSoftGuiManager.SoftGuiCreate gSoftGui = new gSoftGuiManager.SoftGuiCreate();
    public string strWhere { get; set; }
    private static string strUrl { get; set; }
    private static List<string> lstKeyVal = new List<string>();
    private static List<SftKeyStru> lstKeyStru = new List<SftKeyStru>();
    private static List<SftKeyStru> LstMainKeysStru = new List<SftKeyStru>();
    private static int nKeyRs;

    private static int nDsRows { set; get; }
    private static DataSet dsSource { get; set; }
    SoftComDataManager gSftComDataMag = new SoftComDataManager();
    List<sftListStru> SftLstStru = new List<sftListStru>();
    protected void Page_Load(object sender, EventArgs e)
    {
    if (gSoftCommon.CheckPower.GetUserSession() != true) { return; }
    if (!X.IsAjaxRequest)
    {
    Session["OperateType"] = "1";
    nKeyRs = 0;
    strUrl = HttpContext.Current.Request.RawUrl.ToString();
    strUrl = strUrl.Substring(strUrl.LastIndexOf("/") + 1);
    if (strUrl.IndexOf("?") != -1)
    {
    strUrl = strUrl.Substring(0, strUrl.LastIndexOf("?"));
    }
    string strSeleRurl = strUrl.Replace(".aspx", "");
    gSoftGui.SftBindComboBoxData(strUrl, Session["DataBaseName"].ToString());
    SftInitList("");
    }
    }

    #region DataShow
    protected bool SftInitList(string strWhere)
    {
    try
    {
    string strComsql = "select * from SFTEDB.DBO.SCMIAS order by IASINU ";
    dsSource = DbSQLOperator.Query(strComsql);
    nDsRows = dsSource.Tables[0].Rows.Count;
    }

    catch (Exception er)
    {
    er.ToString();
    return false;
    }
    return true;

    }

    protected void Store_ReadData(object sender, StoreReadDataEventArgs e)
    {
    Store store = (Store)sender;
    List<SoftScmIas> data = new List<SoftScmIas>();

    int start = e.Start,
    limit = e.Limit;
    int nAddStepLength = limit;
    int nScrollSteps = nDsRows - start;
    if (nScrollSteps > limit)
    {
    nScrollSteps = limit;
    }

    for (int i = start + 1; i <= start + nScrollSteps - 1; i++)
    {
    SoftScmIas qoute = new SoftScmIas()
    {
    IASINU = dsSource.Tables[0].Rows[i]["IASINU"].ToString(),
    IASINA = dsSource.Tables[0].Rows[i]["IASINA"].ToString(),
    IASINS = dsSource.Tables[0].Rows[i]["IASINS"].ToString(),
    IASIEA = dsSource.Tables[0].Rows[i]["IASIEA"].ToString(),
    IASSCD = dsSource.Tables[0].Rows[i]["IASSCD"].ToString(),
    IASIDE = dsSource.Tables[0].Rows[i]["IASIDE"].ToString(),
    IASSPM = dsSource.Tables[0].Rows[i]["IASSPM"].ToString(),
    IASRPS = dsSource.Tables[0].Rows[i]["IASRPS"].ToString(),
    IASBUA = dsSource.Tables[0].Rows[i]["IASBUA"].ToString(),
    IASITS = dsSource.Tables[0].Rows[i]["IASITS"].ToString(),
    IASILS = dsSource.Tables[0].Rows[i]["IASILS"].ToString(),
    IASPRS = dsSource.Tables[0].Rows[i]["IASPRS"].ToString(),
    IASLIA = dsSource.Tables[0].Rows[i]["IASLIA"].ToString(),
    IASCNS = dsSource.Tables[0].Rows[i]["IASCNS"].ToString(),
    IASUPI = dsSource.Tables[0].Rows[i]["IASUPI"].ToString(),
    IASICU = dsSource.Tables[0].Rows[i]["IASICU"].ToString(),
    IASINW = dsSource.Tables[0].Rows[i]["IASINW"].ToString(),
    IASIRW = dsSource.Tables[0].Rows[i]["IASIRW"].ToString(),
    IASPUP = dsSource.Tables[0].Rows[i]["IASPUP"].ToString(),
    IASSBI = dsSource.Tables[0].Rows[i]["IASSBI"].ToString(),
    IASSMI = dsSource.Tables[0].Rows[i]["IASSMI"].ToString(),
    IASCPS = dsSource.Tables[0].Rows[i]["IASCPS"].ToString(),
    IASCMU = dsSource.Tables[0].Rows[i]["IASCMU"].ToString(),
    IASPDS = dsSource.Tables[0].Rows[i]["IASPDS"].ToString(),
    IASSTS = dsSource.Tables[0].Rows[i]["IASSTS"].ToString(),
    IASFSR = dsSource.Tables[0].Rows[i]["IASFSR"].ToString(),
    IASQCN = dsSource.Tables[0].Rows[i]["IASQCN"].ToString(),
    IASIRS = dsSource.Tables[0].Rows[i]["IASIRS"].ToString(),
    IASISS = dsSource.Tables[0].Rows[i]["IASISS"].ToString(),
    IASKIA = dsSource.Tables[0].Rows[i]["IASKIA"].ToString(),
    IASRFC = dsSource.Tables[0].Rows[i]["IASRFC"].ToString(),
    IASIFU = dsSource.Tables[0].Rows[i]["IASIFU"].ToString()
    };

    data.Add(qoute);
    }
    store.Data = data;
    e.Total = nDsRows;

    }

    protected void BtnQuery_Click(object sender, Ext.Net.DirectEventArgs e)
    {
    if (gSoftCommon.CheckPower.GetUserSession() != true) { return; }
    string strQueryValue = IASINA.Text.ToString();
    if(!string.IsNullOrEmpty(strQueryValue))
    {
    strWhere = " IASINA like '%" + strQueryValue + "%'";
    }

    dsSource = gSftComDataMag.SoftGetListDataset(strUrl, Session["DataBaseName"].ToString(), strWhere, Session["UserNum"].ToString().Trim());
    nDsRows = dsSource.Tables[0].Rows.Count;
    //StoreMain.Reload();
    }
    #endregion DataShow
    #region DataOperate

    protected void ButtonRefresh_Click(object sender, Ext.Net.DirectEventArgs e)
    {
    if (gSoftCommon.CheckPower.GetUserSession() != true) { return; }
    Session["QueryCondition"] = "";
    SftInitList("");

    }


    protected void BtnClose_Click(object sender, DirectEventArgs e)
    {
    //验证是否退出
    X.Js.AddScript("parentAutoLoadControl.close();");
    }
    #endregion DataOperate
    #region CloseWindows

    public void onWinLoadExecClose(object sender, Ext.Net.DirectEventArgs e)
    {
    SftInitList("");
    }
    #endregion CloseWindows


    }

    }
    Last edited by softlcx; Jun 27, 2017 at 12:09 AM.

Similar Threads

  1. Replies: 2
    Last Post: Feb 01, 2012, 6:56 AM
  2. [CLOSED] Tab navigation issue in Editable GridPane
    By leon_tang in forum 1.x Legacy Premium Help
    Replies: 1
    Last Post: Sep 19, 2011, 12:48 PM
  3. gridpane height not working.?
    By eldhose in forum 1.x Help
    Replies: 2
    Last Post: Feb 04, 2011, 7:24 PM
  4. [CLOSED] Remove method in Gridpane and Store
    By speedstepmem4 in forum 1.x Legacy Premium Help
    Replies: 1
    Last Post: Nov 23, 2010, 8:17 AM
  5. Problem about GridPane
    By ltzcltzc in forum 1.x Help
    Replies: 2
    Last Post: Jun 24, 2009, 6:07 AM

Posting Permissions