Esempio n. 1
0
    private string ProcessConfirmFromBridge(string strStAcceptDate, string strDisNoForAry, string strCtrlPending, Int32 iProcessingAryIndex)
    {
        #region
        bool bResult = false, bResultCheck = false;
        string strCallbackResult = "";
        string strResult = "", strErrMsg = "", strErrMsgCheck = "";
        string strPrefixed = "POP_DisApproveError";
        string strDisNo = "", strNextDisNo = "";
        string strDIS_QTY = "";
        string[] strAryDisAry = strDisNoForAry.Split(";".ToCharArray());
        string[] strAryCtrlPending = strCtrlPending.Split(";".ToCharArray());

        try
        {
            fmStatus = FormStatus.fmProcess;

            ALOModel.MaintainDisRecord BCO = new ALOModel.MaintainDisRecord(ConnectionDB);
            if (iProcessingAryIndex < strAryDisAry.Length)
            {

                strDisNo = strAryDisAry[iProcessingAryIndex];

                ArrayList ParameterList = new ArrayList();//20091113

                //---------------------------------------------------------------------
                //2010/02/09 added:確認前檢核
                ALOModel.MaintainDisCRMRecord BCO3 = new ALOModel.MaintainDisCRMRecord(ConnectionDB);
                ParameterList.Clear();
                ParameterList.Add(strStAcceptDate);
                ParameterList.Add(strDisNo);
                try
                {
                    bResultCheck = BCO3.Pick_Control_Check(ParameterList, out strErrMsgCheck);
                }
                catch (Exception ex)
                {
                    throw ex;
                }

                //---------------------------------------------------------------------


                ParameterList.Clear();
                ParameterList.Add(strStAcceptDate);
                ParameterList.Add(strDisNo);
                ParameterList.Add("VDS_ALO_DIS_STORE");
                ParameterList.Add(strAryCtrlPending[5]);

                try
                {
                    bResult = BCO.ProcessConfirm(ParameterList, out strResult, out strErrMsg, null);
                }
                catch (Exception ex)
                {
                    throw ex;
                }


                if (!bResult)
                {
                    Session[string.Format("{0}_DISNO_{1}", strPrefixed, strAryCtrlPending[0])] += string.Format("{0},", strDisNo);
                    Session[string.Format("{0}_OPTYPE_{1}", strPrefixed, strAryCtrlPending[0])] = "1";
                    Session[string.Format("{0}_ERRMSG_{1}", strPrefixed, strAryCtrlPending[0])] += string.Format("配本序號:{0},{1}{2}{3};\r\n", strDisNo, strErrMsgCheck, bResultCheck ? "" : ",", strErrMsg);
                }
                else
                {
                    if (!bResultCheck)
                    {
                        Session[string.Format("{0}_ERRMSG_{1}", strPrefixed, strAryCtrlPending[0])] += string.Format("配本序號:{0},{1};\r\n", strDisNo, strErrMsgCheck);
                    }
                }


                ALOModel.ProcessMultiDisRecords BCO2 = new ALOModel.ProcessMultiDisRecords(ConnectionDB);
                DataTable dtTemp = BCO2.QueryDisItemForALO20(GetQueryParams(strStAcceptDate, strDisNo, bResult));
                if (dtTemp != null && dtTemp.Rows.Count > 0)
                    strDIS_QTY = dtTemp.Rows[0]["DIS_QTY"].ToString().Trim();

                iProcessingAryIndex = iProcessingAryIndex + 1;

                if (iProcessingAryIndex < strAryDisAry.Length)
                {
                    strNextDisNo = strAryDisAry[iProcessingAryIndex];
                }
                else
                {
                    strNextDisNo = "X";//表示已執行到最後一筆
                }

                //0:DIS_NO字串For陣列用-
                //1:下一筆陣列Index-
                //2:執行結果-
                //3:錯誤訊息-
                //4:要關閉執行狀態的DIS_NO-
                //5:要開啟執行狀態的DIS_NO-
                //6:是否有累積執行錯誤之DIS_NO-
                //7:ST_ACCEPT_DATE ClientID-
                //8:ResultMsgLabel ClientID-
                //9:ErrMsgLabel ClientID-
                //10:將再開啟之控制項字串陣列
                //11:DIS_QTY
                string strCtrlIDToUnLock = string.Format("{0}", strAryCtrlPending[1]);

                strCallbackResult = string.Format("{0}-{1}-{2}-{3}-{4}-{5}-{6}-{7}-{8}-{9}-{10}-{11}",
                    strDisNoForAry,
                    iProcessingAryIndex,
                    bResult ? "OK" : "NG",
                    Session[string.Format("{0}_ERRMSG_{1}", strPrefixed, strAryCtrlPending[0])].ToString(),//strErrMsg,
                    strDisNo,
                    strNextDisNo,
                    Session[string.Format("{0}_DISNO_{1}", strPrefixed, strAryCtrlPending[0])] == null ? "0" : "1",
                    strAryCtrlPending[2],
                    strAryCtrlPending[3],
                    strAryCtrlPending[4],
                    strCtrlIDToUnLock,
                    strDIS_QTY
                    );
            }

        }
        catch (Exception ex)
        {
            throw ex;
        }

        return strCallbackResult;
        #endregion
    }
Esempio n. 2
0
 private void MakeDataTableDisItem()
 {
     #region
     try
     {
         ALOModel.MaintainDisCRMRecord BCO = new ALOModel.MaintainDisCRMRecord(ConnectionDB);
         dtDisItem = BCO.GetDisCRMItemSchema();
     }
     catch (Exception ex)
     {
         ErrorMsgLabel.Text = ex.Message;
     }
     #endregion
 }
