コード例 #1
0
        private void setData()
        {
            cPerson_group oPerson_group = new cPerson_group();
            DataSet       ds = new DataSet();
            string        strMessage = string.Empty, strCriteria = string.Empty;
            string        strperson_group_code = string.Empty,
                          strperson_group_name = string.Empty,
                          strC_active          = string.Empty,
                          strCreatedBy         = string.Empty,
                          strUpdatedBy         = string.Empty,
                          strCreatedDate       = string.Empty,
                          strUpdatedDate       = string.Empty;

            try
            {
                strCriteria = " and person_group_code = '" + ViewState["person_group_code"].ToString() + "' ";
                if (!oPerson_group.SP_PERSON_GROUP_SEL(strCriteria, ref ds, ref strMessage))
                {
                    lblError.Text = strMessage;
                }
                else
                {
                    if (ds.Tables[0].Rows.Count > 0)
                    {
                        #region get Data
                        strperson_group_code = ds.Tables[0].Rows[0]["person_group_code"].ToString();
                        strperson_group_name = ds.Tables[0].Rows[0]["person_group_name"].ToString();
                        strC_active          = ds.Tables[0].Rows[0]["c_active"].ToString();
                        strCreatedBy         = ds.Tables[0].Rows[0]["c_created_by"].ToString();
                        strUpdatedBy         = ds.Tables[0].Rows[0]["c_updated_by"].ToString();
                        strCreatedDate       = ds.Tables[0].Rows[0]["d_created_date"].ToString();
                        strUpdatedDate       = ds.Tables[0].Rows[0]["d_updated_date"].ToString();
                        #endregion

                        #region set Control
                        txtperson_group_code.Text = strperson_group_code;
                        txtperson_group_name.Text = strperson_group_name;
                        if (strC_active.Equals("Y"))
                        {
                            txtperson_group_name.ReadOnly = false;
                            txtperson_group_name.CssClass = "textbox";
                            chkStatus.Checked             = true;
                        }
                        else
                        {
                            txtperson_group_name.ReadOnly = true;
                            txtperson_group_name.CssClass = "textboxdis";
                            chkStatus.Checked             = false;
                        }
                        txtUpdatedBy.Text   = strUpdatedBy;
                        txtUpdatedDate.Text = strUpdatedDate;
                        #endregion
                    }
                }
            }
            catch (Exception ex)
            {
                lblError.Text = ex.Message.ToString();
            }
        }
コード例 #2
0
ファイル: item_lov.aspx.cs プロジェクト: mrlongth/Work_003
        private void InitcboPerson_group()
        {
            cPerson_group oPerson_group        = new cPerson_group();
            string        strMessage           = string.Empty,
                          strCriteria          = string.Empty,
                          strperson_group_code = string.Empty;

            strperson_group_code = ViewState["person_group_code"].ToString();
            int       i;
            DataSet   ds = new DataSet();
            DataTable dt = new DataTable();

            strCriteria  = " and c_active='Y' ";
            strCriteria += " and person_group_code IN (" + PersonGroupList + ") ";
            if (oPerson_group.SP_PERSON_GROUP_SEL(strCriteria, ref ds, ref strMessage))
            {
                dt = ds.Tables[0];
                cboPerson_group.Items.Clear();
                cboPerson_group.Items.Add(new ListItem("---- เลือกข้อมูลทั้งหมด ----", ""));
                for (i = 0; i <= dt.Rows.Count - 1; i++)
                {
                    cboPerson_group.Items.Add(new ListItem(dt.Rows[i]["person_group_name"].ToString(), dt.Rows[i]["person_group_code"].ToString()));
                }
                if (cboPerson_group.Items.FindByValue(strperson_group_code) != null)
                {
                    cboPerson_group.SelectedIndex = -1;
                    cboPerson_group.Items.FindByValue(strperson_group_code).Selected = true;
                }
            }
        }
コード例 #3
0
        private void BindGridView2()
        {
            cPerson_group oPerson_group = new cPerson_group();
            DataSet       ds            = new DataSet();
            string        strMessage    = string.Empty;
            string        strCriteria   = string.Empty;
            string        strActive     = string.Empty;

            strCriteria = strCriteria + "  And  (c_active ='Y') ";
            try
            {
                if (!oPerson_group.SP_PERSON_GROUP_SEL(strCriteria, ref ds, ref strMessage))
                {
                    lblError.Text = strMessage;
                }
                else
                {
                    GridView2.DataSource = ds.Tables[0];
                    GridView2.DataBind();
                }
            }
            catch (Exception ex)
            {
                lblError.Text = ex.Message.ToString();
            }
            finally
            {
                oPerson_group.Dispose();
                ds.Dispose();
            }
        }
