Esempio n. 1
0
        protected void BTN_Search(object sender, DirectEventArgs e)
        {
            DataSet ds = DIMERCO.SDK.Utilities.LSDK.getUserDataBYStationCodeNUser(TXTStation.Text.ToString(), TXTUserID.Text.Trim(), TXTUserName.Text.Trim());
            //SqlConnection cn = new SqlConnection("Data Source=10.130.40.20;Initial Catalog=ReSM;User ID=sa;Password=dim1rc0@");

            //string sql = "select UserID,fullname from  SMUser inner join SMstation on SMUser.stationid=SMstation.stationid where StationCode='" + TXTStation.Text + "'";
            //if(TXTUserID.Text.Trim()!="")
            //{
            //sql=sql+" and UserID='"+TXTUserID.Text.Trim()+"'";
            //}
            //if(TXTUserName.Text.Trim()!="")
            //{
            //    sql = sql + " and fullname like '%" + TXTUserName.Text.Trim() + "%'";
            //}
            //SqlDataAdapter da = new SqlDataAdapter(sql, cn);
            //DataSet ds = new DataSet();
            //da.Fill(ds);
            DataTable tb = ds.Tables[0];

            SVUser.DataSource = tb;
            SVUser.DataBind();
            ds.Dispose();
        }
Esempio n. 2
0
        protected void BTN_Search(object sender, DirectEventArgs e)
        {
            if (DLStation.Value == null)
            {
                X.Msg.Show(new MessageBoxConfig
                {
                    Title   = "Message",
                    Message = "Please select station",
                    Buttons = MessageBox.Button.OK,
                    Width   = 320,
                    Icon    = MessageBox.Icon.INFO
                });
            }
            else
            {
                DataSet ds = DIMERCO.SDK.Utilities.LSDK.getUserDataBYStationCodeNUser(DLStation.Value.ToString().ToString(), TXTUserID.Text.Trim(), TXTUserName.Text.Trim());
                // SqlConnection cn = new SqlConnection("Data Source=10.130.40.20;Initial Catalog=ReSM;User ID=sa;Password=dim1rc0@");
                //string sql="select UserID,fullname from  SMUser inner join SMstation on SMUser.stationid=SMstation.stationid where StationCode='"+DLStation.Value+"'";
                // if(TXTUserID.Text.Trim()!="")
                // {
                // sql=sql+" and UserID='"+TXTUserID.Text.Trim()+"'";
                // }
                // if(TXTUserName.Text.Trim()!="")
                // {
                //     sql = sql + " and fullname like '%" + TXTUserName.Text.Trim() + "%'";
                // }
                // SqlDataAdapter da = new SqlDataAdapter(sql, cn);
                // DataSet ds = new DataSet();
                // da.Fill(ds);
                DataTable tb = ds.Tables[0];

                DataSet   dss = dbs.GetSqlDataSet("select UserID,UserName,Stations,ModuleID from StationRole where station='" + DLStation.Value + "'");
                DataTable tb1 = dss.Tables[0];
                DataTable ttb = new DataTable();
                ttb.Columns.Add("UserID");
                ttb.Columns.Add("FullName");
                ttb.Columns.Add("station");
                ttb.Columns.Add("ModuleName");
                foreach (DataRow dr in tb.Rows)
                {
                    DataRow[] drn = tb1.Select("UserID='" + dr["UserID"].ToString() + "'");
                    if (drn.Length > 0)
                    {
                        DataRow newDr = ttb.NewRow();
                        newDr["UserID"]     = drn[0]["UserID"];
                        newDr["FullName"]   = drn[0]["UserName"];
                        newDr["station"]    = drn[0]["Stations"];
                        newDr["ModuleName"] = GetModuleName(drn[0]["ModuleID"].ToString());
                        ttb.Rows.Add(newDr);
                    }
                    else
                    {
                        DataRow newDr = ttb.NewRow();
                        newDr["UserID"]     = dr["UserID"];
                        newDr["FullName"]   = dr["fullname"];
                        newDr["station"]    = "";
                        newDr["ModuleName"] = "";
                        ttb.Rows.Add(newDr);
                    }
                }
                if (Session["TSQL"] != null && DLStation.Value == null)
                {
                    ttb = (DataTable)Session["TSQL"];
                }
                SVUser.DataSource = ttb;
                SVUser.DataBind();
                Session["TSQL"] = ttb;
                ds.Dispose();
            }
        }