Esempio n. 3
0
    private void QueryData()
    {
        #region
        try
        {
            if (s_DIS_NO == "") return;

            //if (CurrentPageMode == PageCurrentMode.Insert || CurrentPageMode == PageCurrentMode.Edit)
            //{
            #region

            CheckCurrentIndexAndSwitchNavigator(s_DIS_NO);

            ALOModel.MaintainDisMain BCO1 = new ALOModel.MaintainDisMain(ConnectionDB);
            ArrayList ParameterList = new ArrayList();
            ParameterList.Clear();
            ParameterList.Add(s_DIS_NO == "" ? null : s_DIS_NO);
            dtDisMain = BCO1.QueryByDisNo(ParameterList);

            ALOModel.MaintainDisCRMRecord BCO2 = new ALOModel.MaintainDisCRMRecord(ConnectionDB);
            ParameterList.Clear();
            ParameterList.Add(s_DIS_NO == "" ? null : s_DIS_NO);
            dtDisItem = BCO2.QueryDisCRMItemByDisNo(ParameterList);
            dtDisItemOld = dtDisItem.Copy();

            DataColumn[] PrimaryKeys21 = new DataColumn[3];
            PrimaryKeys21[0] = dtDisItemOld.Columns["DIS_NO"];
            PrimaryKeys21[1] = dtDisItemOld.Columns["ITEM"];
            PrimaryKeys21[2] = dtDisItemOld.Columns["PERIOD"];
            dtDisItemOld.PrimaryKey = PrimaryKeys21;

            DataColumn[] PrimaryKeys22 = new DataColumn[3];
            PrimaryKeys22[0] = dtDisItem.Columns["DIS_NO"];
            PrimaryKeys22[1] = dtDisItem.Columns["ITEM"];
            PrimaryKeys22[2] = dtDisItem.Columns["PERIOD"];
            dtDisItem.PrimaryKey = PrimaryKeys22;


            ALOModel.MaintainDisStore BCO3 = new ALOModel.MaintainDisStore(ConnectionDB);
            ParameterList.Clear();
            ParameterList.Add(s_DIS_NO == "" ? null : s_DIS_NO);

            dtDisStoreAll = BCO3.QueryDisStoreByDisNo(ParameterList);
            dtDisStore = dtDisStoreAll.Copy();
            dtDisStoreAllOld = dtDisStoreAll.Copy();

            DataColumn[] PrimaryKeys31 = new DataColumn[1];
            PrimaryKeys31[0] = dtDisStoreAllOld.Columns["CODE"];
            dtDisStoreAllOld.PrimaryKey = PrimaryKeys31;

            DataColumn[] PrimaryKeys32 = new DataColumn[1];
            PrimaryKeys32[0] = dtDisStoreAll.Columns["CODE"];
            dtDisStoreAll.PrimaryKey = PrimaryKeys32;

            #region Binding Data
            txt_DisNo.Text = s_DIS_NO;
            if (dtDisMain != null && dtDisMain.Rows.Count > 0)
            {
                SLP_StoreChain1.Text = dtDisMain.Rows[0]["RCHAN_NO"].ToString();
                SLP_SLPDate1_DisDate.Text = dtDisMain.Rows[0]["DIS_DATE"].ToString();
                SLP_SLPDate2_StAcceptDate.Text = dtDisMain.Rows[0]["ST_ACCEPT_DATE"].ToString();
                SLP_SLPDate3_TransStAcceptDate.Text = dtDisMain.Rows[0]["TRANS_ST_ACCEPT_DATE"].ToString();
                SLP_SLPDate4_ApproveDate.Text = dtDisMain.Rows[0]["APPROVE_DATE"].ToString();
                SLP_EnumBase1.Text = dtDisMain.Rows[0]["DATA_SOURCE"].ToString();
                txt_POSourceNo.Text = dtDisMain.Rows[0]["PO_SOURCE_NO"].ToString();
            }
            else
            {
                CurrentPageMode = PageCurrentMode.Query;
                throw new Exception("查無此筆資料或已被其他使用者刪除,請點選上一筆/下一筆鈕或回查詢頁重新查詢!");
            }

            currentGvModeDisItem = CurrentGridviewMode.ReadOnly;

            gv_DisItem.DataSource = dtDisItem;
            gv_DisItem.DataBind();

            if (dtDisItem != null && dtDisItem.Rows.Count > 0)
            {
                s_ITEM = dtDisItem.Rows[0]["ITEM"].ToString().Trim(); ;
                s_PERIOD = dtDisItem.Rows[0]["PERIOD"].ToString().Trim(); ;
                s_ITEM_NAME = dtDisItem.Rows[0]["ITEM_NAME"].ToString().Trim(); ;
                s_PMA = dtDisItem.Rows[0]["PMA"].ToString().Trim(); ;
                s_ROOT_NO = dtDisItem.Rows[0]["ROOT_NO"].ToString().Trim(); ;
                s_PATTERN = dtDisItem.Rows[0]["PATTERN_NO"].ToString().Trim(); ;
            }

            string strFilter = string.Format(" ITEM='{0}' and PERIOD='{1}' ", s_ITEM, s_PERIOD);
            DataView dv = dtDisStoreAll.DefaultView;
            dv.RowFilter = strFilter;

            dtDisStore = dv.ToTable().Copy();

            currentGvModeDisStore = CurrentGridviewMode.ReadOnly;

            gv_DisStore.DataSource = dtDisStore;
            gv_DisStore.DataBind();


            CountGvDisStoreInfo();
            #endregion

            #endregion
            //}

            if (CurrentPageMode == PageCurrentMode.Readonly)
            {
                CheckConfirmOrRemove();
            }

        }
        catch (Exception ex)
        {
            ErrorMsgLabel.Text = ex.Message;
        }

        #endregion
    }
