private void BindDDL() { SystemFunction.ListYearsDESC(ddlYear, "", "en-US", "th-TH", short.Parse(System.Configuration.ConfigurationSettings.AppSettings["startYear"].ToString())); SystemFunction.BindDropdownPageSize(ddlPageSize, null); ddlGroupIndicator.DataSource = db.mTIndicator.OrderBy(o => o.nOrder).ToList(); ddlGroupIndicator.DataValueField = "ID"; ddlGroupIndicator.DataTextField = "Indicator"; ddlGroupIndicator.DataBind(); ddlGroupIndicator.Items.Insert(0, new ListItem("- Select Indicator -", "")); int[] arrWFStatus = new int[] { 28, 29, 30, 32, 33, 34 }; ddlStatus.DataSource = db.TStatus_Workflow.Where(w => arrWFStatus.Contains(w.nStatustID) && w.cTypeUse == "TNF" && w.cActive == "Y").OrderBy(o => o.sShorttStatus).ToList(); ddlStatus.DataValueField = "nStatustID"; ddlStatus.DataTextField = "sShorttStatus"; ddlStatus.DataBind(); ddlStatus.Items.Insert(0, new ListItem("- Select Status -", "")); ddlStatus.Items.Insert(1, new ListItem("Waiting Transfer", "0")); ddlFacility.DataSource = (from fptt in db.mTFacility.Where(w => w.cDel == "N" && w.cActive == "Y" && w.nLevel == 0 && w.CompanyID == 1) from fgc in db.mTFacility.Where(w => w.cDel == "N" && w.cActive == "Y" && w.nHeaderID == fptt.ID) select new { fgc.ID, fgc.Name }).OrderBy(o => o.Name).ToList(); ddlFacility.DataTextField = "Name"; ddlFacility.DataValueField = "ID"; ddlFacility.DataBind(); ddlFacility.Items.Insert(0, new ListItem("- Select Facility -", "")); }
protected void Page_Load(object sender, EventArgs e) { string sIN = Request.QueryString["in"] + ""; string sOT = Request.QueryString["ot"] + ""; if (!string.IsNullOrEmpty(sIN)) { hdfsIndicator.Value = STCrypt.Decrypt(sIN); } if (!string.IsNullOrEmpty(sOT)) { hdfsOperationType.Value = STCrypt.Decrypt(sOT); } SystemFunction.ListYearsDESC(ddlYear, "-select-", "en-US", "th-TH", short.Parse(ConfigurationSettings.AppSettings["startYear"].ToString())); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string sIN = Request.QueryString["in"] + ""; // Indicator; string sOT = Request.QueryString["ot"] + ""; // OperationType; string year = Request.QueryString["year"] + ""; // Year ; string fac = Request.QueryString["fac"] + ""; // Facility; string status = Request.QueryString["status"] + ""; //Status Approve with edit content if (!string.IsNullOrEmpty(sIN)) { hdfsIndicator.Value = STCrypt.Decrypt(sIN); } if (!string.IsNullOrEmpty(sOT)) { hdfsOperationType.Value = STCrypt.Decrypt(sOT); } if (!string.IsNullOrEmpty(fac)) { hdfsFacility.Value = STCrypt.Decrypt(fac); } if (!string.IsNullOrEmpty(year)) { hdfsYear.Value = STCrypt.Decrypt(year); } if (!string.IsNullOrEmpty(status)) { hdfsStatus.Value = STCrypt.Decrypt(status); } if (!UserAcc.UserExpired()) { hdfIsAdmin.Value = SystemFunction.IsSuperAdmin() == true ? "Y" : "N"; } SystemFunction.ListYearsDESC(ddlYear, "-select-", "en-US", "th-TH", short.Parse(ConfigurationSettings.AppSettings["startYear"].ToString())); } }
public void BindDDL() { SystemFunction.ListYearsDESC(ddlYear, "", "en-US", "th-TH", short.Parse(System.Configuration.ConfigurationSettings.AppSettings["startYear"].ToString())); int[] arrStatusID = new int[] { }; string sqlFac = ""; int nRole = UserAcc.GetObjUser().nRoleID; int nUserID = UserAcc.GetObjUser().nUserID; if (nRole == 3) // L1 { arrStatusID = new int[] { 1 }; sqlFac = @"SELECT B.ID 'nFacID',B.Name 'sFacName' FROM mTWorkFlow A INNER JOIN mTfacility B ON A.IDFac=B.ID WHERE A.L1=" + nUserID + @" AND B.cDel='N' AND B.cActive='Y' AND B.nLevel=2 GROUP BY B.ID,B.Name ORDER BY B.Name"; } else if (nRole == 4) // L2 { arrStatusID = new int[] { 4, 2 }; //5, 9 sqlFac = @"SELECT B.ID 'nFacID',B.Name 'sFacName' FROM mTWorkFlow A INNER JOIN mTfacility B ON A.IDFac=B.ID WHERE A.L2=" + nUserID + @" AND B.cDel='N' AND B.cActive='Y' AND B.nLevel=2 GROUP BY B.ID,B.Name ORDER BY B.Name"; } else if (nRole == 2) // L0 { arrStatusID = new int[] { 0, 8, 9, 24, 18 }; //0, 8, 9, 24, 18 sqlFac = @"SELECT B.ID 'nFacID',B.Name 'sFacName' FROM mTUser_FacilityPermission A INNER JOIN mTfacility B ON A.nFacilityID=B.ID WHERE A.nUserID=" + nUserID + @"AND A.nRoleID=2 AND A.nPermission IN (2) AND B.cDel='N' AND B.cActive='Y' AND B.nLevel=2 GROUP BY B.ID,B.Name ORDER BY B.Name"; } ddlGroupIndicator.DataSource = db.mTIndicator.OrderBy(o => o.nOrder).ToList(); ddlGroupIndicator.DataValueField = "ID"; ddlGroupIndicator.DataTextField = "Indicator"; ddlGroupIndicator.DataBind(); ddlGroupIndicator.Items.Insert(0, new ListItem("- Select Indicator -", "")); ddlStatus.DataSource = db.TStatus_Workflow.Where(w => arrStatusID.Contains(w.nStatustID)).OrderBy(o => o.sStatusName).ToList(); ddlStatus.DataValueField = "nStatustID"; ddlStatus.DataTextField = "sStatusName"; ddlStatus.DataBind(); ddlStatus.Items.Insert(0, new ListItem("- Select Status -", "")); if (nRole == 2) { ddlStatus.Items.Insert(1, new ListItem("No Action", "-1")); } SystemFunction.ListDBToDropDownList(ddlFacility, sqlFac, "- Select Sub-facility -", "nFacID", "sFacName"); }