コード例 #4
0
        private void BindGridView()
        {
            cPerson_group oPerson_group        = new cPerson_group();
            DataSet       ds                   = new DataSet();
            string        strMessage           = string.Empty;
            string        strCriteria          = string.Empty;
            string        strperson_group_code = string.Empty;
            string        strperson_group_name = string.Empty;
            string        strScript            = string.Empty;

            strperson_group_code = txtperson_group_code.Text.Replace("'", "''").Trim();
            strperson_group_name = txtperson_group_name.Text.Replace("'", "''").Trim();
            if (!strperson_group_code.Equals(""))
            {
                strCriteria = strCriteria + "  And  (person_group_code like '%" + strperson_group_code + "%') ";
            }
            if (!strperson_group_name.Equals(""))
            {
                strCriteria = strCriteria + "  And  (person_group_name like '%" + strperson_group_name + "%')";
            }
            strCriteria = strCriteria + "  And  (c_active ='Y') ";
            try
            {
                if (oPerson_group.SP_PERSON_GROUP_SEL(strCriteria, ref ds, ref strMessage))
                {
                    if (ds.Tables[0].Rows.Count == 1)
                    {
                        strperson_group_code = ds.Tables[0].Rows[0]["person_group_code"].ToString();
                        strperson_group_name = ds.Tables[0].Rows[0]["person_group_name"].ToString();
                        strScript            = "self.opener.document.forms[0].elements('" + ViewState["ctrl1"].ToString() + "').value='" + strperson_group_code + "';\n " +
                                               "self.opener.document.forms[0].elements('" + ViewState["ctrl2"].ToString() + "').value='" + strperson_group_name + "';\n" +
                                               "self.close(); \n";
                        ScriptManager.RegisterStartupScript(Page, Page.GetType(), "close", strScript, true);
                    }
                    else
                    {
                        ds.Tables[0].DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"];
                        GridView1.DataSource          = ds.Tables[0];
                        GridView1.DataBind();
                    }
                }
                else
                {
                    lblError.Text = strMessage;
                }
            }
            catch (Exception ex)
            {
                lblError.Text = ex.Message.ToString();
            }
            finally
            {
                oPerson_group.Dispose();
                ds.Dispose();
            }
        }
コード例 #5
0
        protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            string        strMessage           = string.Empty;
            string        strCheck             = string.Empty;
            string        strScript            = string.Empty;
            string        strUpdatedBy         = Session["username"].ToString();
            Label         lblperson_group_code = (Label)GridView1.Rows[e.RowIndex].FindControl("lblperson_group_code");
            cPerson_group oPerson_group        = new cPerson_group();

            try
            {
                if (!oPerson_group.SP_PERSON_GROUP_DEL(lblperson_group_code.Text, "N", strUpdatedBy, ref strMessage))
                {
                    if (strMessage.Contains("REFERENCE constraint"))
                    {
                        MsgBox("ไม่สามารถลบข้อมูลได้เนื่องจากมีการนำไปใช้ในระบบแล้ว");
                    }
                    else
                    {
                        lblError.Text = strMessage;
                    }
                }
            }
            catch (Exception ex)
            {
                if (ex.Message.Contains("REFERENCE constraint"))
                {
                    MsgBox("ไม่สามารถลบข้อมูลได้เนื่องจากมีการนำไปใช้ในระบบแล้ว");
                }
                else
                {
                    lblError.Text = ex.Message.ToString();
                }
            }
            finally
            {
                oPerson_group.Dispose();
            }
            BindGridView(0);
        }