Esempio n. 4
0
    protected void btn_DeleteItemWithoutStock_Click(object sender, System.EventArgs e)
    {
        #region
        try
        {
            string strITEM = "", strPERIOD = "";
            Int32 i32Item = 0, i32Store = 0;
            if (dtDisItem != null && dtDisItem.Rows.Count > 0)
            {
                for (Int32 i = 0; i <= dtDisItem.Rows.Count - 1; i++)
                {
                    if (dtDisItem.Rows[i]["ONHD_QTY"].ToString() == "" || dtDisItem.Rows[i]["ONHD_QTY"].ToString() == "0")
                    {
                        #region 刪除配本品項明細
                        strITEM = dtDisItem.Rows[i]["ITEM"].ToString().Trim();
                        strPERIOD = dtDisItem.Rows[i]["PERIOD"].ToString().Trim();
                        dtDisItem.Rows.RemoveAt(i);
                        i32Item++;

                        #endregion

                        #region 刪除門市分配明細
                        if (dtDisStoreAll != null && dtDisStoreAll.Rows.Count > 0)
                        {
                            for (Int32 j = dtDisStoreAll.Rows.Count - 1; j >= 0; j--)
                            {
                                if (dtDisStoreAll.Rows[j].RowState != DataRowState.Deleted &&
                                    dtDisStoreAll.Rows[j]["ITEM"].ToString().Trim() == strITEM &&
                                    dtDisStoreAll.Rows[j]["PERIOD"].ToString().Trim() == strPERIOD)
                                {
                                    dtDisStoreAll.Rows.RemoveAt(j);
                                    i32Store++;
                                }
                            }
                        }
                        #endregion
                    }
                }

                #region 儲存異動

                if (i32Item != 0 && i32Store != 0)
                {
                    ALOModel.MaintainDisCRMRecord BCO = new ALOModel.MaintainDisCRMRecord(ConnectionDB);
                    bool bResult = BCO.UpdateDisCRMRecord(dtDisMain, dtDisItem, dtDisItemOld, dtDisStoreAll, dtDisStoreAllOld, s_DIS_NO, null);

                    if (bResult)
                    {
                        ResultMsgLabel.Text = string.Format("刪除成功,品項明細 {0} 筆、門市明細 {1} 筆。", i32Item, i32Store);
                        QueryData();
                    }
                    else
                        ResultMsgLabel.Text = "刪除失敗";
                }
                else
                {
                    ResultMsgLabel.Text = "無刪除資料";
                }
                #endregion


            }
            else 
            {
                ResultMsgLabel.Text = "無刪除資料";
            }
        }
        catch (Exception ex)
        {
            ErrorMsgLabel.Text = ex.Message;
        }

        #endregion
    }
Esempio n. 5
0
    protected void gv_DisItem_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        #region
        try
        {
            Int32 iRowIndex;
            Int32.TryParse(e.CommandArgument.ToString(), out iRowIndex);

            if (e.CommandName == "View")
            {

                s_ITEM = ((Label)gv_DisItem.Rows[iRowIndex].FindControl("lbl_ITEM")).Text;
                s_PERIOD = ((Label)gv_DisItem.Rows[iRowIndex].FindControl("lbl_PERIOD")).Text;

                string strFilter = string.Format(" ITEM='{0}' and PERIOD='{1}' ", s_ITEM, s_PERIOD);

                if (dtDisStoreAll != null)
                {
                    DataView dv = dtDisStoreAll.DefaultView;
                    dv.RowFilter = strFilter;
                    dtDisStore = dv.ToTable().Copy();
                    gv_DisStore.DataSource = dtDisStore;
                }

                gv_DisStore.DataBind();

                CountGvDisStoreInfo();

                if (CurrentPageMode != PageCurrentMode.Readonly)
                    SwitchGvAddNewBtn(true, true, true);
                else
                    SwitchGvAddNewBtn(false, false, false);

                if (ConfirmIsTrueAndRemoveIsFalse)
                {
                    btn_Confirm.Enabled = false;
                    btn_Remove.Enabled = true;
                    btn_Edit.Enabled = false;
                    btn_Delete.Enabled = false;
                }


                if (s_DIS_NO != "" && btn_Confirm.Enabled == false)
                {
                    ALOModel.MaintainDisCRMRecord BCO2 = new ALOModel.MaintainDisCRMRecord(ConnectionDB);
                    ParameterList.Clear();
                    ParameterList.Add(s_DIS_NO == "" ? null : s_DIS_NO);
                    DataTable dtTemp = BCO2.QueryDisCRMItemByDisNo(ParameterList);
                    if (dtTemp != null && dtTemp.Rows.Count > 0)
                    {
                        gv_DisItem.DataSource = dtTemp;
                        gv_DisItem.DataBind();
                    }
                }

            }
        }
        catch (Exception ex)
        {
            ErrorMsgLabel.Text = ex.Message;
        }
        #endregion
    }
