예제 #1
0
    protected void gv_QueryLock_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        try
        {
            if (e.CommandName == "Delte_VDS_CAA_CONTROL_CHK")
            {
                #region 傳入參數

                BCO.CAACommon CAAComm = new BCO.CAACommon();

                ParameterList.Clear();
                ParameterList.Add(CAAComm.GetValueSetParameter(Session["UID"].ToString(), "string", false));//登入人員

                #endregion

                #region 連結資料庫

                BCO.RecordingCloseLockInfo bco = new BCO.RecordingCloseLockInfo(ConntionDB);
                bco.DELETE_LOCK_DATA(null, ParameterList);

                #endregion

                #region 如果解除成功

                this.gv_QueryLock.DataSource = null;
                this.gv_QueryLock.DataBind();
                this.ErrorMsgLabel.Text = "解除成功";

                #endregion
            }
        }
        catch (Exception ex)
        {
            WaringLogProcess(ex.Message);
            this.ErrorMsgLabel.Text = ex.Message;
        }
    }
예제 #2
0
    /// <summary>
    /// 頁籤=月結 BUTTON [人工折讓月結解除]鈕
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void but_TAB4_Open_Click(object sender, EventArgs e)
    {
        try
        {
            #region 檢查條件

            BCO.CAACommon CAAComm = new BCO.CAACommon();
            ArrayList arl_Check_Condition = Check_Condition("TAB 月結");

            #region 如果檢查有誤,則Return

            if (arl_Check_Condition[1].ToString() != string.Empty)
            {
                #region 錯誤訊息

                this.ErrorMsgLabel.Text = arl_Check_Condition[1].ToString();

                #endregion

                #region Focus欄位

                if (arl_Check_Condition[0].ToString() != string.Empty)
                {
                    string s_ScriptManager_Script = CAAComm.ToMakeUp_SetFocus_Script(arl_Check_Condition[0].ToString(), true);
                    ScriptManager.RegisterStartupScript(this.up_Msg, typeof(UpdatePanel), "CAA181", s_ScriptManager_Script, true);
                }

                #endregion

                return;
            }

            #endregion

            #endregion

            #region 傳入參數

            string s_Now = DateTime.Now.ToString();

            ParameterList.Clear();
            ParameterList.Add(CAAComm.GetValueSetParameter("CAA18", "string", false));//月結功能代碼
            ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_4_CLOSE_MONTH.Text, "string", false));//月結年月
            ParameterList.Add(CAAComm.GetValueSetParameter(Session["UID"].ToString(), "string", false));//更新人員
            ParameterList.Add(CAAComm.GetValueSetParameter(s_Now, "datetime", false));//更新日期

            #endregion

            #region 連結資料庫

            BCO.RecordingCloseLockInfo bco = new BCO.RecordingCloseLockInfo(ConntionDB);
            ArrayList ary_Result = bco.RecordingByOpen(ParameterList, null, ConntionDB);

            #endregion

            #region 檢查回傳資料

            this.ErrorMsgLabel.Text = ary_Result[1].ToString();

            #endregion
        }
        catch (Exception ex)
        {
            WaringLogProcess(ex.Message);
            this.ErrorMsgLabel.Text = ex.Message;
        }
        finally { Finally_Function(); }
    }
예제 #3
0
    /// <summary>
    /// Button [解除]鈕
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void but_Query_Lock_Click(object sender, EventArgs e)
    {
        try
        {
            #region 傳入參數

            BCO.CAACommon CAAComm = new BCO.CAACommon();

            ParameterList.Clear();
            ParameterList.Add(CAAComm.GetValueSetParameter(Session["UID"].ToString(), "string", false));//登入人員

            #endregion

            #region 連結資料庫

            DataTable dt_Return = new DataTable();

            BCO.RecordingCloseLockInfo bco = new BCO.RecordingCloseLockInfo(ConntionDB);
            dt_Return = bco.QUERY_LOCK_DATA(ParameterList);

            #endregion

            #region 資料與GridView繫結

            this.gv_QueryLock.DataSource = dt_Return;
            this.gv_QueryLock.PageIndex = 0;
            this.gv_QueryLock.DataBind();

            #endregion

            #region 檢查回傳資料

            if (dt_Return.Rows.Count == 0)
            { this.ErrorMsgLabel.Text = "查無資料"; }

            #endregion
        }
        catch (Exception ex)
        {
            WaringLogProcess(ex.Message);
            this.ErrorMsgLabel.Text = ex.Message;
        }
    }