コード例 #6
0
        private void BindGridView(int nPageNo)
        {
            cPerson_group oPerson_group        = new cPerson_group();
            DataSet       ds                   = new DataSet();
            string        strMessage           = string.Empty;
            string        strCriteria          = string.Empty;
            string        strperson_group_code = string.Empty;
            string        strperson_group_name = string.Empty;
            string        strActive            = string.Empty;

            strperson_group_code = txtperson_group_code.Text.Replace("'", "''").Trim();
            strperson_group_name = txtperson_group_name.Text.Replace("'", "''").Trim();
            if (!strperson_group_code.Equals("0"))
            {
                strCriteria = strCriteria + "  And  (person_group_code like '%" + strperson_group_code + "%') ";
            }
            if (!strperson_group_name.Equals("0"))
            {
                strCriteria = strCriteria + "  And  (person_group_name like '%" + strperson_group_name + "%')";
            }
            if (RadioActive.Checked)
            {
                strCriteria = strCriteria + "  And  (c_active ='Y') ";
            }
            else if (RadioCancel.Checked)
            {
                strCriteria = strCriteria + "  And  (c_active ='N') ";
            }
            try
            {
                if (!oPerson_group.SP_PERSON_GROUP_SEL(strCriteria, ref ds, ref strMessage))
                {
                    lblError.Text = strMessage;
                }
                else
                {
                    try
                    {
                        GridView1.PageIndex           = nPageNo;
                        txthTotalRecord.Value         = ds.Tables[0].Rows.Count.ToString();
                        ds.Tables[0].DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"];
                        GridView1.DataSource          = ds.Tables[0];
                        GridView1.DataBind();
                    }
                    catch
                    {
                        GridView1.PageIndex           = 0;
                        txthTotalRecord.Value         = ds.Tables[0].Rows.Count.ToString();
                        ds.Tables[0].DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"];
                        GridView1.DataSource          = ds.Tables[0];
                        GridView1.DataBind();
                    }
                }
            }
            catch (Exception ex)
            {
                lblError.Text = ex.Message.ToString();
            }
            finally
            {
                oPerson_group.Dispose();
                ds.Dispose();
                if (GridView1.Rows.Count > 0)
                {
                    GridView1.TopPagerRow.Visible = true;
                }
            }
        }
コード例 #7
0
        private bool saveData()
        {
            bool   blnResult            = false;
            bool   blnDup               = false;
            string strMessage           = string.Empty;
            string strperson_group_code = string.Empty,
                   strperson_group_name = string.Empty,
                   strActive            = string.Empty,
                   strCreatedBy         = string.Empty,
                   strUpdatedBy         = string.Empty;
            string        strScript     = string.Empty;
            cPerson_group oPerson_group = new cPerson_group();
            DataSet       ds            = new DataSet();

            try
            {
                #region set Data
                strperson_group_code = txtperson_group_code.Text.Trim();
                strperson_group_name = txtperson_group_name.Text;
                if (chkStatus.Checked == true)
                {
                    strActive = "Y";
                }
                else
                {
                    strActive = "N";
                }
                strCreatedBy = Session["username"].ToString();
                strUpdatedBy = Session["username"].ToString();
                #endregion
                if (ViewState["mode"].ToString().ToLower().Equals("edit"))
                {
                    #region edit
                    if (!blnDup)
                    {
                        if (oPerson_group.SP_PERSON_GROUP_UPD(strperson_group_code, strperson_group_name, strActive, strUpdatedBy, ref strMessage))
                        {
                            blnResult = true;
                        }
                        else
                        {
                            lblError.Text = strMessage.ToString();
                        }
                    }
                    else
                    {
                        ScriptManager.RegisterStartupScript(Page, Page.GetType(), "frMainPage", strScript, true);
                    }
                    #endregion
                }
                else
                {
                    #region check dup
                    string strCheckDup = string.Empty;
                    strCheckDup = " and person_group_code = '" + strperson_group_code.Trim() + "' ";
                    if (!oPerson_group.SP_PERSON_GROUP_SEL(strCheckDup, ref ds, ref strMessage))
                    {
                        lblError.Text = strMessage;
                    }
                    else
                    {
                        if (ds.Tables[0].Rows.Count > 0)
                        {
                            strScript =
                                "alert(\"ไม่สามารถเพิ่มข้อมูล เนื่องจากข้อมูล " + strperson_group_code.Trim() + " : " + strperson_group_name.Trim() + "  ซ้ำ\");\n";
                            blnDup = true;
                        }
                    }
                    #endregion
                    #region insert
                    if (!blnDup)
                    {
                        if (oPerson_group.SP_PERSON_GROUP_INS(strperson_group_code, strperson_group_name, strActive, strCreatedBy, ref strMessage))
                        {
                            ViewState["person_group_code"] = strperson_group_code;
                            blnResult = true;
                        }
                        else
                        {
                            lblError.Text = strMessage.ToString();
                        }
                    }
                    else
                    {
                        ScriptManager.RegisterStartupScript(Page, Page.GetType(), "frMainPage", strScript, true);
                    }
                    #endregion
                }
            }
            catch (Exception ex)
            {
                lblError.Text = ex.Message.ToString();
            }
            finally
            {
                oPerson_group.Dispose();
            }
            return(blnResult);
        }