Пример #1
0
    /// <summary>
    /// 繫結資料到控制項
    /// </summary>
    /// <param name="vdb"></param>
    private void QueryData()
    {
        #region

        string SessionIDName = string.Format("{0}_{1}", PAGE_DT_01, PageTimeStamp.Value);
        TRNModel.VDS_TRN10_BCO BCO = new TRNModel.VDS_TRN10_BCO(ConnectionDB);

        DataTable dt = null;

        dt = BCO.QUERY_TRN_CODE_MAIN(GetQueryParams());

        Session[SessionIDName] = dt;
        Int32 iRowCount = 0;
        aryParamsPKey.Clear();


        GridView1.DataSource = dt;
        GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) <= 0) ? 10 : int.Parse(TextBoxPagesize.Text);
        GridView1.PageIndex = 0;
        GridView1.DataBind();

        if (dt != null && dt.Rows.Count > 0)
        {
            iRowCount = dt.Rows.Count;

            foreach (DataRow dr in dt.Rows)
            {
                #region
                aryParamsPKey.Add(dr["ID"].ToString());
                #endregion
            }
        }
        else
        {
            ErrorMsgLabel.Text = "查無資料";
        }


        Session[string.Format("{0}_{1}", strPreFixed, PageTimeStamp.Value)] = aryParamsPKey;

        LabelQueryRecordCount.Text = string.Format(" {0} Rows ", iRowCount);

        #endregion
    }
Пример #2
0
    }//btn_Save_Click

    protected void btn_Delete_Click(object sender, EventArgs e)
    {
        #region
        try
        {
            #region
            if (txt_CODE.Text != "")
            {
                #region
                bool bResult = false;
                string strErrMsg = "";
                TRNModel.VDS_TRN10_BCO BCO = new TRNModel.VDS_TRN10_BCO(ConnectionDB);
                bResult = BCO.DEL_TRN_CODE_MAIN(GetQueryParams(), null, out strErrMsg);
              
                if (bResult)
                {
                    ErrorMsgLabel.Text = "刪除成功";
                    string strJS = string.Format("alert('刪除成功');location.replace('TRN101.aspx?Code=TRN10&PageTimeStamp={0}');", PageTimeStamp.Value);
                    ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "DELETE_OK", strJS, true);
                }
                else
                {
                    ErrorMsgLabel.Text = "刪除失敗:" + strErrMsg;             
                }
                #endregion
            }
            else
            {
                ErrorMsgLabel.Text = "請輸入代碼";
            }
            #endregion
        }
        catch (Exception ex)
        {
            ErrorMsgLabel.Text = ex.Message;
        }
        #endregion
    }//btn_Delete_Click
Пример #3
0
    /// <summary>
    /// 繫結資料到控制項
    /// </summary>
    /// <param name="vdb"></param>
    private void QueryData()
    {
        #region
        try
        {
            txt_CODE.Text = "";
            txt_NAME.Text = "";
            txt_EXPLAIN.Text = "";

            TRNModel.VDS_TRN10_BCO BCO = new TRNModel.VDS_TRN10_BCO(ConnectionDB);
            DataTable dt = null;
            ArrayList ParameterList = new ArrayList();
            ParameterList.Add(s_ID);
            dt = BCO.QUERY_TRN_CODE_MAIN_BY_ID(ParameterList);

            if (dt != null && dt.Rows.Count > 0)
            {
                txt_CODE.Text = dt.Rows[0]["CODE"].ToString().Trim();
                txt_NAME.Text = dt.Rows[0]["NAME"].ToString().Trim();
                txt_EXPLAIN.Text = dt.Rows[0]["EXPLAIN"].ToString().Trim();
            }
            else
            {
                ErrorMsgLabel.Text = "查無資料或原始資料已被刪除";
            }
        }
        catch (Exception ex)
        {
            ErrorMsgLabel.Text = ex.Message;
        }
        #endregion
    }
Пример #4
0
    protected void btn_Save_Click(object sender, EventArgs e)
    {
        #region
        try
        {
            #region
            if (txt_CODE.Text != "")
            {
                if (CurrentPageMode == PageCurrentMode.Insert)
                {
                    #region
                    TRNModel.VDS_TRN10_BCO BCO = new TRNModel.VDS_TRN10_BCO(ConnectionDB);
                    string strID = "", strErrMsg = "";
                    bool bResult = false;
                    bResult = BCO.ADD_TRN_CODE_MAIN(GetQueryParams(), null, out strID, out strErrMsg);

                    if (bResult && strErrMsg == "")
                    {
                        ArrayList aryTmp = new ArrayList();
                        aryTmp.Clear();
                        aryTmp.Add(strID);
                        aryParamsPKey = aryTmp;
                        s_ID = strID;

                        CurrentPageMode = PageCurrentMode.Readonly;
                        SetControlsByCurrentPageMode();

                        ErrorMsgLabel.Text = "新增成功";

                    }
                    else
                    {
                        ErrorMsgLabel.Text = strErrMsg;
                    }
                    #endregion
                }
                else if (CurrentPageMode == PageCurrentMode.Edit)
                {
                    #region
                    TRNModel.VDS_TRN10_BCO BCO = new TRNModel.VDS_TRN10_BCO(ConnectionDB);
                    string strID = "", strErrMsg = "";
                    bool bResult = false;
                    bResult = BCO.UPDATE_TRN_CODE_MAIN(GetQueryParams(), null, out strErrMsg);

                    if (bResult && strErrMsg == "")
                    {
                        CurrentPageMode = PageCurrentMode.Readonly;
                        SetControlsByCurrentPageMode();
                        ErrorMsgLabel.Text = "更新成功";
                    }
                    else
                    {
                        ErrorMsgLabel.Text = strErrMsg;
                    }
                    #endregion
                }
            }
            else
            {
                ErrorMsgLabel.Text = "請輸入代碼";
            }
            #endregion
        }
        catch (Exception ex)
        {
            ErrorMsgLabel.Text = ex.Message;
            UpdatePanel1.Update();
        }
        #endregion
    }//btn_Save_Click
Пример #5
0
    public static string GetCategoryNameAtServer(string str_CATEGORY)
    {
        #region
        string strResult = "";
        try
        {
            string strPID = "", strCategory_Name = "";
            TRNModel.VDS_TRN10_BCO BCO = new TRNModel.VDS_TRN10_BCO(ConnectionDB);
            DataTable dt = null;

            ArrayList ParameterList = new ArrayList();
            ParameterList.Clear();
            ParameterList.Add(str_CATEGORY);
            ParameterList.Add(null);
            ParameterList.Add(1);
            dt = BCO.QUERY_TRN_CODE_MAIN(ParameterList);

            /*
                m.ID, m.code, m.NAME, m.createdate, m.createuid, m.updatedate,
                m.updateuid, m.ENABLE, m.EXPLAIN             
             */

            if (dt != null && dt.Rows.Count > 0)
            {
                strPID = dt.Rows[0][0].ToString();
                strCategory_Name = dt.Rows[0][2].ToString();
            }
            else
            {
                strCategory_Name = "查無資料";
            }

            strResult = string.Format("{0}||{1}||{2}", strPID, str_CATEGORY, strCategory_Name);
        }
        catch (Exception ex)
        {
            throw ex;
        }
        return strResult;
        #endregion
    }