Пример #1
0
    private void SaveData()
    {
        try
        {

            if ((Session[PageTimeStamp.Value + GridView1.ID] == null) && (Session[PageTimeStamp.Value + GridView2.ID] == null))
            {
                ErrorMsgLabel.Text = "無明細資料可供儲存,無法存檔。";
                return;
            }

            GV1_To_Cache();
            GV2_To_Cache();

            DataTable dt1 = (DataTable)Session[PageTimeStamp.Value + GridView1.ID];
            DataTable dt2 = (DataTable)Session[PageTimeStamp.Value + GridView2.ID];

            if ((FilterDT(dt1).Rows.Count == 0) && (FilterDT(dt2).Rows.Count == 0))
            {
                ErrorMsgLabel.Text = "無明細資料可供儲存,無法存檔。";
                return;
            }

            //CheckVendorAccountClose BCO_CHECK = new CheckVendorAccountClose(ConntionDB);
            //if (BCO_CHECK.CheckVendorCloseStaus(txtONWAY_DATE.Text.Replace("/", "")) == "1")
            //{
            //    ErrorMsgLabel.Text = "在途日 " + txtONWAY_DATE.Text.Replace("/", "") + " 已日結,不可新增在途單。";
            //    return;
            //}

            string strNowDate = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
            string strONWAY_NO = string.Empty;
            MaintainGoodsInTransit BCO = new MaintainGoodsInTransit(ConntionDB);
            bool bResult = false;

            switch (ViewState["Mode"].ToString().Trim())
            {
                case "Insert":
                    //0.Item DataTable
                    //1.Gift DataTable        
                    //2.VENDOR
                    //3.PURCHASE_NO
                    //4.ONWAY_DATE
                    //5.CREATEDATE
                    //6.CREATEUID
                    //7.UPDATEDATE
                    //8.UPDATEUID
                    //9.STATUS
                    //out ONWAY_NO

                    ParameterList.Clear();
                    ParameterList.Add(dt1); //0
                    ParameterList.Add(dt2); //1
                    ParameterList.Add(SLP_VendorBase1.Text.Trim()); //2
                    ParameterList.Add(txtPURCHASE_NO.Text.Trim());  //3
                    ParameterList.Add(strNowDate); //4
                    ParameterList.Add(strNowDate); //5
                    ParameterList.Add(Session["UID"].ToString()); //6
                    ParameterList.Add(strNowDate); //7
                    ParameterList.Add(Session["UID"].ToString()); //8
                    ParameterList.Add("25");  //9

                    bResult = BCO.CreateGoodsInTransit(ParameterList, out strONWAY_NO, null);
                    break;
                case "Edit":
                    //0.Item DataTable
                    //1.Gift DataTable       
                    //2.ONWAY_NO
                    //3.ONWAY_DATE               
                    //4.UPDATEDATE
                    //5.UPDATEUID
                    //6.STATUS   
                    //7.OLD_UPDATEDATE
                    //8.OLD_UPDATEUID

                    ParameterList.Clear();
                    ParameterList.Add(dt1); //0
                    ParameterList.Add(dt2); //1       
                    ParameterList.Add(txtONWAY_NO.Text); //2
                    ParameterList.Add(strNowDate);       //3
                    ParameterList.Add(strNowDate);       //4
                    ParameterList.Add(Session["UID"].ToString()); //5
                    ParameterList.Add("25");                      //6
                    ParameterList.Add(hdfOLD_UPDATEDATE.Value);   //7             
                    ParameterList.Add(SLP_UPDATEUID.Text.Trim()); //8                

                    bResult = BCO.UpdateGoodsInTransit(ParameterList);
                    strONWAY_NO = txtONWAY_NO.Text;

                    break;
            }
            //ErrorMsgLabel.Text = "儲存完成";
            //Response.Redirect("PUR052.aspx?Code=PUR05&Mode=View&MSG=SAVE&ONWAY_NO=" + strONWAY_NO, false);
            Reload_Page("View", "SAVE", strONWAY_NO);
        }
        catch (Exception ex)
        {
            ErrorMsgLabel.Text = ex.Message;
        }
        finally { }
    }