MaintainStAccept, PIC.VDS2G.BSM.ALO C# (CSharp) Code Examples

Example #1

0

Show file

File: ALO21.cs Project: ChiangHanLung/PIC_VDS

        /// <summary>
        /// ALO21_1報表_轉單前檢查差異EXCEL
        /// </summary>
        /// <param name="ParameterList">變數清單</param>
        /// <returns>回傳查詢結果</returns>
        public DataTable ALO21_1(ArrayList ParameterList,
                                 ref ReportList.ExcelOtherType EOT)
        {
            #region
            ALOModel.MaintainStAccept BCO = new ALOModel.MaintainStAccept(ConntionDB);

            DataTable Dt = BCO.QueryCheckErrorInfo(ParameterList);

            if (Dt != null && Dt.Rows.Count > 0)
            {

                #region 表頭：如要指定表頭必設定
                Dt.Columns[0].ColumnName = "配本序號";
                Dt.Columns[1].ColumnName = "品號";
                Dt.Columns[2].ColumnName = "品名";
                Dt.Columns[3].ColumnName = "通路";
                Dt.Columns[4].ColumnName = "店號";
                Dt.Columns[5].ColumnName = "店名";
                Dt.Columns[6].ColumnName = "期別";
                Dt.Columns[7].ColumnName = "差異原因";
                #endregion

                EOT = ReportList.ExcelOtherType.Normal;//如要匯出EXCEL此為必要設定


                return Dt;
            }
            else
            {
                throw new Exception("查無資料!!");
            }
            #endregion
        }

Example #2

0

Show file

File: POP_CheckError2.aspx.cs Project: ChiangHanLung/PIC_VDS

    private void QueryData()
    {
        #region
        try
        {
            string SessionIDName = string.Format("{0}_{1}", strPrefixed, PageTimeStamp.Value);
            ALOModel.MaintainStAccept BCO = new ALOModel.MaintainStAccept(ConnectionDB);

            ArrayList ParameterList = new ArrayList();//20091113

            ParameterList.Clear();
            ParameterList.Add(SLP_SLPDate1.Text.Trim() == "" ? null : SLP_SLPDate1.Text.Trim());
            ParameterList.Add(txt_PickBatch.Text.Trim() == "" ? null : txt_PickBatch.Text.Trim());
            ParameterList.Add(Request.QueryString["UserIDKey"]);
            ParameterList.Add(string.Format("{0}_{1}", Request.QueryString["SessionIDKey"], Request.QueryString["UserIDKey"]));

            DataTable dt = BCO.QueryCheckErrorInfo(ParameterList);
            if (dt != null && dt.Rows.Count > 0)
            {
                gv_Result.DataSource = dt;
                gv_Result.PageSize = (TextBoxPagesize_Query.Text == "") ? 20 : (int.Parse(TextBoxPagesize_Query.Text) <= 0) ? 20 : int.Parse(TextBoxPagesize_Query.Text);
                gv_Result.DataBind();
                Session[SessionIDName] = dt;
                btn_Export.Enabled = true;
            }
            else
            {
                btn_Export.Enabled = false;
                gv_Result.DataBind();
                ResultMsgLabel.Text = "查無資料";
            }
        }
        catch (Exception ex)
        {
            ErrorMsgLabel.Text = ex.Message;
        }

        #endregion
    }

Example #3

0

Show file

File: ALO21.cs Project: ChiangHanLung/PIC_VDS

        /// <summary>
        /// ALO21_2報表_列印鈕(已轉單)
        /// </summary>
        /// <param name="ParameterList">變數清單</param>
        /// <param name="ReportOutputFormat">報表格式(PDF,EXCEL)</param>
        /// <param name="EOT">匯出Excel方式</param>           
        /// <returns>回傳查詢結果</returns>
        public DataTable ALO21_2(ArrayList ParameterList,
                                 string ReportOutputFormat,
                                 ref ReportList.ExcelOtherType EOT
                                 )
        {

            #region
            ALOModel.MaintainStAccept BCO = new  ALOModel.MaintainStAccept(ConntionDB);

            DataTable Dt = null;
            string strErrMsg = "";

            Dt = BCO.QueryStOutAcceptData(ParameterList, out strErrMsg);

            if (Dt == null || Dt.Rows.Count == 0)
            {
                throw new Exception("查無資料");
            }

            return Dt;
            #endregion
        }

Example #4

0

Show file

File: CRM171.aspx.cs Project: ChiangHanLung/PIC_VDS

    /// <summary>
    /// BUTTON [匯出]鈕

    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void but_GetOnHandResult_Click(object sender, EventArgs e)
    {
        DataTable dtReturn = new DataTable();
        System.Text.StringBuilder sb = new System.Text.StringBuilder();
        ArrayList ParameterList = new ArrayList();
        try
        {
            #region 檢查必填欄位
            BCO.CRMCommon CRMComm = new BCO.CRMCommon();
            sb.Append(CRMComm.Check_MustFillIN_Column(this.slp_ST_ACCEPT_DATE.Text, "[門市進貨日]為必填欄位", "0"));
            if (sb.ToString().Length > 0)
            {
                throw new Exception(sb.ToString().Trim());
            }
            #endregion

            #region 從資料庫取得資料

            ParameterList.Add(slp_ST_ACCEPT_DATE.Text);
            ParameterList.Add(Session["UID"].ToString());
            PIC.VDS2G.BSM.ALO.MaintainStAccept alo_bco = new PIC.VDS2G.BSM.ALO.MaintainStAccept(ConntionDB);
            //ALOBCO.MaintainStAccept alo_bco = new ALOBCO.MaintainStAccept();

            dtReturn = alo_bco.QueryOnHandResult(ParameterList);
            if (dtReturn == null || dtReturn.Rows.Count < 1)
            {
                throw new Exception("查無資料,門市進貨日[" + slp_ST_ACCEPT_DATE.Text + "]無手開單轉單");
            }

            #endregion

            #region 匯出資料
            string[] NameArr = { "類別", "店數", "品項數", "總冊數" };
            for (int i = 0; i < NameArr.Length; i++)
            {
                dtReturn.Columns[i].ColumnName = NameArr[i];
            }
            string FileCode = "CRM17_手開單轉單品項_" + slp_ST_ACCEPT_DATE.Text.Replace("/", "") + ".xls";
            //ExcelExportHelper.RenderDataTableToExcel(dt_Return, FileCode);
            WriteToXls2(dtReturn, FileCode);

            #endregion

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

Example #5

0

Show file