예제 #4
0
    /// <summary>
    /// Button [查詢]鈕
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void but_Query_Click(object sender, EventArgs e)
    {
        try
        {
            #region 檢查條件

            BCO.CAACommon CAAComm = new BCO.CAACommon();
            ArrayList arl_Check_Condition = Check_Condition();

            #region 如果檢查有誤,則Return

            if (arl_Check_Condition[1].ToString() != string.Empty)
            {
                #region 錯誤訊息

                this.ErrorMsgLabel.Text = arl_Check_Condition[1].ToString();

                #endregion

                #region 設定GridView

                this.gv_QueryResult.DataSource = null;
                this.gv_QueryResult.DataBind();

                #endregion

                #region Focus欄位

                if (arl_Check_Condition[0].ToString() != string.Empty)
                {
                    string s_ScriptManager_Script = CAAComm.ToMakeUp_SetFocus_Script(arl_Check_Condition[0].ToString(), true);
                    ScriptManager.RegisterStartupScript(this.up_Msg, typeof(UpdatePanel), "CAA281", s_ScriptManager_Script, true);
                }

                #endregion

                return;
            }

            #endregion

            #endregion

            #region 傳入參數

            #region 處理時間Between欄位要傳給DataBase的值

            string s_UPDATEDATE_B = string.Empty;
            string s_UPDATEDATE_E = string.Empty;

            if (this.slp_UPDATEDATE.StartDate == string.Empty)
            { s_UPDATEDATE_B = string.Empty; }
            else
            { s_UPDATEDATE_B = this.slp_UPDATEDATE.StartDate + " 00:00:00"; }

            if (this.slp_UPDATEDATE.EndDate == string.Empty)
            { s_UPDATEDATE_E = string.Empty; }
            else
            { s_UPDATEDATE_E = this.slp_UPDATEDATE.EndDate + " 23:59:59"; }

            #endregion

            ParameterList.Clear();
            ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_FUNC_NO_B.Text, "string", false));//[功能號]起
            ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_FUNC_NO_E.Text, "string", false));//[功能號]迄
            ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_MONTH_CLOSE_B.Text, "string", false));//[月結月份]起
            ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_MONTH_CLOSE_E.Text, "string", false));//[月結月份]迄
            ParameterList.Add(CAAComm.GetValueSetParameter(s_UPDATEDATE_B, "datetime", false));//[維護日期]起
            ParameterList.Add(CAAComm.GetValueSetParameter(s_UPDATEDATE_E, "datetime", false));//[維護日期]迄
            ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_UPDATEUID.Text, "string", this.chb_LikeSearch.Checked));//[維護人員]
            ParameterList.Add(CAAComm.GetValueSetParameter((this.txt_RowCountLimit.Text == string.Empty) ? "100" : (int.Parse(this.txt_RowCountLimit.Text) < 0) ? "100" : this.txt_RowCountLimit.Text, "int", false));//[筆數]
            ParameterList.Add(CAAComm.GetValueSetParameter(Session["UID"].ToString(), "string", false));

            #endregion

            #region 連結資料庫

            DataTable dt_Return = new DataTable();

            BCO.RecordingCloseLockInfo bco = new BCO.RecordingCloseLockInfo(ConntionDB);
            dt_Return = bco.QueryMonClosebyLike(ParameterList);

            #endregion

            #region 資料與GridView繫結

            //抓取本頁初次登記的時間
            string SessionIDName = "CAA281_" + PageTimeStamp.Value;

            Session["SessionID"] = SessionIDName;
            Session[SessionIDName] = dt_Return;
            this.gv_QueryResult.DataSource = dt_Return;
            this.gv_QueryResult.PageSize = (this.txt_Pagesize.Text == string.Empty) ? 20 : (int.Parse(this.txt_Pagesize.Text) < 0) ? 20 : int.Parse(this.txt_Pagesize.Text);
            this.gv_QueryResult.PageIndex = 0;
            this.gv_QueryResult.DataBind();

            #endregion

            #region 檢查回傳資料

            if (dt_Return.Rows.Count == 0)
            { this.ErrorMsgLabel.Text = "查無資料"; }

            #endregion
        }
        catch (Exception ex)
        {
            WaringLogProcess(ex.Message);
            this.ErrorMsgLabel.Text = ex.Message;
        }
    }
