示例#1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            this.Master.Reset();

            this.Master.RegisterStandardScript = true;

            decimal I_chute_id      = decimal.Parse(Request.QueryString["chuteID"].ToString());
            string  I_chute_barcode = Request.QueryString["chutebarcode"].ToString();
            string  I_user          = Request.QueryString["userlogon"].ToString();
            decimal I_chute_type    = decimal.Parse(Request.QueryString["chutetype"].ToString());
            //Default area to sorter when not passed.
            decimal I_chute_area = decimal.Parse(Request.QueryString["chutearea"] == null? "1" : Request.QueryString["chutearea"].ToString());

            //string I_terminal = this.Master.HostName;
            string I_terminal = null;

            string barcodetype = "Trolley";

            UserActivity   setclass = new UserActivity();
            ActivityLogDAO actlog   = new ActivityLogDAO();

            if (!IsPostBack)
            {
                // on page load display this message
                this.Master.MessageBoard = "Scan Trolley Barcode for Attach";
            }
            else
            {
                string trolley_barcode = this.Master.BarcodeValue;

                if (trolley_barcode != string.Empty)
                {
                    if (trolley_barcode.Length > 50)
                    {
                        trolley_barcode = trolley_barcode.Substring(0, 50);
                    }
                }

                LocateDAO locdao = new LocateDAO();

                //decimal trolley_id = 0;

                // check if the chute is singles or multi
                if (I_chute_type == 1) // singles
                {
                    decimal trolley_id_singles = 0;
                    // validate the trolley barcode using oms_attach_trolley.p_validate_trolley

                    try
                    {
                        trolley_id_singles = locdao.Validate_Trolley(I_chute_id, trolley_barcode, I_user, I_terminal);
                    }
                    catch (Exception ex1)
                    {
                        // activity logging
                        setclass.AppSystem           = (Int32)ActivityLogEnum.AppSystem.IHF;
                        setclass.ApplicationId       = (Int32)ActivityLogEnum.ApplicationID.AttachAndLocate;
                        setclass.ModuleId            = (Int32)ActivityLogEnum.ModuleID.AttachAndlocate;
                        setclass.EventType           = (Int32)EventType.ScanTrolleyForAttach;
                        setclass.ResultCode          = (Int32)ActivityLogEnum.ResultCd.TrolleyScanFailed;
                        setclass.ExpectedBarcodeType = barcodetype;
                        setclass.Barcode             = trolley_barcode;
                        setclass.TerminalId          = I_terminal;
                        setclass.UserId    = I_user;
                        setclass.ChuteId   = decimal.ToInt32(I_chute_id);
                        setclass.TrolleyId = decimal.ToInt32(trolley_id_singles);


                        actlog.SaveUserActivity(setclass);

                        this.Master.ErrorMessage   = ex1.Message.Substring(ex1.Message.IndexOf(" ", 0), (ex1.Message.IndexOf("ORA", 1) - ex1.Message.IndexOf(" ", 0)));
                        this.Master.DisplayMessage = true;
                        this.Master.BarcodeValue   = string.Empty;
                    }
                    // attach the trolley
                    try
                    {
                        // if no errors then attach trolley to chute using oms_attach_trolley.p_attach_trolley_to_chute
                        locdao.Attach_Trolley(I_chute_id, trolley_id_singles, I_user, I_terminal);

                        // Log user to chute using p_log_on_to_chute

                        /************ commented out for time being ************/
                        //locdao.Log_on_to_Chute(I_chute_barcode, I_user);
                        /************ commented out for time being ************/



                        // trolley attach success for singles

                        // log off user from locating session


                        /************ commented out for time being ************/
                        //locdao.Log_off_Chute(I_chute_id, I_user);


                        // activity logging
                        setclass.AppSystem           = (Int32)ActivityLogEnum.AppSystem.IHF;
                        setclass.ApplicationId       = (Int32)ActivityLogEnum.ApplicationID.AttachAndLocate;
                        setclass.ModuleId            = (Int32)ActivityLogEnum.ModuleID.AttachAndlocate;
                        setclass.EventType           = (Int32)EventType.LogOffChuteForLocate;
                        setclass.ResultCode          = (Int32)ActivityLogEnum.ResultCd.Success;
                        setclass.ExpectedBarcodeType = barcodetype;
                        setclass.Barcode             = trolley_barcode;
                        setclass.TerminalId          = I_terminal;
                        setclass.UserId    = I_user;
                        setclass.ChuteId   = decimal.ToInt32(I_chute_id);
                        setclass.TrolleyId = decimal.ToInt32(trolley_id_singles);


                        actlog.SaveUserActivity(setclass);

                        /************ commented out for time being ************/

                        // redirect to main page of locate to scan another chute

                        Response.Redirect("Locate.aspx");
                    }
                    catch (Exception ex)
                    {
                        // activity logging

                        setclass.AppSystem           = (Int32)ActivityLogEnum.AppSystem.IHF;
                        setclass.ApplicationId       = (Int32)ActivityLogEnum.ApplicationID.AttachAndLocate;
                        setclass.ModuleId            = (Int32)ActivityLogEnum.ModuleID.AttachAndlocate;
                        setclass.EventType           = (Int32)EventType.TrolleyAttachLocate;
                        setclass.ResultCode          = (Int32)ActivityLogEnum.ResultCd.FailedToAttach;
                        setclass.ExpectedBarcodeType = barcodetype;
                        setclass.Barcode             = trolley_barcode;
                        setclass.TerminalId          = I_terminal;
                        setclass.UserId    = I_user;
                        setclass.ChuteId   = decimal.ToInt32(I_chute_id);
                        setclass.TrolleyId = decimal.ToInt32(trolley_id_singles);



                        actlog.SaveUserActivity(setclass);

                        this.Master.ErrorMessage   = ex.Message.Substring(ex.Message.IndexOf(" ", 0), (ex.Message.IndexOf("ORA", 1) - ex.Message.IndexOf(" ", 0)));
                        this.Master.DisplayMessage = true;
                        this.Master.BarcodeValue   = string.Empty;
                    }
                }// chute type is 1

                else if (I_chute_type == 2) // multi
                {
                    // check if chute is attached to a trolley
                    decimal chutes_trolley_id = 0;
                    try
                    {
                        chutes_trolley_id = locdao.Chute_Trolley(I_chute_barcode, I_user, I_terminal);
                    }
                    catch (Exception xx1)
                    {
                        // activity logging

                        setclass.AppSystem           = (Int32)ActivityLogEnum.AppSystem.IHF;
                        setclass.ApplicationId       = (Int32)ActivityLogEnum.ApplicationID.AttachAndLocate;
                        setclass.ModuleId            = (Int32)ActivityLogEnum.ModuleID.AttachAndlocate;
                        setclass.EventType           = (Int32)EventType.TrolleyAttachLocate;
                        setclass.ResultCode          = (Int32)ActivityLogEnum.ResultCd.FailedToAttach;
                        setclass.ExpectedBarcodeType = barcodetype;
                        setclass.Barcode             = trolley_barcode;
                        setclass.TerminalId          = I_terminal;
                        setclass.UserId    = I_user;
                        setclass.ChuteId   = decimal.ToInt32(I_chute_id);
                        setclass.TrolleyId = decimal.ToInt32(chutes_trolley_id);



                        actlog.SaveUserActivity(setclass);

                        this.Master.ErrorMessage   = xx1.Message.Substring(xx1.Message.IndexOf(" ", 0), (xx1.Message.IndexOf("ORA", 1) - xx1.Message.IndexOf(" ", 0)));
                        this.Master.DisplayMessage = true;
                        this.Master.BarcodeValue   = string.Empty;
                    }

                    // if no trolley is attached

                    if (chutes_trolley_id == 0)
                    {
                        // validate the trolley barcode using oms_attach_trolley.p_validate_trolley
                        decimal trolley_id_new = 0;

                        try
                        {
                            trolley_id_new = locdao.Validate_Trolley(I_chute_id, trolley_barcode, I_user, I_terminal);
                        }
                        catch (Exception xx2)
                        {
                            // activity logging
                            setclass.AppSystem           = (Int32)ActivityLogEnum.AppSystem.IHF;
                            setclass.ApplicationId       = (Int32)ActivityLogEnum.ApplicationID.AttachAndLocate;
                            setclass.ModuleId            = (Int32)ActivityLogEnum.ModuleID.AttachAndlocate;
                            setclass.EventType           = (Int32)EventType.ScanTrolleyForAttach;
                            setclass.ResultCode          = (Int32)ActivityLogEnum.ResultCd.TrolleyScanFailed;
                            setclass.ExpectedBarcodeType = barcodetype;
                            setclass.Barcode             = trolley_barcode;
                            setclass.TerminalId          = I_terminal;
                            setclass.UserId    = I_user;
                            setclass.ChuteId   = decimal.ToInt32(I_chute_id);
                            setclass.TrolleyId = decimal.ToInt32(trolley_id_new);


                            actlog.SaveUserActivity(setclass);

                            this.Master.ErrorMessage   = xx2.Message.Substring(xx2.Message.IndexOf(" ", 0), (xx2.Message.IndexOf("ORA", 1) - xx2.Message.IndexOf(" ", 0)));
                            this.Master.DisplayMessage = true;
                            this.Master.BarcodeValue   = string.Empty;
                        }

                        // attach trolley

                        try
                        {
                            // if no errors then attach trolley to chute using oms_attach_trolley.p_attach_trolley_to_chute
                            locdao.Attach_Trolley(I_chute_id, trolley_id_new, I_user, I_terminal);

                            // Log user to chute using p_log_on_to_chute

                            /************ commented out for time being ************/
                            //locdao.Log_on_to_Chute(I_chute_barcode, I_user);
                            /************ commented out for time being ************/

                            // redirect to scan sku

                            Response.Redirect("LocateScanSku.aspx?chuteID=" + I_chute_id + "&chutebarcode=" + I_chute_barcode + "&userlogon=" + I_user + "&trolleyid=" + trolley_id_new + "&chutetype=" + I_chute_type + "&chutearea =" + I_chute_area);
                        }

                        catch (Exception xx3)
                        {
                            // activity logging

                            setclass.AppSystem           = (Int32)ActivityLogEnum.AppSystem.IHF;
                            setclass.ApplicationId       = (Int32)ActivityLogEnum.ApplicationID.AttachAndLocate;
                            setclass.ModuleId            = (Int32)ActivityLogEnum.ModuleID.AttachAndlocate;
                            setclass.EventType           = (Int32)EventType.TrolleyAttachLocate;
                            setclass.ResultCode          = (Int32)ActivityLogEnum.ResultCd.FailedToAttach;
                            setclass.ExpectedBarcodeType = barcodetype;
                            setclass.Barcode             = trolley_barcode;
                            setclass.TerminalId          = I_terminal;
                            setclass.UserId    = I_user;
                            setclass.ChuteId   = decimal.ToInt32(I_chute_id);
                            setclass.TrolleyId = decimal.ToInt32(trolley_id_new);



                            actlog.SaveUserActivity(setclass);

                            this.Master.ErrorMessage   = xx3.Message.Substring(xx3.Message.IndexOf(" ", 0), (xx3.Message.IndexOf("ORA", 1) - xx3.Message.IndexOf(" ", 0)));
                            this.Master.DisplayMessage = true;
                            this.Master.BarcodeValue   = string.Empty;
                        }
                    }

                    else // another trolley is attached
                    {
                        // redirect to scan sku

                        Response.Redirect("LocateScanSku.aspx?chuteID=" + I_chute_id + "&chutebarcode=" + I_chute_barcode + "&userlogon=" + I_user + "&trolleyid=" + chutes_trolley_id + "&chutetype=" + I_chute_type + "&chutearea =" + I_chute_area);
                    }
                } // chute type is 2
            }     // end of post back
        }