Esempio n. 6
0
    protected void btn_Save_Click(object sender, EventArgs e)
    {
        #region
        try
        {
            ErrorMsgLabel.Text = "";
            ResultMsgLabel.Text = "";
            bool bResult = false;
            DateTime ProcessingDateTime = DateTime.Now;

            string strDisDate = SLP_SLPDate1_DisDate.Text;
            string strStAcceptDate = SLP_SLPDate2_StAcceptDate.Text;
            string strChanNo = SLP_StoreChain1.Text;
            string strPOSourceNo = txt_POSourceNo.Text.Trim();
            string strUserId = Session["UID"].ToString();
            string vDisNo;

            SetDisMain(strDisDate, strStAcceptDate, strChanNo, strPOSourceNo, strUserId, ProcessingDateTime);

            SetDisItem(strUserId, ProcessingDateTime);

            SetDisStoreAll(strUserId, ProcessingDateTime);

            if (CurrentPageMode == PageCurrentMode.Insert)
            {
                #region

                if (CheckPOsourceNoIsExisted())
                {
                    ALOModel.MaintainDisCRMRecord BCO = new ALOModel.MaintainDisCRMRecord(ConnectionDB);
                    bResult = BCO.CreateDisCRMRecord(dtDisMain, dtDisItem, dtDisStoreAll, out vDisNo, null);

                    s_DIS_NO = vDisNo;
                    txt_DisNo.Text = s_DIS_NO;

                    if (bResult)
                    {
                        ResultMsgLabel.Text = "新增成功";
                        CurrentPageMode = PageCurrentMode.Readonly;
                        QueryData();
                    }
                    else
                        ResultMsgLabel.Text = "新增失敗";
                }

                #endregion
            }
            else if (CurrentPageMode == PageCurrentMode.Edit)
            {
                #region

                ALOModel.MaintainDisCRMRecord BCO = new ALOModel.MaintainDisCRMRecord(ConnectionDB);
                bResult = BCO.UpdateDisCRMRecord(dtDisMain, dtDisItem, dtDisItemOld, dtDisStoreAll, dtDisStoreAllOld, s_DIS_NO, null);

                if (bResult)
                {
                    ResultMsgLabel.Text = "更新成功";
                    CurrentPageMode = PageCurrentMode.Readonly;
                    QueryData();
                }
                else
                    ResultMsgLabel.Text = "更新失敗";

                #endregion
            }
        }
        catch (Exception ex)
        {
            ErrorMsgLabel.Text = ex.Message;
        }
        #endregion
    }
Esempio n. 7
0
    protected void btn_Delete_Click(object sender, EventArgs e)
    {
        #region
        try
        {
            if (SLP_SLPDate4_ApproveDate.Text.Trim() == "")
            {
                bool bResult = false;
                ALOModel.MaintainDisCRMRecord BCO = new ALOModel.MaintainDisCRMRecord(ConnectionDB);

                DataTable dtTemp = dtDisMain;

                if (dtTemp != null && dtTemp.Rows.Count > 0)
                {
                    ArrayList ParameterList = new ArrayList();

                    ParameterList.Clear();
                    ParameterList.Add(dtTemp.Rows[0]["DIS_NO"]);
                    ParameterList.Add(dtTemp.Rows[0]["UPDATEUID"]);
                    ParameterList.Add(dtTemp.Rows[0]["UPDATEDATE"]);
                    ParameterList.Add(dtTemp.Rows[0]["DIS_DATE"]);
                    ParameterList.Add(dtTemp.Rows[0]["ST_ACCEPT_DATE"]);
                    bResult = BCO.DeleteDisCRMRecord(ParameterList, null);
                }

                if (bResult)
                {
                    ResultMsgLabel.Text = "刪除成功";
                    ScriptManager.RegisterStartupScript(this, this.GetType(), "", string.Format("location.href='ALO191.aspx?Code=ALO19&Requery=true&ChanNo={0}'", SLP_StoreChain1.Text), true);
                }
                else
                {
                    ResultMsgLabel.Text = "刪除失敗";
                }
            }
            else
            {
                throw new Exception("已確認不可刪除");
            }
        }
        catch (Exception ex)
        {
            ErrorMsgLabel.Text = ex.Message;
        }
        #endregion
    }
Esempio n. 8
0
    private string ProcessConfirm(string strStAcceptDate, string strDisNo)
    {
        #region
        string strCallbackResult = "";

        string strResult = "", strErrMsg = "";
        string strPrefixed = "POP_DisApproveError";
        string strApproveDate = "";
        string strITEM_PERIOD_RESERVE_QTY = "";

        try
        {
            #region
            //2009-11-04 cyhsu add for 門市進貨日檢查
            #region 檢查門市進貨日
            if (DateTime.Parse(strStAcceptDate) < DateTime.Today.AddDays(1))
            {
                throw new Exception("門市進貨日必須大於系統日");
            }
            if (DateTime.Parse(strStAcceptDate).DayOfWeek == DayOfWeek.Sunday)
            {
                throw new Exception("門市進貨日不可為星期日");
            }
            #endregion
            fmStatus = FormStatus.fmProcess;

            ALOModel.MaintainDisCRMRecord BCO = new ALOModel.MaintainDisCRMRecord(ConnectionDB);
            ArrayList ParameterList = new ArrayList();

            ParameterList.Clear();
            ParameterList.Add(strStAcceptDate);
            ParameterList.Add(strDisNo);
            ParameterList.Add("VDS_ALO_DIS_STORE");
            ParameterList.Add(Session["UID"].ToString());

            BCO.ProcessConfirm(ParameterList, out strResult, out strErrMsg, null);
            // 2009-06-17 cyhsu change
            if ((strResult == "1") && (strErrMsg.Trim() == ""))//確認成功
            {
                strApproveDate = DateTime.Now.ToString("yyyy/MM/dd");
                ConfirmIsTrueAndRemoveIsFalse = true;


                #region
                //20091202
                ALOModel.MaintainDisCRMRecord BCO2 = new ALOModel.MaintainDisCRMRecord(ConnectionDB);
                ParameterList.Clear();
                ParameterList.Add(strDisNo == "" ? null : strDisNo);
                DataTable dtTemp = BCO2.QueryDisCRMItemByDisNo(ParameterList);

                if (dtTemp != null && dtTemp.Rows.Count > 0)
                {
                    for (Int32 i = 0; i <= dtTemp.Rows.Count - 1; i++)
                    {
                        strITEM_PERIOD_RESERVE_QTY += string.Format("{0}||{1}||{2},",
                            dtTemp.Rows[i]["ITEM"].ToString(), dtTemp.Rows[i]["PERIOD"].ToString(), dtTemp.Rows[i]["RESERVE_QTY"].ToString());
                    }

                    if (strITEM_PERIOD_RESERVE_QTY.Trim() != "")
                    {
                        if (strITEM_PERIOD_RESERVE_QTY.Substring(strITEM_PERIOD_RESERVE_QTY.Length - 1, 1) == ",")
                        {
                            strITEM_PERIOD_RESERVE_QTY = strITEM_PERIOD_RESERVE_QTY.Substring(0, strITEM_PERIOD_RESERVE_QTY.Length - 1);
                        }
                    }
                }


                #endregion

            } // 只要成功完成檢核,無論筆數 strResult 都=1, 所以要另外檢查strErrMsg 不為空值代表有檢核錯誤資料需要開POP
            else if ((strResult == "1") && (strErrMsg.Trim() != ""))//確認失敗
            {
                Session[string.Format("{0}_DISNO_{1}", strPrefixed, PageTimeStamp.Value)] = strDisNo;
                Session[string.Format("{0}_OPTYPE_{1}", strPrefixed, PageTimeStamp.Value)] = "1";
                strResult = "0";
            }


            strCallbackResult = string.Format("{0}-{1}-{2}-{3}-{4};{5}-{6}-{7}-{8}",
                ((TextBox)SLP_SLPDate4_ApproveDate.FindControl("TextBoxCode")).ClientID,
                btn_Confirm.ClientID,
                btn_Remove.ClientID,
                ResultMsgLabel.ClientID,
                hiddenFrmStatus.ClientID,
                strApproveDate,
                strResult,
                FormStatus.fmBrowse.ToString(),
                strITEM_PERIOD_RESERVE_QTY
                );
            #endregion
        }
        catch (Exception ex)
        {
            throw ex;
        }

        return strCallbackResult;
        #endregion
    }