예제 #5
0
    /// <summary>
    /// 頁籤=月結處理 BUTTON 月結
    /// </summary>
    protected void btn_Close_Click(object sender, EventArgs e)
    {
        try
        {
            #region 檢查條件

            BCO.CAACommon CAAComm = new BCO.CAACommon();
            ArrayList arl_Check_Condition = Check_Condition("頁籤=月結處理");

            #region 如果檢查有誤,則Return

            if (arl_Check_Condition[1].ToString() != string.Empty)
            {
                #region 錯誤訊息

                this.ErrorMsgLabel.Text = arl_Check_Condition[1].ToString();

                #endregion

                #region Focus欄位

                if (arl_Check_Condition[0].ToString() != string.Empty)
                {
                    string s_ScriptManager_Script = CAAComm.ToMakeUp_SetFocus_Script(arl_Check_Condition[0].ToString(), true);
                    ScriptManager.RegisterStartupScript(this.up_Msg, typeof(UpdatePanel), "CAA121", s_ScriptManager_Script, true);
                }

                #endregion

                return;
            }

            #endregion

            #endregion

            #region 傳入參數

            string s_Now = DateTime.Now.ToString();

            ParameterList.Clear();
            ParameterList.Add(CAAComm.GetValueSetParameter("CAA12", "string", false)); //V_FUNC_NO
            ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_YearMonth.Text, "string", false)); //V_MONTH_CLOSE
            ParameterList.Add(CAAComm.GetValueSetParameter(Session["UID"].ToString(), "string", false)); //V_CREATEUID
            ParameterList.Add(CAAComm.GetValueSetParameter(s_Now, "datetime", false)); //D_CREATEDATE
            ParameterList.Add(CAAComm.GetValueSetParameter(Session["UID"].ToString(), "string", false)); //V_UPDATEUID
            ParameterList.Add(CAAComm.GetValueSetParameter(s_Now, "datetime", false)); //D_UPDATEDATE

            #endregion

            #region 連結資料庫

            BCO.RecordingCloseLockInfo bco = new BCO.RecordingCloseLockInfo(ConntionDB);
            ArrayList ary_Result = bco.RecordingByClose(ParameterList, null, ConntionDB);

            #endregion

            #region 檢查回傳資料

            this.ErrorMsgLabel.Text = ary_Result[1].ToString();

            #endregion
        }
        catch (Exception ex)
        {
            WaringLogProcess(ex.Message);
            this.ErrorMsgLabel.Text = ex.Message;
        }
    }
예제 #6
0
    private string Exec_UnCloseMonth(string strYearMonth)
    {

        CAAModel.RecordingCloseLockInfo BCO = new CAAModel.RecordingCloseLockInfo(ConntionDB);

        ParameterList.Clear();
        ParameterList.Add("CAA11");
        ParameterList.Add(strYearMonth);
        ParameterList.Add(Session["UID"].ToString());
        ParameterList.Add(DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"));

        ArrayList arr = BCO.RecordingByOpen(ParameterList, null, ConntionDB);

        ScriptManager.RegisterClientScriptBlock(this, this.GetType(), Guid.NewGuid().ToString(), "alert('" + arr[1].ToString() + "');", true);
        return arr[0].ToString();
    }
예제 #7
0
    /// <summary>
    /// Button 解除月結動作
    /// </summary>
    protected void btnOpen_Click(object sender, EventArgs e)
    {
        if (this.slp_YearMonth1.Text.Trim() != "")
        {
            try
            {
                CAAModel.RecordingCloseLockInfo BCO = new CAAModel.RecordingCloseLockInfo(ConntionDB);

                string strNowDate = DateTime.Now.ToString();

                CAAModel.CAACommon CAAComm = new CAAModel.CAACommon();

                ParameterList.Clear();
                ParameterList.Add(CAAComm.GetValueSetParameter("CAA15", "string", false)); //V_FUNC_NO
                ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_YearMonth1.Text.Trim(), "string", false)); //V_MONTH_CLOSE
                ParameterList.Add(CAAComm.GetValueSetParameter(Session["UID"].ToString(), "string", false)); //V_UPDATEUID
                ParameterList.Add(CAAComm.GetValueSetParameter(strNowDate, "datetime", false)); //D_UPDATEDATE
                ParameterList.Add(CAAComm.GetValueSetParameter(Session["UID"].ToString(), "string", false)); //V_UPDATEUID
                ParameterList.Add(CAAComm.GetValueSetParameter(strNowDate, "datetime", false)); //D_UPDATEDATE

                ArrayList ary = BCO.InvoiceByOpen(ParameterList, null, ConntionDB);

                this.ErrorMsgLabel.Text = ary[1].ToString();
            }
            catch (Exception ex)
            {
                WaringLogProcess(ex.Message);
                this.ErrorMsgLabel.Text = ex.Message;
            }
        }
        else
        { this.ErrorMsgLabel.Text = "月結月份不可為空值!"; }
    }