Esempio n. 9
0
    protected void btn_Remove_Click(object sender, EventArgs e)
    {
        #region

        string strResult = "", strErrMsg = "";

        try
        {
            fmStatus = FormStatus.fmProcess;

            ALOModel.MaintainDisCRMRecord BCO = new ALOModel.MaintainDisCRMRecord(ConnectionDB);
            ArrayList ParameterList = new ArrayList();


            ParameterList.Clear();
            ParameterList.Add(txt_DisNo.Text.Trim());
            ParameterList.Add(Session["UID"].ToString());
            ParameterList.Add(DateTime.Now);

            BCO.ProcessCancelConfirm(ParameterList, out strResult, out strErrMsg, null);

            if (strResult == "1")//解除成功
            {
                SLP_SLPDate4_ApproveDate.Text = "";
                CheckConfirmOrRemove();
                QueryData();//20091202
            }
            else//解除失敗
            {

            }

            ResultMsgLabel.Text = string.Format("{0} {1}", strResult == "1" ? "解除成功" : "解除失敗", strErrMsg);

        }
        catch (Exception ex)
        {
            ErrorMsgLabel.Text = ex.Message;
        }
        finally
        {
            fmStatus = FormStatus.fmBrowse;
        }
        #endregion
    }
Esempio n. 10
0
    private string ProcessMultiRemove(string strDisNoForAry, Int32 iProcessingAryIndex, string strUserID, string strPageTimeStamp)
    {
        #region

        bool bResult = false;
        string strDisNo = "", strNextDisNo = "";
        string[] strAryDisAry = strDisNoForAry.Split(";".ToCharArray());
        string strCallbackResult = "";
        string strResult = "", strErrMsg = "";
        string strPrefixed = "POP_DisApproveError";

        try
        {

            //於執行多筆確認、解除時清空,為了於換頁時可以取得最新資料
            string SessionIDName = string.Format("{0}_{1}", "ALO191_MST", strPageTimeStamp);
            Session[SessionIDName] = null;

            fmStatus = FormStatus.fmProcess;

            if (iProcessingAryIndex < strAryDisAry.Length)
            {

                strDisNo = strAryDisAry[iProcessingAryIndex];

                ALOModel.MaintainDisCRMRecord BCO = new ALOModel.MaintainDisCRMRecord(ConnectionDB);
                ArrayList ParameterList = new ArrayList();
                ParameterList.Clear();
                ParameterList.Add(strDisNo);
                ParameterList.Add(strUserID);
                ParameterList.Add(DateTime.Now);

                BCO.ProcessCancelConfirm(ParameterList, out strResult, out strErrMsg, null);

                if (strResult == "1")//解除成功
                {
                    bResult = true;
                }
                else//解除失敗
                {
                    Session[string.Format("{0}_REMOVE_{1}", strPrefixed, strPageTimeStamp)] = strDisNo;
                    bResult = false;
                }

                iProcessingAryIndex = iProcessingAryIndex + 1;

                if (iProcessingAryIndex < strAryDisAry.Length)
                {
                    strNextDisNo = strAryDisAry[iProcessingAryIndex];
                }
                else
                {
                    strNextDisNo = "X";//表示已執行到最後一筆
                }

                //0:DIS_NO字串For陣列用-
                //1:下一筆陣列Index-
                //2:執行結果-
                //3:錯誤訊息-
                //4:要關閉執行狀態的DIS_NO-
                //5:要開啟執行狀態的DIS_NO-
                //6:是否有累積執行錯誤之DIS_NO


                strCallbackResult = string.Format("{0}-{1}-{2}-{3}-{4}-{5}-{6}",
                    strDisNoForAry,
                    iProcessingAryIndex,
                    bResult ? "OK" : "NG",
                    string.Format("{0}", strErrMsg),
                    strDisNo,
                    strNextDisNo,
                    Session[string.Format("{0}_REMOVE_{1}", strPrefixed, strPageTimeStamp)] == null ? "0" : "1"
                    );
            }

        }
        catch (Exception ex)
        {
            throw new Exception(string.Format("{0}||{1}", strDisNo, ex.Message));
        }

        return strCallbackResult;
        #endregion
    }
Esempio n. 11
0
    private string ProcessMultiConfirm(string strStAcceptDate, string strDisNoForAry, Int32 iProcessingAryIndex, string strUserID, string strPageTimeStamp)
    {
        #region
        string strDisNo = "", strNextDisNo = "";
        string[] strAryDisAry = strDisNoForAry.Split(";".ToCharArray());
        string strCallbackResult = "";
        string strResult = "", strErrMsg = "", strErrMsgFinal = "";
        string strPrefixed = "POP_DisApproveError";
        string strApproveDate = "";
        string strITEM_PERIOD_RESERVE_QTY = "";
        

        try
        {
            //於執行多筆確認、解除時清空,為了於換頁時可以取得最新資料
            string SessionIDName = string.Format("{0}_{1}", "ALO191_MST", strPageTimeStamp);
            Session[SessionIDName] = null;


            #region 檢查門市進貨日
            if (DateTime.Parse(strStAcceptDate) < DateTime.Today.AddDays(1))
            {
                strErrMsg += "門市進貨日必須大於系統日 ";
            }

            if (DateTime.Parse(strStAcceptDate).DayOfWeek == DayOfWeek.Sunday)
            {
                strErrMsg += "門市進貨日不可為星期日 ";
            }
            #endregion

            fmStatus = FormStatus.fmProcess;

            if (iProcessingAryIndex < strAryDisAry.Length)
            {
                //取得當前執行之 DISNO
                strDisNo = strAryDisAry[iProcessingAryIndex];

                if (strErrMsg == "")
                {
                    #region
                    ALOModel.MaintainDisCRMRecord BCO = new ALOModel.MaintainDisCRMRecord(ConnectionDB);
                    ArrayList ParameterList = new ArrayList();
                    ParameterList.Clear();
                    ParameterList.Add(strStAcceptDate);
                    ParameterList.Add(strDisNo);
                    ParameterList.Add("VDS_ALO_DIS_STORE");
                    ParameterList.Add(strUserID);

                    BCO.ProcessConfirm(ParameterList, out strResult, out strErrMsg, null);

                    if ((strResult == "1") && (strErrMsg.Trim() == ""))//確認成功
                    {
                        strApproveDate = DateTime.Now.ToString("yyyy/MM/dd");

                        #region
                        ALOModel.MaintainDisCRMRecord BCO2 = new ALOModel.MaintainDisCRMRecord(ConnectionDB);
                        ParameterList.Clear();
                        ParameterList.Add(strDisNo == "" ? null : strDisNo);
                        DataTable dtTemp = BCO2.QueryDisCRMItemByDisNo(ParameterList);
                        BCO2.CloseConnection();

                        if (dtTemp != null && dtTemp.Rows.Count > 0)
                        {
                            for (Int32 i = 0; i <= dtTemp.Rows.Count - 1; i++)
                            {
                                strITEM_PERIOD_RESERVE_QTY += string.Format("{0}||{1}||{2},",
                                    dtTemp.Rows[i]["ITEM"].ToString(), dtTemp.Rows[i]["PERIOD"].ToString(), dtTemp.Rows[i]["RESERVE_QTY"].ToString());
                            }

                            if (strITEM_PERIOD_RESERVE_QTY.Trim() != "")
                            {
                                if (strITEM_PERIOD_RESERVE_QTY.Substring(strITEM_PERIOD_RESERVE_QTY.Length - 1, 1) == ",")
                                {
                                    strITEM_PERIOD_RESERVE_QTY = strITEM_PERIOD_RESERVE_QTY.Substring(0, strITEM_PERIOD_RESERVE_QTY.Length - 1);
                                }
                            }
                        }


                        #endregion

                    }
                    else if ((strResult == "1") && (strErrMsg.Trim() != ""))//確認失敗
                    {
                        #region 只要成功完成檢核,無論筆數 strResult 都=1, 所以要另外檢查strErrMsg 不為空值代表有檢核錯誤資料需要開POP
                        //Session[string.Format("{0}_DISNO_{1}", strPrefixed, strPageTimeStamp)] = strDisNo;
                        //Session[string.Format("{0}_OPTYPE_{1}", strPrefixed, strPageTimeStamp)] = "1";

                        Session[string.Format("{0}_DISNO_{1}", strPrefixed, strPageTimeStamp)] += string.Format("{0},", strDisNo);
                        Session[string.Format("{0}_OPTYPE_{1}", strPrefixed, strPageTimeStamp)] = "1";
                        Session[string.Format("{0}_ERRMSG_{1}", strPrefixed, strPageTimeStamp)] += string.Format("配本序號:{0},{1};\r\n", strDisNo, strErrMsg);

                        strResult = "0";
                        #endregion
                    }
                    #endregion
                }
                else 
                {
                    Session[string.Format("{0}_ERRMSG_{1}", strPrefixed, strPageTimeStamp)] += string.Format("配本序號:{0},{1};\r\n", strDisNo, strErrMsg);
                }

                iProcessingAryIndex = iProcessingAryIndex + 1;

                if (iProcessingAryIndex < strAryDisAry.Length)
                {
                    strNextDisNo = strAryDisAry[iProcessingAryIndex];
                }
                else
                {
                    strNextDisNo = "X";//表示已執行到最後一筆
                    strErrMsgFinal = Session[string.Format("{0}_ERRMSG_{1}", strPrefixed, strPageTimeStamp)] == null ? "" : Session[string.Format("{0}_ERRMSG_{1}", strPrefixed, strPageTimeStamp)].ToString();
                    Session[string.Format("{0}_ERRMSG_{1}", strPrefixed, strPageTimeStamp)] = null;
                }

                //0:DIS_NO字串For陣列用-
                //1:下一筆陣列Index-
                //2:執行結果-
                //3:錯誤訊息-
                //4:要關閉執行狀態的DIS_NO-
                //5:要開啟執行狀態的DIS_NO-
                //6:是否有累積執行錯誤之DIS_NO
                strCallbackResult = string.Format("{0}-{1}-{2}-{3}-{4}-{5}-{6}",
                    strDisNoForAry,
                    iProcessingAryIndex,
                    strResult == "1" ? "OK" : "NG",
                    strErrMsgFinal,
                    strDisNo,
                    strNextDisNo,
                    Session[string.Format("{0}_DISNO_{1}", strPrefixed, strPageTimeStamp)] == null ? "0" : "1"
                    );
            }
        }
        catch (Exception ex)
        {
            throw new Exception(string.Format("{0}||{1}", strDisNo, ex.Message));
        }

        return strCallbackResult;
        #endregion
    }
Esempio n. 12
0
    private void QueryData()
    {
        #region
        try
        {



            ALOModel.MaintainDisCRMRecord BCO = new ALOModel.MaintainDisCRMRecord(ConnectionDB);
            DataTable dt = BCO.QueryDisCRMMainByFind(GetQueryParams());

            string SessionIDName = string.Format("{0}_{1}", PAGE_DT_01, PageTimeStamp.Value);
            Session[SessionIDName] = dt;

            aryParamsPKey.Clear();

            LabelQueryRecordCount.Visible = false;

            if (dt != null && dt.Rows.Count > 0)
            {
                gv_Result.PageSize = iCurrentGvPageSize;
                gv_Result.PageIndex = iCurrentGvPageIndex;

                gv_Result.DataSource = dt;
                gv_Result.DataBind();

                LabelQueryRecordCount.Text = string.Format(" {0} Rows ", dt.Rows.Count.ToString());

                foreach (DataRow dr in dt.Rows)
                {
                    #region

                    aryParamsPKey.Add(dr["DIS_NO"]);

                    #endregion
                }

                //有資料才可執行多筆確認、解除
                btn_ConfirmMulti.Visible = true;
                btn_RemoveMulti.Visible = true;

            }
            else
            {
                btn_ConfirmMulti.Visible = false;
                btn_RemoveMulti.Visible = false;

                gv_Result.DataBind();
                ResultMsgLabel.Text = "查無資料";
            }

            Session[string.Format("{0}_{1}", strPreFixed, PageTimeStamp.Value)] = aryParamsPKey;
        }
        catch (Exception ex)
        {
            gv_Result.DataBind();
            ErrorMsgLabel.Text = ex.Message;
        }
        finally
        {
            UpdatePanel2.Update();
        }

        #endregion
    }
Esempio n. 13
0
    private bool ConfirmDisAgain(string strDisNo, string strStAcceptDate, string strUserID)
    {
        #region
        Int32 iErrCount = 0;

        try
        {
            string strResult = "", strErrMsg = "";
            string strDisNo_Err = "";
            string strPrefixed = "POP_DisApproveError";
            bool bResultCheck = false;

            string[] strAryDisNO = strDisNo.Split(",".ToCharArray());

            ALOModel.MaintainDisCRMRecord BCO = new ALOModel.MaintainDisCRMRecord(ConnectionDB);
            ArrayList ParameterList = new ArrayList();

            for (Int32 i = 0; i <= strAryDisNO.GetUpperBound(0); i++)
            {
                ParameterList.Clear();
                ParameterList.Add(strStAcceptDate);
                ParameterList.Add(strAryDisNO[i]);
                ParameterList.Add("VDS_ALO_DIS_STORE");
                ParameterList.Add(strUserID);
                BCO.ProcessConfirm(ParameterList, out strResult, out strErrMsg, null);

                if ((strResult == "1") && (strErrMsg.Trim() == ""))//確認成功
                {
                    #region 確認成功
                    //do nothing
                    #endregion
                } // 只要成功完成檢核,無論筆數 strResult 都=1, 所以要另外檢查strErrMsg 不為空值代表有檢核錯誤資料需要開POP
                else if ((strResult == "1") && (strErrMsg.Trim() != ""))//確認失敗
                {
                    #region 確認失敗
                    strDisNo_Err += string.Format("{0},", strAryDisNO[i]);
                    strResult = "0";
                    iErrCount++;
                    #endregion
                }
            }

            if (iErrCount != 0)
            {
                Session[string.Format("{0}_DISNO_{1}", strPrefixed, PageTimeStamp.Value)] = strDisNo_Err;
                Session[string.Format("{0}_OPTYPE_{1}", strPrefixed, PageTimeStamp.Value)] = "1";
            }
        }
        catch (Exception ex)
        {
            throw ex;
        }

        return iErrCount == 0 ? true : false;
        #endregion
    }
Esempio n. 14
0
    /// <summary>
    /// 配本確認 2009-07-02
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void SetupConfirmBtn_Click(object sender, EventArgs e)
    {
        #region

        string strResult = "", strErrMsg = "", strErrMsgCheck = "";
        bool bResultCheck = false;
        string strPrefixed = "POP_DisApproveError";
        try
        {
            #region

            #region 門市進貨日判斷

            if (DateTime.Parse(SLP_STAcceptDate.Text) < DateTime.Today.AddDays(1))//2010/04/06 added : 門市進貨日必須大於等於系統日+1日
            {
                throw new Exception("門市進貨日必須大於等於系統日+1日!!");
            }

            #endregion

            #region
            ALOModel.MaintainDisCRMRecord BCO = new ALOModel.MaintainDisCRMRecord(ConnectionDB);
            ArrayList ParameterList = new ArrayList();


            //---------------------------------------------------------------------
            //2010/02/08 added:確認前檢核
            ParameterList.Clear();
            ParameterList.Add(DateTime.Parse(SLP_STAcceptDate.Text).ToShortDateString());
            ParameterList.Add(DISNOTxt.Text);
            bResultCheck = BCO.Pick_Control_Check(ParameterList, out strErrMsgCheck);
            //---------------------------------------------------------------------

            ParameterList.Clear();
            ParameterList.Add(DateTime.Parse(SLP_STAcceptDate.Text).ToShortDateString());
            ParameterList.Add(DISNOTxt.Text);
            ParameterList.Add("VDS_ALO_DIS_STORE");
            ParameterList.Add(Session["UID"].ToString());
            BCO.ProcessConfirm(ParameterList, out strResult, out strErrMsg, null);

            if ((strResult == "1") && (strErrMsg.Trim() == ""))//確認成功
            {
                #region 確認成功
                SLP_ApproveDate.Text = DateTime.Now.ToString("yyyy/MM/dd");
                Int32 iReserveQty = 0; //保留數
                Int32 iMdcQty = 0;     //預留數(理論) = 到貨數-保留數-實配數
                Int32 iAcceptQTY = 0;  //到貨數
                Int32 iDisQty = 0;     //實配數
                //取舊值
                iReserveQty = Int32.Parse(this.ReserveQTYtxt.Text);
                iMdcQty = Int32.Parse(this.DIS_MDCQTYtxt.Text);
                iAcceptQTY = Int32.Parse(this.AcceptQTYtxt.Text);
                iDisQty = Int32.Parse(this.DISQTYtxt.Text);
                //算新值
                iReserveQty = iReserveQty + iDisQty;
                iMdcQty = iAcceptQTY - iReserveQty;//預留數(實際) = 到貨數-新保留數

                this.ReserveQTYtxt.Text = iReserveQty.ToString();
                this.OLD_ReserveQTYtxtHidden.Value = iReserveQty.ToString();
                this.DIS_MDCQTYtxt.Text = iMdcQty.ToString();
                this.OLD_DISMDCQTYHidden.Value = iMdcQty.ToString();


                //Gridview
                SessionIDName = "ALO111ItemGridViewDv_" + PageTimeStamp.Value;
                DataView dv = (DataView)Session[SessionIDName];

                for (Int32 i = 0; i <= dv.Table.Rows.Count - 1; i++)
                {
                    if (dv.Table.Rows[i]["ITEM"].ToString().Trim() == SLP_SKU1.TextBox_Code.Text.Trim() &&
                       dv.Table.Rows[i]["PERIOD"].ToString().Trim() == SLP_ItemPeriod1.TextBox_Code.Text.Trim())
                    {
                        dv.Table.Rows[i]["RESERVE_QTY"] = iReserveQty;
                        dv.Table.Rows[i]["DIS_MDC_QTY"] = iMdcQty;
                        break;
                    }
                }

                Session[SessionIDName] = dv;
                GridView_ItemList.DataSource = dv;
                GridView_ItemList.DataBind();

                //2010/04/20 modified
                if (!bResultCheck && strErrMsgCheck != "")
                {
                    ScriptManager.RegisterStartupScript(this, this.GetType(), "", string.Format("alert('{0}');alert('確認成功!');", strErrMsgCheck), true);
                }
                else
                {
                    ScriptManager.RegisterStartupScript(this, this.GetType(), "", "alert('確認成功!');", true);
                }


                #endregion
            } // 只要成功完成檢核,無論筆數 strResult 都=1, 所以要另外檢查strErrMsg 不為空值代表有檢核錯誤資料需要開POP
            else if ((strResult == "1") && (strErrMsg.Trim() != ""))//確認失敗
            {
                #region 確認失敗
                Session[string.Format("{0}_DISNO_{1}", strPrefixed, PageTimeStamp.Value)] = DISNOTxt.Text;
                Session[string.Format("{0}_OPTYPE_{1}", strPrefixed, PageTimeStamp.Value)] = "1";
                strResult = "0";
                #endregion
            }


            if (bResultCheck)
            {
                #region check ok && confirm fail
                if (strResult != "1")
                {
                    ScriptManager.RegisterStartupScript(this, this.GetType(), "", "POP_DisApproveError();", true);
                }
                #endregion
            }
            else
            {
                #region check fail && confirm fail
                if (strResult != "1")
                {
                    ScriptManager.RegisterStartupScript(this, this.GetType(), "", string.Format("alert('{0}');POP_DisApproveError();", strErrMsgCheck), true);
                }
                #endregion
            }


            FormStatusControl(FormStatus.View);
            UpdatePanel_ALODisMain.Update();
            UpdatePanel_Item.Update();
            #endregion

            #endregion
        }
        catch (Exception ex)
        {
            this.ErrorMsgLabel.Text = ex.Message;

            if (!bResultCheck && strErrMsgCheck != "")
            {
                ScriptManager.RegisterStartupScript(this, this.GetType(), "", string.Format("alert('{0}');", strErrMsgCheck), true);
            }

        }
        finally
        {
            UpdatePanel_ErrorMessage.Update();
        }

        #endregion
    }