public bool ExibirBotao(ASPxGridView grid, int visibleIndex)
 {
     object row = grid.GetRow(visibleIndex);
     string arquivo = "";
     if (visibleIndex != 0)
     {
         arquivo = grid.GetRowValues(visibleIndex, "ARQUIVO").ToString();
     }
     if (string.IsNullOrEmpty(arquivo))
     {
         return false;
     }
     else
     {
         return true;
     }
 }
예제 #2
0
        protected void GridBookingProcessView_CustomButtonCallback(object sender, DevExpress.Web.ASPxGridViewCustomButtonCallbackEventArgs e)
        {
            if (e.ButtonID == "ButtonBookingDetails")
            {
                ASPxGridView grid = sender as ASPxGridView;
                List <BookingProcessViewModel> list = (List <BookingProcessViewModel>)grid.DataSource;
                //Todo: Ivane da li trebas ovaj code ??
                int    index = e.VisibleIndex;
                string id    = grid.GetRowValues(index, "Id").ToString();

                /* string country = (string) grid.GetRowValues(index, "Country") ?? string.Empty;
                 * string placename = grid.GetRowValues(index, "PlaceName").ToString();
                 * string firstname = grid.GetRowValues(index, "FirstName").ToString();
                 * string lastname = grid.GetRowValues(index, "LastName").ToString();
                 *
                 * var item = list.Find(p => p.Id == id);
                 *
                 * var bookingitems = item.BookingProcessItemList;*/


                //      Response.Redirect("~/AspxArea/PriceList/Forms/PurchasePriceForm.aspx?sc=" + sitecode + "&oc=" + unitcode);
                ASPxWebControl.RedirectOnCallback(VirtualPathUtility.ToAbsolute("~/AspxArea/Booking/Forms/BookingProcessDetailsProView.aspx?id=" + id));
            }
        }
예제 #3
0
        private string FncGenerarDataGps()
        {
            string xresultado = string.Empty;

            try
            {
                if (this.PivotGrid.RowCount > -1)
                {
                    ASPxGridView xgrid = new ASPxGridView();
                    xgrid.SettingsPager.Mode = GridViewPagerMode.ShowAllRecords;
                    xgrid.DataSource         = this.PivotGrid.CreateDrillDownDataSource();
                    xgrid.DataBind();
                    if (xgrid.VisibleRowCount > 0)
                    {
                        List <LMap> lmapas = new List <LMap>();
                        for (int i = 0; i < xgrid.VisibleRowCount; i++)
                        {
                            LMap lmapa = new LMap();
                            lmapa.UTM_Latitud  = Convert.ToString(xgrid.GetRowValues(i, "GpsLatitud"));
                            lmapa.UTM_Longitud = Convert.ToString(xgrid.GetRowValues(i, "GpsLongitud"));
                            lmapa.Descripcion  = "Cuenca:" + Convert.ToString(xgrid.GetRowValues(i, "Cuenca_DSC")) + "<br/>" +
                                                 "Sub-Cuenca:" + Convert.ToString(xgrid.GetRowValues(i, "SubCuencaRio_DSC")) + "<br/>" +
                                                 "Punto Monitoreo:" + Convert.ToString(xgrid.GetRowValues(i, "PuntoMonitoreo_DSC")) + "<br/>" +
                                                 "Fecha:" + Convert.ToString(xgrid.GetRowValues(i, "FechaHoraInicial")) + "<br/>" +
                                                 "Caudal:" + Convert.ToString(xgrid.GetRowValues(i, "Caudal"));
                            lmapas.Add(lmapa);
                        }
                        if (lmapas.Count > 0)
                        {
                            xresultado = JsonConvert.SerializeObject(lmapas);
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                xresultado = ex.Message;
                xresultado = string.Empty;
            }
            return(xresultado);
        }
예제 #4
0
        protected void GridTouristUnitView_CustomButtonCallback(object sender, DevExpress.Web.ASPxGridViewCustomButtonCallbackEventArgs e)
        {
            ASPxGridView grid  = sender as ASPxGridView;
            int          index = e.VisibleIndex;

            if (e.ButtonID == "ButtonPriceList")
            {
                string unitcode = grid.GetRowValues(index, "UnitCode").ToString();
                string sitecode = grid.GetRowValues(index, "SiteCode").ToString();

                //      Response.Redirect("~/AspxArea/PriceList/Forms/PurchasePriceForm.aspx?sc=" + sitecode + "&oc=" + unitcode);
                ASPxWebControl.RedirectOnCallback(VirtualPathUtility.ToAbsolute("~/AspxArea/PriceList/Forms/PurchasePriceForm.aspx?sc=" + sitecode + "&uc=" + unitcode));
            }
            else if (e.ButtonID == "ButtonUnit")
            {
                string unitcode         = grid.GetRowValues(index, "UnitCode").ToString();
                string sitecode         = grid.GetRowValues(index, "SiteCode").ToString();
                string tourOperatorCode = grid.GetRowValues(index, "TourOperatorCode").ToString();
                string id = grid.GetRowValues(index, "id").ToString();

                ASPxWebControl.RedirectOnCallback(VirtualPathUtility.ToAbsolute("~/AspxArea/MasterData/Forms/UnitForm.aspx?id=" + id + "&sc=" + sitecode + "&uc=" + unitcode + "&to=" + tourOperatorCode + "&plt=" + "1"));
            }
        }
예제 #5
0
    protected void gdvPartyAttribute_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
    {
        ASPxGridView         gdv  = (ASPxGridView)sender;
        ITransaction         tx   = iSabayaContext.PersistenceSession.BeginTransaction();
        JsonObjectCollection objs = new JsonObjectCollection();
        bool   isSetNewFoucused   = false;
        bool   isCommit           = true;
        long   attributeID        = 0;
        string msg = "";

        try
        {
            string[] parameters = e.Parameters.Split(';');
            switch (parameters[0])
            {
            case KEY_EDIT:
                attributeID      = this.CreatePartyAttribute(long.Parse(parameters[1]));
                isSetNewFoucused = true;
                break;

            case KEY_EXPIRE:
                int index = Int32.Parse(parameters[1]);
                if (OwnerID == 0)
                {
                    gdv.DataBind();
                    PartyAttribute attribute = (PartyAttribute)gdv.GetRow(index);
                    ICategorizedTemporalList <PartyAttribute> attributes = PartyAttributes;
                    for (int i = 0; i < attributes.Count; i++)
                    {
                        if (attributes[i].AttributeKey == attribute.AttributeKey)
                        {
                            attributes.Remove(attributes[i]);
                            break;
                        }
                    }
                }
                else
                {
                    attributeID = (int)gdv.GetRowValues(index, gdv.KeyFieldName);
                    this.ExpirePartyAttribute(attributeID);
                }
                break;

            // when owner id = 0 only
            case "clear":
                if (OwnerID == 0)
                {
                    PartyAttributes.Clear();
                }
                break;

            default:
                isCommit = false;
                break;
            }

            if (isCommit)
            {
                tx.Commit();
            }
            gdv.DataBind();
            if (attributeID > 0 && isSetNewFoucused)
            {
                for (int i = gdv.VisibleRowCount - 1; i >= gdv.VisibleStartIndex; i--)
                {
                    if ((int)gdv.GetRowValues(i, gdv.KeyFieldName) == attributeID)
                    {
                        gdv.FocusedRowIndex = i;
                        break;
                    }
                }
            }
            else
            {
                gdv.FocusedRowIndex = 0;
            }
        }
        catch (Exception ex)
        {
            if (isCommit)
            {
                tx.Rollback();
            }
            while (ex != null)
            {
                msg = ex.Message + "\n" + msg;
                ex  = ex.InnerException;
            }
            gdv.DataBind();
        }
        objs.Add(new JsonNumericValue("AttributeID", attributeID));
        objs.Add(new JsonStringValue("Message", msg));
        gdv.JSProperties[KEY_CP_RESULT] = objs.ToString();
    }
예제 #6
0
    protected void ASPxGridView1_CustomButtonInitialize(object sender, ASPxGridViewCustomButtonEventArgs e)
    {
        ASPxGridView grid = (ASPxGridView)sender;
        string       flag = grid.GetRowValues(e.VisibleIndex, "HANDLE_FLAG") as string;

        if (flag == "N")
        {
            if (e.ButtonID == "takeSure")
            {
                e.Visible = DefaultBoolean.False;
            }
            if (e.ButtonID == "SURE1")
            {
                e.Visible = DefaultBoolean.False;
            }
            if (e.ButtonID == "SURE2")
            {
                e.Visible = DefaultBoolean.False;
            }
        }
        if (flag == "1")
        {
            if (e.ButtonID == "cancelSure")
            {
                e.Visible = DefaultBoolean.False;
            }
            if (e.ButtonID == "SURE1")
            {
                e.Visible = DefaultBoolean.False;
            }
            if (e.ButtonID == "SURE2")
            {
                e.Visible = DefaultBoolean.False;
            }
        }
        if (flag == "2")
        {
            if (e.ButtonID == "takeSure")
            {
                e.Visible = DefaultBoolean.False;
            }
            if (e.ButtonID == "cancelSure")
            {
                e.Visible = DefaultBoolean.False;
            }
            if (e.ButtonID == "SURE1")
            {
                e.Enabled = false;
            }
            if (e.ButtonID == "SURE2")
            {
                e.Visible = DefaultBoolean.False;
            }
        }
        if (flag == "3")
        {
            if (e.ButtonID == "takeSure")
            {
                e.Visible = DefaultBoolean.False;
            }
            if (e.ButtonID == "cancelSure")
            {
                e.Visible = DefaultBoolean.False;
            }
            if (e.ButtonID == "SURE1")
            {
                e.Visible = DefaultBoolean.False;
            }
            if (e.ButtonID == "SURE2")
            {
                e.Enabled = false;
            }
        }
    }
예제 #7
0
        public void ASPxGridView1_CustomButtonInitialize(object sender, ASPxGridViewCustomButtonEventArgs e)
        {
            ASPxGridView grid         = (ASPxGridView)sender;
            string       run_flag     = grid.GetRowValues(e.VisibleIndex, "RUN_FLAG") as string;
            string       item_flag    = grid.GetRowValues(e.VisibleIndex, "ITEM_FLAG") as string;
            string       third_flag   = grid.GetRowValues(e.VisibleIndex, "THIRD_FLAG") as string;
            string       confirm_flag = grid.GetRowValues(e.VisibleIndex, "CONFIRM_FLAG") as string;

            string    plancode = grid.GetRowValues(e.VisibleIndex, "PLAN_CODE") as string;
            string    sql1     = "select nvl(online_qty,0) from data_plan where plan_code='" + plancode + "' and rownum=1";
            DataTable dt1      = dc.GetTable(sql1);
            string    isonline = "0";

            if (dt1.Rows.Count > 0)
            {
                isonline = dt1.Rows[0][0].ToString();
            }

            switch (e.ButtonID)
            {
            case "Confirm":
                if (e.CellType == GridViewTableCommandCellType.Filter)
                {
                    break;
                }

                if (run_flag == "Y")
                {
                    e.Enabled = false;
                }
                if (run_flag == "N")
                {
                    e.Enabled = true;
                }
                else
                {
                    e.Enabled = false;
                }
                break;

            case "Cancel":
                //if (item_flag == "Y" && confirm_flag == "Y" && run_flag == "Y")
                if (e.CellType == GridViewTableCommandCellType.Filter)
                {
                    break;
                }
                if (run_flag == "Y" && isonline == "0")
                {
                    e.Enabled = true;
                }
                if (isonline != "0")
                {
                    e.Enabled = false;
                }
                if (run_flag == "N")
                {
                    e.Enabled = false;
                }
                break;

            case "Unlock":
                string sql = "select nvl(flag,'Y') from atpujhb_tmp where jhmc='" + plancode + "'";
                if (dc.GetValue(sql) == "Y" || dc.GetTable(sql).Rows.Count == 0)
                {
                    e.Visible = DevExpress.Utils.DefaultBoolean.False;
                }
                break;
            }
        }
예제 #8
0
        public void ASPxGridView1_CustomButtonInitialize(object sender, ASPxGridViewCustomButtonEventArgs e)
        {
            ASPxGridView grid = (ASPxGridView)sender;

            if (grid.GetRowValues(e.VisibleIndex, "GHTM") == null)
            {
                return;
            }
            string lsh  = grid.GetRowValues(e.VisibleIndex, "GHTM") as string;
            string sql  = "select count(1) from qad_bkfl where lsh='" + lsh + "'";
            string sl1  = dc.GetValue(sql);
            string sql2 = "select count(1) from dp_rkwcb where ghtm='" + lsh + "'";
            string sl2  = dc.GetValue(sql2);
            string sql3 = "select count(1) from qad_bkflrecord where lsh1='" + lsh + "'";
            string sl3  = dc.GetValue(sql3);
            int    isl1 = Convert.ToInt32(sl1);
            int    isl2 = Convert.ToInt32(sl2);
            int    isl3 = Convert.ToInt32(sl3);

            //int isl1 = 0;
            //int isl2 = 0;
            //int isl3 = 0;
            switch (e.ButtonID)
            {
            case "Offset1":
                if (e.CellType == GridViewTableCommandCellType.Filter)
                {
                    break;
                }
                if (isl1 > 0)
                {
                    e.Enabled = false;
                    e.Visible = DefaultBoolean.False;
                }
                else if (isl2 > 0)
                {
                    if (isl3 == 0)
                    {
                        e.Enabled = true;
                        e.Visible = DefaultBoolean.True;
                    }
                    else
                    {
                        e.Visible = DefaultBoolean.False;
                    }
                }
                break;

            case "Offset2":
                if (e.CellType == GridViewTableCommandCellType.Filter)
                {
                    break;
                }
                if (isl1 > 0)
                {
                    e.Enabled = false;
                    e.Visible = DefaultBoolean.True;
                }
                else
                {
                    e.Visible = DefaultBoolean.False;
                }
                break;

            case "Offset3":
                if (e.CellType == GridViewTableCommandCellType.Filter)
                {
                    break;
                }
                if (isl1 > 0)
                {
                    e.Enabled = false;
                    e.Visible = DefaultBoolean.False;
                }
                else if (isl2 > 0)
                {
                    if (isl3 == 0)
                    {
                        e.Enabled = false;
                        e.Visible = DefaultBoolean.False;
                    }
                    else
                    {
                        e.Enabled = true;
                        e.Visible = DefaultBoolean.True;
                    }
                }
                break;
            }
        }
        private string GetSelectedRowValueRadioButton(string coluna, ASPxGridView Grid)
        {
            string valor = "";
            string[] valueToGet = { coluna };

            for (int i = 0; i < Grid.VisibleRowCount; i++)
            {
                if (Grid.Selection.IsRowSelected(i))
                {
                    valor = Grid.GetRowValues(i, valueToGet).ToString();
                    break;
                }
            }
            return valor;
        }
        private List<object> GetSelectedRowValues(string aColumnName, ASPxGridView Grid)
        {
            List<object> values = new List<object>();
            string[] valueToGet = { aColumnName };

            for (int i = 0; i < Grid.VisibleRowCount; i++)
            {
                if (Grid.Selection.IsRowSelected(i))
                {
                    values.Add(Grid.GetRowValues(i, valueToGet));
                }
            }

            return values;
        }
예제 #11
0
    public void gridCallBackOption(ASPxGridView grid, string param, string KeyFieldName, SqlDataSource ds)
    {
        try
        {

            HttpCookie myCookie = Request.Cookies[CU.getuserid().ToString()];

            switch (param)
            {
                case "isShowFiltertrue":
                    grid.Settings.ShowFilterBar = GridViewStatusBarMode.Visible;
                    if (myCookie != null) myCookie["GroupFilter"] = "true";
                    break;
                case "isShowFilterfalse":
                    grid.Settings.ShowFilterBar = GridViewStatusBarMode.Hidden;
                    if (myCookie != null) myCookie["GroupFilter"] = "false";
                    break;
                case "isShowHScrolltrue":
                    grid.Settings.HorizontalScrollBarMode = DevExpress.Web.ASPxClasses.ScrollBarMode.Visible;
                    if (myCookie != null) myCookie["HScroll"] = "true";
                    break;
                case "isShowHScrollfalse":
                    grid.Settings.HorizontalScrollBarMode = DevExpress.Web.ASPxClasses.ScrollBarMode.Hidden;
                    if (myCookie != null) myCookie["HScroll"] = "false";
                    break;
                case "isShowHypColtrue":
                    grid.AccessibilityCompliant = true;
                    if (myCookie != null) myCookie["HypCol"] = "true";
                    break;
                case "isShowHypColfalse":
                    grid.AccessibilityCompliant = false;
                    if (myCookie != null) myCookie["HypCol"] = "false";
                    break;
                case "isShowGrouptrue":
                    grid.Settings.ShowGroupPanel = true;
                    if (myCookie != null) myCookie["Grouptrue"] = "true";
                    break;
                case "isShowGroupfalse":
                    grid.Settings.ShowGroupPanel = false;
                    if (myCookie != null) myCookie["Grouptrue"] = "false";
                    break;
            }

            List<object> listKeyValueOK = new List<object>();

            if (param.IndexOf("focus") >= 0)
            {
                int id = 0;
                Int32.TryParse(param.Replace("focus", ""), out id);
                if (id > 0)
                    grid.FocusedRowIndex = grid.FindVisibleIndexByKeyValue(param.Replace("focus", ""));
            }
            else if (param.IndexOf("action") >= 0)
            {
                int action = int.Parse(param.Replace("action", ""));

                List<object> listkeyvalue = grid.GetSelectedFieldValues(grid.KeyFieldName);
                SiAuto.Main.LogColored(System.Drawing.Color.Purple, grid.KeyFieldName + "Số dòng :" + listkeyvalue.Count);
                if (listkeyvalue.Count > 0)
                {
                    for (int i = 0; i < listkeyvalue.Count; i++)
                    {
                        SiAuto.Main.LogColored(System.Drawing.Color.Purple, "key so :" + i.ToString() + "----" + listkeyvalue[i]);
                        string currentCode = "isApproved=" + action + " AND " + grid.KeyFieldName + "=" + listkeyvalue[i];
                        bool check = EU.CheckByModuleD(globalModuleID, currentCode);
                        if (check == true)
                        {
                            var values = new Dictionary<string, object>
                        {
                            {"isApproved",action},
                            {grid.KeyFieldName,listkeyvalue[i]}
                        };

                            EU.updateTblScript(globalModuleID, values);
                            listKeyValueOK.Add(listkeyvalue[i]);
                        }
                    }

                    if (listKeyValueOK.Count > 0)
                    {
                        if (action == 1)
                        {
                            WorkFlowManager.BuildTaskByWhenExecute(globalModuleID, "APPROVED", string.Join(";", listKeyValueOK));
                            UserUtils.Log(CU.getLoginID(), globalModuleID, -1, string.Join(";", listKeyValueOK), "", "Duyệt thành công !", "APPROVED");
                        }
                        else
                        {
                            WorkFlowManager.BuildTaskByWhenExecute(globalModuleID, "NOTAPPROVED", string.Join(";", listKeyValueOK));
                            UserUtils.Log(CU.getLoginID(), globalModuleID, -1, string.Join(";", listKeyValueOK), "", "Bỏ duyệt thành công !", "NOTAPPROVED");
                        }
                        listKeyValueOK.Clear();
                    }
                }
                else
                {
                    object currentFocused = grid.GetRowValues(grid.FocusedRowIndex, grid.KeyFieldName);
                    string currentCode = "isApproved=" + action + " AND " + grid.KeyFieldName + "=" + currentFocused.ToString();
                    bool check = EU.CheckByModuleD(globalModuleID, currentCode);
                    if (check == true)
                    {
                        if (currentFocused != null)
                        {
                            var values = new Dictionary<string, object>{
                            {"isApproved",action},
                            {grid.KeyFieldName,currentFocused}
                        };
                            EU.updateTblScript(globalModuleID, values);

                            if (action == 1)
                            {
                                SiAuto.Main.LogColored(Color.Green, "Chuan bi workflow APPROVED");
                                WorkFlowManager.BuildTaskByWhenExecute(globalModuleID, "APPROVED", currentFocused.ToString());
                                SiAuto.Main.LogColored(Color.Green, "End workflow APPROVED");

                                SiAuto.Main.LogColored(Color.Green, "ghi vao tray - bảng SY_audit_trail APPROVED");
                                //UserUtils.Log(CU.getLoginID(), globalModuleID, -1, currentFocused.ToString(), "", "Duyệt thành công !", "APPROVED");
                                SiAuto.Main.LogColored(Color.Green, "end tray ");
                            }
                            else
                            {
                                SiAuto.Main.LogColored(Color.Green, "Chuan bi workflow NOTAPPROVED");
                                WorkFlowManager.BuildTaskByWhenExecute(globalModuleID, "NOTAPPROVED", currentFocused.ToString());
                                SiAuto.Main.LogColored(Color.Green, "End workflow NOTAPPROVED");

                                SiAuto.Main.LogColored(Color.Green, "ghi vao tray - bảng SY_audit_trail NOTAPPROVED");
                                //UserUtils.Log(CU.getLoginID(), globalModuleID, -1, currentFocused.ToString(), "", "Bỏ duyệt thành công !", "NOTAPPROVED");
                                SiAuto.Main.LogColored(Color.Green, "end tray NOTAPPROVED");
                            }
                        }
                    }
                }
                UserUtils.Log(CU.getLoginID(), globalModuleID, -1, -1, listkeyvalue.ToString(), "", "APPROVED :" + action);
            }

            else if (param.IndexOf("delselect") >= 0)
            {
                List<object> listid = grid.GetSelectedFieldValues(new string[] { grid.KeyFieldName });

                if (listid.Count > 0)
                {
                    for (int i = 0; i < listid.Count; i++)
                    {
                        SiAuto.Main.LogColored(System.Drawing.Color.Purple, "key so :" + i.ToString() + "----" + listid[i]);
                        string currentCode = "isDeleted=1 AND " + grid.KeyFieldName + "=" + listid[i];
                        bool check = EU.CheckByModuleD(globalModuleID, currentCode);
                        if (check == true)
                        {
                            string rowDeleted = EU.deleteMultiTblScript(globalModuleID, grid.KeyFieldName, string.Join(",", listid));
                            listKeyValueOK.Add(listid[i]);
                        }
                    }
                    if (listKeyValueOK.Count > 0)
                    {
                        WorkFlowManager.BuildTaskByWhenExecute(globalModuleID, "DELETED", string.Join(";", listKeyValueOK));
                        listKeyValueOK.Clear();
                    }
                }
                else
                {
                    object currentFocused = grid.GetRowValues(grid.FocusedRowIndex, grid.KeyFieldName);
                    if (currentFocused != null)
                    {
                        string currentCode = "isDeleted=1 AND " + grid.KeyFieldName + "=" + currentFocused.ToString();
                        bool check = EU.CheckByModuleD(globalModuleID, currentCode);
                        if (check == true)
                        {
                            string rowDeleted = EU.deleteMultiTblScript(globalModuleID, grid.KeyFieldName, string.Join(",", currentFocused.ToString()));
                            if (int.Parse(rowDeleted) > 0)
                            {
                                SiAuto.Main.LogColored(Color.Green, "Chuan bi workflow DELETED");
                                WorkFlowManager.BuildTaskByWhenExecute(globalModuleID, "DELETED", currentFocused.ToString());
                                SiAuto.Main.LogColored(Color.Green, "End workflow DELETED");

                                SiAuto.Main.LogColored(Color.Green, "ghi vao tray - bảng SY_audit_trail DELETED");
                                UserUtils.Log(CU.getLoginID(), globalModuleID, -1, int.Parse(currentFocused.ToString()), "", "Xóa thành công !", "DELETED");
                                SiAuto.Main.LogColored(Color.Green, "end tray DELETED");
                            }

                        }
                    }
                }

            }
            else if (param.IndexOf("RestoreSelect") >= 0)
            {

                List<object> listid = grid.GetSelectedFieldValues(new string[] { grid.KeyFieldName });
                if (listid.Count > 0)
                {
                    for (int i = 0; i < listid.Count; i++)
                    {
                        SiAuto.Main.LogColored(System.Drawing.Color.Purple, "key so :" + i.ToString() + "----" + listid[i]);
                        string currentCode = "isDeleted=0 AND " + grid.KeyFieldName + "=" + listid[i];
                        bool check = EU.CheckByModuleD(globalModuleID, currentCode);
                        if (check == true)
                        {
                            string rowDeleted = EU.restoreMultiTblScript(globalModuleID, grid.KeyFieldName, string.Join(",", listid));
                            listKeyValueOK.Add(listid[i]);
                        }
                    }
                    if (listKeyValueOK.Count > 0)
                    {
                        WorkFlowManager.BuildTaskByWhenExecute(globalModuleID, "RESTORED", string.Join(";", listKeyValueOK));
                        listKeyValueOK.Clear();
                    }
                }
                else
                {
                    object currentFocused = grid.GetRowValues(grid.FocusedRowIndex, grid.KeyFieldName);
                    if (currentFocused != null)
                    {
                        string currentCode = "isDeleted=0 AND " + grid.KeyFieldName + "=" + currentFocused.ToString();
                        bool check = EU.CheckByModuleD(globalModuleID, currentCode);
                        if (check == true)
                        {
                            string rowDeleted = EU.restoreMultiTblScript(globalModuleID, grid.KeyFieldName, string.Join(",", currentFocused.ToString()));
                            if (int.Parse(rowDeleted) > 0)
                            {
                                SiAuto.Main.LogColored(Color.Green, "Chuan bi workflow RESTORED");
                                WorkFlowManager.BuildTaskByWhenExecute(globalModuleID, "RESTORED", currentFocused.ToString());
                                SiAuto.Main.LogColored(Color.Green, "End workflow RESTORED");

                                SiAuto.Main.LogColored(Color.Green, "ghi vao tray - bảng SY_audit_trail RESTORED");
                                UserUtils.Log(CU.getLoginID(), globalModuleID, -1, int.Parse(currentFocused.ToString()), "", "Phục hồi thành công !", "RESTORED");
                                SiAuto.Main.LogColored(Color.Green, "end tray RESTORED");
                            }
                        }
                    }
                }
            }
            grid.DataBind();
            if (myCookie != null) Response.Cookies.Set(myCookie);
        }
        catch (Exception ex)
        {

            throw new Exception(ex.Message);
        }
    }
예제 #12
0
 int GetGridViewKeyByVisibleIndex(ASPxGridView gridView, int visibleIndex)
 {
     return((int)gridView.GetRowValues(visibleIndex, gridView.KeyFieldName));
 }
        private List<object> GetSelectRowValueRadioNovo(string coluna1, string coluna2, string coluna3, string coluna4, string coluna5, ASPxGridView Grid)
        {
            List<object> matrix = new List<object>();
            //            List<object> values = new List<object>();

            string[] keyValueToGet = { coluna1 };
            string[] valueToGet = { coluna2 };
            string[] colunaAUX = { coluna3 };
            string[] COLUNA4 = { coluna4 };
            string[] COLUNA5 = { coluna5 };

            for (int i = 0; i < Grid.VisibleRowCount; i++)
            {
                if (Grid.Selection.IsRowSelected(i))
                {
                    List<object> values = new List<object>();
                    values.Add(Grid.GetRowValues(i, keyValueToGet));
                    values.Add(Grid.GetRowValues(i, valueToGet));
                    values.Add(Grid.GetRowValues(i, colunaAUX));
                    values.Add(Grid.GetRowValues(i, COLUNA4));
                    values.Add(Grid.GetRowValues(i, COLUNA5));
                    matrix.Add(values);
                }
            }

            return matrix;
        }
예제 #14
0
    protected void gridEmployees_CustomCallback(object source, ASPxGridViewCustomCallbackEventArgs e)
    {
        string       param = e.Parameters.ToString();
        ASPxGridView gdv   = source as ASPxGridView;

        gdv.JSProperties[JSPROPERTY_CALLBACK_TYPE] = param;
        switch (param)
        {
        case GRID_INVERSE:
            if (gdv.VisibleRowCount > 0)
            {
                for (int i = 0; i < gdv.VisibleRowCount; i++)
                {
                    gdv.Selection.SetSelection(i, !gdv.Selection.IsRowSelected(i));
                }
            }
            break;

        case GRID_BINDING:
            gdv.DataBind();
            break;

        case GRID_SELECT_BY_VALUE:
            if (gdv.VisibleRowCount > 0 && bteEmployees.Text.Length > 0)
            {
                DataRow dr;
                if (multiSelection)
                {
                    string[] employeesNos = bteEmployees.Text.Split(',');
                    if (employeesNos.Length > 0)
                    {
                        bool          isContain;
                        StringBuilder accounts     = new StringBuilder();
                        StringBuilder selectedText = new StringBuilder();
                        StringBuilder employeeNos  = new StringBuilder();
                        for (int i = 0; i < gdv.VisibleRowCount; i++)
                        {
                            dr        = gdv.GetDataRow(i);
                            isContain = employeesNos.Contains <string>(dr[FIELDNAME_EMPLOYEENO].ToString());
                            gdv.Selection.SetSelection(i, isContain);
                            if (isContain)
                            {
                                accounts.AppendFormat(",{0}", dr[FIELDNAME_ACCOUNTID]);
                                employeeNos.AppendFormat(",{0}", dr[FIELDNAME_EMPLOYEENO]);
                                selectedText.AppendFormat("<br>{0} - {1} - {2}", dr[FIELDNAME_DIVISIONCODE],
                                                          dr[FIELDNAME_EMPLOYEENO], dr[FIELDNAME_EMPLOYEENAME]);
                            }
                        }
                        if (accounts.Length > 0)
                        {
                            //gdv.JSProperties[JSPROPERTY_LBL_SELECTED] = TEXT_EMPLOYEES;
                            gdv.JSProperties[JSPROPERTY_TEXT_POPUP_SELECTED] = selectedText.ToString();
                            gdv.JSProperties[JSPROPERTY_SELECTED_ACCOUNTID]  = accounts.ToString().Substring(1);
                            gdv.JSProperties[JSPROPERTY_SELECTED_EMPLOYEENO] = employeeNos.ToString().Substring(1);
                            return;
                        }
                    }
                }
                else
                {
                    for (int i = 0; i < gdv.VisibleRowCount; i++)
                    {
                        dr = gdv.GetDataRow(i);
                        gdv.Selection.SetSelection(i, bteEmployees.Text == dr[FIELDNAME_EMPLOYEENO].ToString());
                        if (gdv.Selection.IsRowSelected(i))
                        {
                            gdv.JSProperties[JSPROPERTY_LBL_SELECTED]        = dr[FIELDNAME_EMPLOYEENAME];
                            gdv.JSProperties[JSPROPERTY_SELECTED_ACCOUNTID]  = dr[FIELDNAME_ACCOUNTID];
                            gdv.JSProperties[JSPROPERTY_SELECTED_EMPLOYEENO] = dr[FIELDNAME_EMPLOYEENO];
                            return;
                        }
                    }
                }
            }
            gdv.Selection.UnselectAll();
            gdv.JSProperties[JSPROPERTY_LBL_SELECTED]        = "";
            gdv.JSProperties[JSPROPERTY_TEXT_POPUP_SELECTED] = "";
            gdv.JSProperties[JSPROPERTY_SELECTED_ACCOUNTID]  = "";
            gdv.JSProperties[JSPROPERTY_SELECTED_EMPLOYEENO] = "";

            break;

        case GRID_SELECTED:
            if (gdv.VisibleRowCount > 0)
            {
                if (multiSelection)
                {
                    StringBuilder accounts     = new StringBuilder();
                    StringBuilder selectedText = new StringBuilder();
                    StringBuilder employeeNos  = new StringBuilder();
                    List <object> selectedList = gdv.GetSelectedFieldValues(FIELDNAME_ACCOUNTID, FIELDNAME_DIVISIONCODE
                                                                            , FIELDNAME_EMPLOYEENO, FIELDNAME_EMPLOYEENAME);
                    foreach (object obj in selectedList)
                    {
                        object[] data = obj as object[];
                        accounts.AppendFormat(",{0}", data[0]);
                        employeeNos.AppendFormat(",{0}", data[2]);
                        selectedText.AppendFormat("<br>{0} - {1} - {2}", data[1], data[2], data[3]);
                    }
                    if (accounts.Length > 0)
                    {
                        //gdv.JSProperties[JSPROPERTY_LBL_SELECTED] = TEXT_EMPLOYEES;
                        gdv.JSProperties[JSPROPERTY_TEXT_POPUP_SELECTED] = selectedText.ToString();
                        gdv.JSProperties[JSPROPERTY_SELECTED_ACCOUNTID]  = accounts.ToString().Substring(1);
                        gdv.JSProperties[JSPROPERTY_SELECTED_EMPLOYEENO] = employeeNos.ToString().Substring(1);
                    }
                    else
                    {
                        //gdv.JSProperties[JSPROPERTY_LBL_SELECTED] = "";
                        gdv.JSProperties[JSPROPERTY_TEXT_POPUP_SELECTED] = "";
                        gdv.JSProperties[JSPROPERTY_SELECTED_ACCOUNTID]  = "";
                        gdv.JSProperties[JSPROPERTY_SELECTED_EMPLOYEENO] = "";
                    }
                }
                else
                {
                    int      index = Int32.Parse(hddEmployeesSelected[HDDKEY_SELECTED_INDEX].ToString());
                    object[] data  = gdv.GetRowValues(index, FIELDNAME_ACCOUNTID, FIELDNAME_EMPLOYEENO
                                                      , FIELDNAME_EMPLOYEENAME) as object[];
                    gdv.JSProperties[JSPROPERTY_SELECTED_ACCOUNTID]  = data[0];
                    gdv.JSProperties[JSPROPERTY_SELECTED_EMPLOYEENO] = data[1];
                    gdv.JSProperties[JSPROPERTY_LBL_SELECTED]        = data[2];
                    gdv.Selection.UnselectAll();
                    gdv.Selection.SetSelection(index, true);
                }
            }
            break;

        case GRID_UNDO_SELECTED:
            gdv.Selection.UnselectAll();
            if (!hddEmployeesSelected.Contains(HDDKEY_EMPLOYEES_SELECTED) ||
                String.IsNullOrEmpty(hddEmployeesSelected[HDDKEY_EMPLOYEES_SELECTED].ToString()))
            {
                return;
            }
            string[] keys = hddEmployeesSelected[HDDKEY_EMPLOYEES_SELECTED].ToString().Split(',');
            foreach (string key in keys)
            {
                gdv.Selection.SetSelectionByKey(Int32.Parse(key), true);
            }
            break;

        default: break;
        }
    }
예제 #15
0
    /// <summary>
    /// this event is not being used, we are using client side asynchronous callbacks and webmethod get_secure_url so we can open page in new window
    /// custom command buttons vierw/edit/delete (maybe?)
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void dxgridOrders_CustomButtonCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomButtonCallbackEventArgs e)
    {
        ASPxGridView _grid = (ASPxGridView)sender;
        //get order number off grid
        //string[] _fields = { "OrderNumber", "OrderID" };
        //pass order no, id as encryped data
        string _orderno = wwi_security.EncryptString(_grid.GetRowValues(e.VisibleIndex, "OrderNumber").ToString(), "publiship");
        string _orderid = wwi_security.EncryptString(_grid.GetRowValues(e.VisibleIndex, "OrderID").ToString(), "publiship");

        //track requesting page so we can return to it
        string _req = this.dxhfOrder.Get("req").ToString(); //populated on page load   //wwi_security.EncryptString("Search", "publiship");

        //page to redirect build as required
        string _page = "";

        switch (e.ButtonID.ToString())
        {
        case "cmdView":
        {
            //send orderid and orderno as related tables are linked by orderno not orderid
            _page = string.Format("../shipment_orders/order.aspx?mode={0}&pid={1}&req={2}&pno={3}", "ReadOnly", _orderid, _req, _orderno);
            DevExpress.Web.ASPxClasses.ASPxWebControl.RedirectOnCallback(_page);          //Response.Redirect(_page);
            break;
        }

        case "cmdEdit":
        {
            //send orderid and orderno as related tables are linked by orderno not orderid
            _page = string.Format("../shipment_orders/order.aspx?mode={0}&pid={1}&req={2}&pno={3}", "Edit", _orderid, _req, _orderno);
            DevExpress.Web.ASPxClasses.ASPxWebControl.RedirectOnCallback(_page);         //Response.Redirect(_page);
            break;
        }

        case "cmdViewFilter":     //deprecated we no longer use seperate order_view.aspx so just use cmdView
        {
            _page = string.Format("../shipment_orders/order_view.aspx?mode={0}&pid={1}&req={2}", "ReadOnly", _orderid, _req);
            DevExpress.Web.ASPxClasses.ASPxWebControl.RedirectOnCallback(_page);         //Response.Redirect(_page);
            break;
        }

        case "cmdEditFilter":     //deprecated
        {
            _page = string.Format("../shipment_orders/order_edit.aspx?mode={0}&pid={1}&req={2}", "Edit", _orderid, _req);
            DevExpress.Web.ASPxClasses.ASPxWebControl.RedirectOnCallback(_page);         //Response.Redirect(_page);
            break;
        }

        case "cmdOrderSheet":     //order sheet
        {
            _page = string.Format("../shipment_orders/order_sheet.aspx?pno={0}", _orderno);
            //DevExpress.Web.ASPxClasses.ASPxWebControl.RedirectOnCallback(_page); //Response.Redirect(_page);
            //**** this code does not work
            //string _err = itextsharp_out.advance_labels(120600005);
            //_page = string.Format("~/Order_View.aspx?pno={0}", _orderno);
            //DevExpress.Web.ASPxClasses.ASPxWebControl.RedirectOnCallback(_page);  //Response.Redirect(_page);
            //****
            //string _err = itextsharp_out.order_sheet(wwi_func.vint(_orderno));
            //if (_err != "") {
            //    this.dxlblErr.Text = _err;
            //    this.dxpnlErr.Visible = true; }
            break;
        }

        case "cmdTemplate":     //make template out of selected order
        {
            _page = string.Format("../system_templates/order_template.aspx?pid={0}&mode={1}", _orderid, "Insert");
            DevExpress.Web.ASPxClasses.ASPxWebControl.RedirectOnCallback(_page);         //Response.Redirect(_page);
            break;
        }

        case "cmdClone":     //make identical copy of selected order
        {
            _page = string.Format("../shipment_orders/clone_order.aspx?pid={0}&pno={1}", _orderid, _orderno);
            DevExpress.Web.ASPxClasses.ASPxWebControl.RedirectOnCallback(_page);         //Response.Redirect(_page);
            break;
        }

        default:
        {
            break;
        }
        }//end switch
    }
예제 #16
0
    //end databound

    /// <summary>
    /// called from custom command buttons in gridview
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void grid_CustomButtonCallback(object sender, ASPxGridViewCustomButtonCallbackEventArgs e)
    {
        if (e.ButtonID != "cmdRemove")
        {
            return;
        }

        string[] _f = new string[] { "DateOrderReceived", "Payee", "DeliveryAddress", "DestinationCountry",
                                     "Titles", "Cartons", "Fao" };

        //user id
        Int32 _user = Session["user"] != null ? (Int32)((UserClass)Page.Session["user"]).UserId : 0;

        //get rows values from grid
        ASPxGridView _g  = (ASPxGridView)sender;
        object       _id = _g.GetRowValues(e.VisibleIndex, _g.KeyFieldName);
        object       _rw = _g.GetRowValues(e.VisibleIndex, _f);
        //convert object to ienumerable so we can step through values
        IEnumerable _enum = wwi_func.get_object_to_ienum(_rw);

        if (_id != null && _user != 0)
        {
            Int32  _cid   = (Int32)((UserClass)Page.Session["user"]).CompanyId;
            string _uname = (string)((UserClass)Page.Session["user"]).UserName;
            //for testing
            //_cid = 99;
            //
            //publiship users can just update the order, clients must send a request for cancellation
            if (_cid == -1)
            {
                //log cancellation
                int _updated = new Update(PublishipAdvanceOrderTable.Schema)
                               .Set(PublishipAdvanceOrderTable.Columns.CancelDate).EqualTo(DateTime.Now.ToShortDateString())
                               .Set(PublishipAdvanceOrderTable.Columns.CancelledByID).EqualTo(_user)
                               .Set(PublishipAdvanceOrderTable.Columns.OrderCancelled).EqualTo(true)
                               .Where(PublishipAdvanceOrderTable.Columns.OrderID).IsEqualTo(_id).Execute();

                //confirm cancellation to client and publiship
                if (_updated > 0)
                {
                    //string _test = return_html_content(_enum, _f);
                    send_advance_email(_id.ToString(), "Order Ref. " + _id + " has been cancelled", return_html_content(_enum, _f));
                }
            }
            else
            {
                //log request
                int _updated = new Update(PublishipAdvanceOrderTable.Schema)
                               .Set(PublishipAdvanceOrderTable.Columns.CancelRequestRcd).EqualTo(DateTime.Now.ToShortDateString())
                               .Set(PublishipAdvanceOrderTable.Columns.CancelRequestByID).EqualTo(_user)
                               .Where(PublishipAdvanceOrderTable.Columns.OrderID).IsEqualTo(_id).Execute();

                //confirm request received to client and publiship
                if (_updated > 0)
                {
                    //string _test = return_html_content(_enum, _f);
                    send_advance_email(_id.ToString(), "Cancellation request for order ID " + _id.ToString() + " from " + _uname, return_html_content(_enum, _f));
                }
            }
        }
    }
예제 #17
0
        protected void Submit_Click(object sender, EventArgs e)
        {
            bool         cancel = false;
            ASPxGridView grid   = POAddEditGrid as ASPxGridView;

            for (int i = 0; i < grid.VisibleRowCount; i++)
            {
                object taxgroup     = grid.GetRowValues(i, "TaxGroup");
                object taxitemgroup = grid.GetRowValues(i, "TaxItemGroup");
                object identifier   = grid.GetRowValues(i, "Identifier");
                object cip          = grid.GetRowValues(i, "CapexCIP");
                object prodcat      = grid.GetRowValues(i, "ProdCat");

                if (string.IsNullOrEmpty(taxgroup.ToString()) || string.IsNullOrEmpty(taxitemgroup.ToString()))
                {
                    cancel = true;
                    break;
                }

                if (identifier.ToString() == "4")
                {
                    MRPClass.PrintString(prodcat.ToString());
                    MRPClass.PrintString(string.IsNullOrEmpty(cip.ToString()).ToString());
                    if (prodcat.ToString() != "CIP")
                    {
                        if (string.IsNullOrEmpty(cip.ToString()))
                        {
                            cancel = true;
                            break;
                        }
                    }
                }
            }
            if (cancel)//if empty taxgroup this is true
            {
                ModalPopupExtenderLoading.Hide();
                PONotify.HeaderText     = "Alert";
                PONotifyLbl.Text        = "Some selected items are empty.";
                PONotify.ShowOnPageLoad = true;
            }
            else
            {
                if (grid.VisibleRowCount > 0)
                {
                    //Submit_Method();
                    //POClass.SubmitToAX(ponumber, PONotify, PONotifyLbl, ModalPopupExtenderLoading);

                    POClass.SubmitToAXTable(ponumber, Session["UserCompleteName"].ToString(), PONotify, PONotifyLbl, ModalPopupExtenderLoading);
                }

                else
                {
                    ModalPopupExtenderLoading.Hide();

                    Submit.ClientEnabled    = false;
                    PONotify.HeaderText     = "Alert";
                    PONotifyLbl.Text        = "No data to submit";
                    PONotify.ShowOnPageLoad = true;
                }
            }

            ScriptManager.RegisterStartupScript(this.Page, typeof(string), "Resize", "changeWidth.resizeWidth();", true);
            BindData();
        }
예제 #18
0
        public static void Save_HLSSOA(string sSOANum, DateTime dSOADate, int iYear, int iWeek, string sCustCode, string sRemarks, string sPreparedBy, string sPreparedByPost, string sCheckedBy, string sCheckedByPost, string sApprovedBy, string sApprovedByPost, ASPxGridView grdWaybills, string sAttention, string sAttentionNum)
        {
            SqlConnection  cn     = new SqlConnection(GlobalClass.SQLConnString());
            SqlCommand     cmdIns = null;
            DataTable      dt     = new DataTable();
            SqlCommand     cmd    = null;
            SqlDataAdapter adp;
            int            iMasterKey = 0;

            cn.Open();
            string sInsert = "INSERT INTO tbl_HLS_StatementOfAccount (SOANum, SOADate, YearNo, WeekNo, CustomerCode, Remarks, PreparedBy, PreparedByPost, CheckedBy, CheckedByPost, ApprovedBy, ApprovedByPost) VALUES (@SOANum, @SOADate, @YearNo, @WeekNo, @CustomerCode, @Remarks, @PreparedBy, @PreparedByPost, @CheckedBy, @CheckedByPost, @ApprovedBy, @ApprovedByPost)";

            cmdIns = new SqlCommand(sInsert, cn);
            cmdIns.Parameters.AddWithValue("@SOANum", sSOANum);
            cmdIns.Parameters.AddWithValue("@SOADate", dSOADate);
            cmdIns.Parameters.AddWithValue("@YearNo", iYear);
            cmdIns.Parameters.AddWithValue("@WeekNo", iWeek);
            cmdIns.Parameters.AddWithValue("@CustomerCode", sCustCode);
            cmdIns.Parameters.AddWithValue("@Remarks", sRemarks);
            cmdIns.Parameters.AddWithValue("@PreparedBy", sPreparedBy);
            cmdIns.Parameters.AddWithValue("@PreparedByPost", sPreparedByPost);
            cmdIns.Parameters.AddWithValue("@CheckedBy", sCheckedBy);
            cmdIns.Parameters.AddWithValue("@CheckedByPost", sCheckedByPost);
            cmdIns.Parameters.AddWithValue("@ApprovedBy", sApprovedBy);
            cmdIns.Parameters.AddWithValue("@ApprovedByPost", sApprovedByPost);
            cmdIns.ExecuteNonQuery();

            string query = "SELECT PK FROM tbl_HLS_StatementOfAccount WHERE (SOANum = '" + sSOANum + "')";

            cmd            = new SqlCommand(query);
            cmd.Connection = cn;
            adp            = new SqlDataAdapter(cmd);
            adp.Fill(dt);
            if (dt.Rows.Count > 0)
            {
                foreach (DataRow row in dt.Rows)
                {
                    iMasterKey = Convert.ToInt32(row["PK"]);
                }
            }
            dt.Clear();

            if (iMasterKey > 0)
            {
                for (int i = 0; i <= (grdWaybills.VisibleRowCount - 1); i++)
                {
                    object keyValue = grdWaybills.GetRowValues(i, "Waybill");
                    sInsert = "INSERT INTO tbl_HLS_StatementOfAccount_Details (MasterKey, Line, WaybillNum) VALUES (@MasterKey, @Line, @WaybillNum)";
                    cmdIns  = new SqlCommand(sInsert, cn);
                    cmdIns.Parameters.AddWithValue("@MasterKey", iMasterKey);
                    cmdIns.Parameters.AddWithValue("@Line", i + 1);
                    cmdIns.Parameters.AddWithValue("@WaybillNum", keyValue.ToString());
                    cmdIns.ExecuteNonQuery();
                }
            }

            query          = "SELECT tbl_HLS_CustomerAttention.* FROM tbl_HLS_CustomerAttention WHERE (CustCode = '" + sCustCode + "')";
            cmd            = new SqlCommand(query);
            cmd.Connection = cn;
            adp            = new SqlDataAdapter(cmd);
            adp.Fill(dt);
            if (dt.Rows.Count > 0)
            {
                sInsert = "UPDATE tbl_HLS_CustomerAttention SET AttentionName = @AttentionName, AttentionNumber = @AttentionNumber) WHERE (CustCode = @CustCode)";
                cmdIns  = new SqlCommand(sInsert, cn);
                cmdIns.Parameters.AddWithValue("@CustCode", sCustCode);
                cmdIns.Parameters.AddWithValue("@AttentionName", sAttention);
                cmdIns.Parameters.AddWithValue("@AttentionNumber", sAttentionNum);
                cmdIns.ExecuteNonQuery();
            }
            else
            {
                sInsert = "INSERT INTO tbl_HLS_CustomerAttention (CustCode, AttentionName, AttentionNumber) VALUES (@CustCode, @AttentionName, @AttentionNumber)";
                cmdIns  = new SqlCommand(sInsert, cn);
                cmdIns.Parameters.AddWithValue("@CustCode", sCustCode);
                cmdIns.Parameters.AddWithValue("@AttentionName", sAttention);
                cmdIns.Parameters.AddWithValue("@AttentionNumber", sAttentionNum);
                cmdIns.ExecuteNonQuery();
            }
            dt.Clear();

            cn.Close();
        }
예제 #19
0
 object GetVersionField(ASPxGridView grid)
 {
     return(grid.GetRowValues(grid.EditingRowVisibleIndex, "Version"));
 }
예제 #20
0
 private TaskStruct GetTSFromGV(ASPxGridView gridView)
 {
     TaskStruct res = new TaskStruct();
     res.Description = (string)gridView.GetRowValues(gridView.FocusedRowIndex, "f1");
     res.Value = (string)gridView.GetRowValues(gridView.FocusedRowIndex, "f2");
     Page.DataBind();
     return res;
 }
예제 #21
0
        //Metodo que se ejecuta cuando se da clic en botón eliminar, descargar archivo o procesar archivo
        protected void ASPxGridView1_CustomButtonCallback(object sender, DevExpress.Web.ASPxGridViewCustomButtonCallbackEventArgs e)
        {
            try
            {
                if (Session["Cadena"] == null)
                {
                    Response.Redirect("Login.aspx");
                    return;
                }

                //ds_filesDS.ConnectionString = Session["Cadena"].ToString();

                string cmdString  = string.Empty;
                string connString = Session["Cadena"].ToString();

                ASPxGridView grid = sender as ASPxGridView;
                var          tmp  = grid.GetRowValues(e.VisibleIndex, grid.KeyFieldName);

                DataTable dt = new DataTable();

                if (e.ButtonID == "btnEliminar")
                {
                    cmdString = "DELETE FROM [FILESPECA] WHERE [FPKEY] = @FPKEY";
                    using (SqlConnection conn = new SqlConnection(connString))
                    {
                        conn.Open();
                        using (SqlCommand comm = new SqlCommand())
                        {
                            comm.Connection  = conn;
                            comm.CommandText = cmdString;
                            comm.Parameters.Add("@FPKEY", SqlDbType.UniqueIdentifier).Value = tmp;
                            using (SqlDataReader reader = comm.ExecuteReader())
                            {
                                if (!reader.HasRows)
                                {
                                    dt = null;
                                }
                                else
                                {
                                    dt.Load(reader);
                                }
                            }
                        }
                        conn.Close();
                    }

                    //Se actualiza grid
                    UpdateGrid();
                    AlertSuccess("Archivo eliminado con éxito");
                }
                else if (e.ButtonID == "ID_DOWNLOAD")
                {
                    byte[] bytes         = null;
                    string nombreArchivo = "";
                    var    parent        = System.IO.Directory.GetParent(Environment.CurrentDirectory);
                    string path          = parent.Parent + "\\DS";
                    string target        = path + "";

                    //Crea un directorio
                    if (!Directory.Exists(target))
                    {
                        Directory.CreateDirectory(target);
                    }

                    cmdString = "SELECT TOP 1 ARCHIVO, PECANAME FROM [FILESPECA] WHERE [FPKEY] = @val1 ";
                    using (SqlConnection conn = new SqlConnection(connString))
                    {
                        using (SqlCommand comm = new SqlCommand())
                        {
                            comm.Connection  = conn;
                            comm.CommandText = cmdString;
                            comm.Parameters.Add("@val1", SqlDbType.UniqueIdentifier).Value = tmp;

                            conn.Open();
                            SqlDataReader reader = comm.ExecuteReader();

                            if (!reader.HasRows)
                            {
                                dt = null;
                            }
                            else
                            {
                                reader.Read();
                                bytes         = (byte[])reader["ARCHIVO"];
                                nombreArchivo = (string)reader["PECANAME"];

                                File.WriteAllBytes(path + "\\" + nombreArchivo, bytes);
                                AlertSuccess("Se descargo el archivo: " + nombreArchivo);
                            }
                        }

                        //(sender as ASPxGridView).JSProperties["cpResult"] = "DS\\" + nombreArchivo;
                        conn.Close();
                    }
                }

                if (e.ButtonID == "ID_PROCESAR")
                {
                    // AQUI SE DEBE MANDAR A EJECUTAR EL SP QUE PROCESA LOS ARCHIVOS.

                    try
                    {
                        string rfc = Session["RFC"].ToString().Trim();
                        if (rfc == null)
                        {
                            Response.Redirect("Login.aspx");
                            return;
                        }

                        TRespuesta res;
                        IExpedienteComercioservice v1 = new IExpedienteComercioservice();
                        res = v1.Procesapeca(tmp.ToString(), rfc);
                        string respuesta = res.ToString();
                    }
                    catch (Exception exc)
                    {
                        int    idusuario = 0;
                        string mensaje   = "";
                        if (Session["IdUsuario"] != null)
                        {
                            idusuario = int.Parse(Session["IdUsuario"].ToString());
                        }
                        excepcion.RegistrarExcepcion(idusuario, "ASPxGridView1_CustomButtonCallback", exc, lblCadena.Text, ref mensaje);

                        AlertError("Error al conectarse con el WebServices, intentelo más tarde");
                    }

                    //Se actualiza grid
                    UpdateGrid();
                }
            }
            catch (Exception ex)
            {
                AlertError(ex.Message);

                int    idusuario = 0;
                string mensaje   = "";
                if (Session["IdUsuario"] != null)
                {
                    idusuario = int.Parse(Session["IdUsuario"].ToString());
                }
                excepcion.RegistrarExcepcion(idusuario, "CargasPeca-ASPxGridView1_CustomButtonCallback", ex, lblCadena.Text, ref mensaje);
            }
        }
        protected void Save_Click(object sender, EventArgs e)
        {
            CheckCreatorKey();

            SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString());

            conn.Open();
            SqlDataReader reader = null;

            SqlCommand     cmd = null;
            DataTable      dt  = new DataTable();
            SqlDataAdapter adp;

            //Declare Variables
            string DocPref = "", strDocNum = "", PONumber = "", delete = "", update = "", query = "", insert = "", insert_po_details = "";
            int    POSeriesNum = 0;

            string mopnumber = MOPReference.Text;
            string entitycode = "", bucode = "";

            query  = "SELECT [PK],[EntityCode],[BUCode] FROM[dbo].[tbl_MRP_List] WHERE DocNumber = '" + mopnumber + "'";
            cmd    = new SqlCommand(query, conn);
            reader = cmd.ExecuteReader();
            while (reader.Read())
            {
                entitycode = reader["EntityCode"].ToString();
                bucode     = reader["BUCode"].ToString();
            }
            reader.Close();

            string vendor    = Vendor.Text.ToString();
            string payment   = Terms.Text.ToString();
            string currency  = Currency.Text.ToString();
            string site      = Site.Text.ToString();
            string warehouse = Warehouse.Text.ToString();
            string location  = Location.Text.ToString();
            string remarks   = Remarks.Text.ToString();

            query          = "SELECT tbl_PONumber.* FROM tbl_PONumber WHERE (EntityCode = '" + entitycode + "')";
            cmd            = new SqlCommand(query);
            cmd.Connection = conn;
            adp            = new SqlDataAdapter(cmd);
            adp.Fill(dt);
            if (dt.Rows.Count > 0)
            {
                foreach (DataRow row in dt.Rows)
                {
                    POSeriesNum = Convert.ToInt32(row["LastNumber"]) + 1;
                    PONumber    = row["Prefix"].ToString() + "-" + row["EntityCode"].ToString() + "-" + row["BeforeSeries"].ToString() + POSeriesNum.ToString("0000000#");

                    insert = "INSERT INTO [dbo].[tbl_POCreation] ([PONumber],[DateCreated],[CreatorKey],[MRPNumber], [ExpectedDate], [VendorCode], [PaymentTerms], [CurrencyCode], [InventSite], [InventSiteWarehouse], [InventSiteWarehouseLocation], [EntityCode], [BUSSUCode], [Remarks]) VALUES (@PONumber, @DateCreated, @CreatorKey, @MRPNumber, @ExpectedDate, @VendorCode, @PaymentTerms, @CurrencyCode, @InventSite, @InventSiteWarehouse, @InventSiteWarehouseLocation, @EntityCode, @BUSSUCode, @Remarks)";

                    cmd = new SqlCommand(insert, conn);
                    cmd.Parameters.AddWithValue("@PONumber", PONumber);
                    cmd.Parameters.AddWithValue("@CreatorKey", Session["CreatorKey"].ToString());
                    cmd.Parameters.AddWithValue("@MRPNumber", mopnumber);
                    cmd.Parameters.AddWithValue("@EntityCode", entitycode);
                    cmd.Parameters.AddWithValue("@BUSSUCode", bucode);
                    cmd.Parameters.AddWithValue("@DateCreated", DateTime.Now);
                    cmd.Parameters.AddWithValue("@ExpectedDate", ExpDel.Value.ToString());
                    cmd.Parameters.AddWithValue("@VendorCode", vendor);
                    cmd.Parameters.AddWithValue("@PaymentTerms", payment);
                    cmd.Parameters.AddWithValue("@CurrencyCode", currency);
                    cmd.Parameters.AddWithValue("@InventSite", site);
                    cmd.Parameters.AddWithValue("@InventSiteWarehouse", warehouse);
                    cmd.Parameters.AddWithValue("@InventSiteWarehouseLocation", location);
                    cmd.Parameters.AddWithValue("@Remarks", remarks);
                    cmd.CommandType = CommandType.Text;
                    cmd.ExecuteNonQuery();

                    ASPxGridView grid = POCreateGrid as ASPxGridView;
                    for (int i = 0; i < grid.VisibleRowCount; i++)
                    {
                        object PK              = grid.GetRowValues(i, "PK");
                        object MOPNumber       = grid.GetRowValues(i, "MOPNumber");
                        object ItemPK          = grid.GetRowValues(i, "ItemPK");
                        object TableIdentifier = grid.GetRowValues(i, "TableIdentifier");
                        object ItemCode        = grid.GetRowValues(i, "ItemCode");
                        object Description     = grid.GetRowValues(i, "Description");
                        object RequestedQty    = grid.GetRowValues(i, "RequestedQty");
                        object Cost            = grid.GetRowValues(i, "Cost");
                        object TotalCost       = grid.GetRowValues(i, "TotalCost");
                        object POUOM           = grid.GetRowValues(i, "POUOM");
                        object POQty           = grid.GetRowValues(i, "POQty");
                        object POCost          = grid.GetRowValues(i, "POCost");
                        object TotalPOCost     = grid.GetRowValues(i, "TotalPOCost");
                        object wVAT            = grid.GetRowValues(i, "wVAT");
                        object POCostwVAT      = grid.GetRowValues(i, "POCostwVAT");
                        object TotalPOCostwVAT = grid.GetRowValues(i, "TotalPOCostwVAT");
                        object TaxGroup        = grid.GetRowValues(i, "TaxGroup");
                        object TaxItemGroup    = grid.GetRowValues(i, "TaxItemGroup");


                        int iVat = 0;

                        if (Convert.ToBoolean(wVAT))
                        {
                            iVat = 1;
                        }

                        insert_po_details = "INSERT INTO [dbo].[tbl_POCreation_Details] ([PONumber],[MOPNumber], [ItemPK], [Identifier], [ItemCode], [TaxGroup], [TaxItemGroup], [Qty], [Cost], [POUOM], [wVAT], [CostwVAT]) VALUES (@PONumber,@MOPNumber, @ItemPK, @Identifier, @ItemCode, @TaxGroup, @TaxItemGroup, @Qty, @Cost, @POUOM, @wVAT, @CostwVAT)";

                        cmd = new SqlCommand(insert_po_details, conn);
                        cmd.Parameters.AddWithValue("@PONumber", PONumber);
                        cmd.Parameters.AddWithValue("@MOPNumber", MOPNumber);
                        cmd.Parameters.AddWithValue("@ItemPK", ItemPK);
                        cmd.Parameters.AddWithValue("@Identifier", TableIdentifier);
                        cmd.Parameters.AddWithValue("@ItemCode", ItemCode);
                        cmd.Parameters.AddWithValue("@TaxGroup", TaxGroup);
                        cmd.Parameters.AddWithValue("@TaxItemGroup", TaxItemGroup);
                        cmd.Parameters.AddWithValue("@POUOM", POUOM);
                        cmd.Parameters.AddWithValue("@Qty", Convert.ToDouble(POQty));
                        cmd.Parameters.AddWithValue("@Cost", Convert.ToDouble(POCost));
                        //cmd.Parameters.AddWithValue("@TotalCost", Convert.ToDouble(TotalPOCost));
                        cmd.Parameters.AddWithValue("@CostwVAT", Convert.ToDouble(POCostwVAT));
                        //cmd.Parameters.AddWithValue("@TotalCostwVAT", Convert.ToDouble(TotalPOCostwVAT));
                        cmd.Parameters.AddWithValue("@wVAT", iVat);
                        cmd.CommandType = CommandType.Text;
                        cmd.ExecuteNonQuery();

                        switch (TableIdentifier.ToString())
                        {
                        case "1":    //Direct Material
                            update = "UPDATE " + MRP_Constants.DirectMaterials_TableName() + " SET [QtyPO] = '" + Convert.ToDouble(POQty) + "' WHERE [PK] = '" + ItemPK + "'";
                            cmd    = new SqlCommand(update, conn);
                            cmd.ExecuteNonQuery();
                            break;

                        case "2":    //Opex
                            update = "UPDATE " + MRP_Constants.OperatingExpense_TableName() + " SET [QtyPO] = '" + Convert.ToDouble(POQty) + "' WHERE [PK] = '" + ItemPK + "'";
                            cmd    = new SqlCommand(update, conn);
                            cmd.ExecuteNonQuery();
                            break;

                        case "4":    //CAPEX
                            update = "UPDATE [dbo].[tbl_MRP_List_CAPEX] SET [QtyPO] = '" + Convert.ToDouble(POQty) + "' WHERE [PK] = '" + ItemPK + "'";
                            cmd    = new SqlCommand(update, conn);
                            cmd.ExecuteNonQuery();
                            break;
                        }
                    }

                    delete = "DELETE FROM [dbo].[tbl_POCreation_Tmp] WHERE [UserKey] = '" + Session["CreatorKey"].ToString() + "'";
                    cmd    = new SqlCommand(delete, conn);
                    cmd.ExecuteNonQuery();

                    update = "UPDATE [dbo].[tbl_PONumber] SET LastNumber = " + POSeriesNum + " WHERE ([EntityCode] = '" + entitycode + "')";
                    cmd    = new SqlCommand(update, conn);
                    cmd.ExecuteNonQuery();

                    ModalPopupExtenderLoading.Hide();

                    Response.Redirect("mrp_po_addedit.aspx?PONum=" + PONumber);
                }
            }
            else
            {
                ScriptManager.RegisterStartupScript(this.Page, typeof(string), "Resize", "changeWidth.resizeWidth();", true);

                POCreateNotify.HeaderText     = "Alert!";
                POCreateNotifyLbl.Text        = "Please Call Administrator." + Environment.NewLine + Environment.NewLine + "No PO Number Setup.";
                POCreateNotifyLbl.ForeColor   = System.Drawing.Color.Red;
                POCreateNotify.ShowOnPageLoad = true;
            }
            dt.Clear();

            conn.Close();
        }
예제 #23
0
 public string ObtenerObjeto(sgwMulticapa.Objetos.Base.ObjetoBase AObjeto, ASPxGridView AGrilla)
 {
     return(ObtenerObjeto(AObjeto, int.Parse(AGrilla.GetRowValues(AGrilla.FocusedRowIndex,
                                                                  "ID_" + AObjeto.GetType().GetField("Entidad").GetValue(null).ToString()).ToString())));
 }
예제 #24
0
        public void ASPxGridView1_CustomButtonInitialize(object sender, ASPxGridViewCustomButtonEventArgs e)
        {
            ASPxGridView grid         = (ASPxGridView)sender;
            string       run_flag     = grid.GetRowValues(e.VisibleIndex, "RUN_FLAG") as string;
            string       item_flag    = grid.GetRowValues(e.VisibleIndex, "ITEM_FLAG") as string;
            string       third_flag   = grid.GetRowValues(e.VisibleIndex, "THIRD_FLAG") as string;
            string       confirm_flag = grid.GetRowValues(e.VisibleIndex, "CONFIRM_FLAG") as string;
            string       bom_flag     = grid.GetRowValues(e.VisibleIndex, "BOM_FLAG") as string;

            switch (e.ButtonID)
            {
            case "Cbt1":
                if (e.CellType == GridViewTableCommandCellType.Filter)
                {
                    break;
                }
                if (item_flag != "N")
                {
                    e.Visible = DefaultBoolean.False;
                }
                if (item_flag == "N")
                {
                    e.Visible = DefaultBoolean.True;
                }
                if (confirm_flag == "N")
                {
                    e.Visible = DefaultBoolean.False;
                }
                if (bom_flag == "N")
                {
                    e.Visible = DefaultBoolean.False;
                }
                if (run_flag != "N")
                {
                    e.Visible = DefaultBoolean.False;
                }
                break;

            case "Cbt2":
                if (e.CellType == GridViewTableCommandCellType.Filter)
                {
                    break;
                }
                if (item_flag == "R")
                {
                    e.Visible = DefaultBoolean.True;
                }
                if (item_flag != "R")
                {
                    e.Visible = DefaultBoolean.False;
                }
                if (confirm_flag == "N")
                {
                    e.Visible = DefaultBoolean.False;
                }
                if (bom_flag == "N")
                {
                    e.Visible = DefaultBoolean.False;
                }
                if (run_flag != "N")
                {
                    e.Visible = DefaultBoolean.False;
                }
                break;

            case "Confirm":
                if (e.CellType == GridViewTableCommandCellType.Filter)
                {
                    break;
                }
                if (item_flag == "R")
                {
                    e.Visible = DefaultBoolean.True;
                }
                if (item_flag != "R")
                {
                    e.Visible = DefaultBoolean.False;
                }
                if (confirm_flag == "N")
                {
                    e.Visible = DefaultBoolean.False;
                }
                if (bom_flag == "N")
                {
                    e.Visible = DefaultBoolean.False;
                }
                if (run_flag != "N")
                {
                    e.Visible = DefaultBoolean.False;
                }
                break;

            case "Cancel":
                //if (item_flag == "Y" && confirm_flag == "Y" && run_flag == "Y")
                if (e.CellType == GridViewTableCommandCellType.Filter)
                {
                    break;
                }
                if (item_flag == "Y")
                {
                    e.Visible = DefaultBoolean.True;
                }
                if (item_flag != "Y")
                {
                    e.Visible = DefaultBoolean.False;
                }
                if (third_flag == "P")    //正参与三方物料计算的不能取消确认
                {
                    e.Visible = DefaultBoolean.False;
                }
                if (confirm_flag == "N")
                {
                    e.Visible = DefaultBoolean.False;
                }
                if (bom_flag == "N")
                {
                    e.Visible = DefaultBoolean.False;
                }
                if (run_flag != "N")
                {
                    e.Visible = DefaultBoolean.False;
                }
                break;
            }
        }
        private List<object> GetSelectedRowValues(string aColumnName, string keyColumnName, string colunaAuxilizar, ASPxGridView Grid)
        {
            List<object> matrix = new List<object>();
            //            List<object> values = new List<object>();

            string[] keyValueToGet = { keyColumnName };
            string[] valueToGet = { aColumnName };
            string[] colunaAUX = { colunaAuxilizar };

            for (int i = 0; i < Grid.VisibleRowCount; i++)
            {
                if (Grid.Selection.IsRowSelected(i))
                {
                    List<object> values = new List<object>();
                    values.Add(Grid.GetRowValues(i, valueToGet));
                    values.Add(Grid.GetRowValues(i, keyValueToGet));
                    values.Add(Grid.GetRowValues(i, colunaAUX));
                    matrix.Add(values);
                }
            }

            return matrix;
        }
예제 #26
0
 private DataTable GetDataView(ASPxGridView grid)
 {
     DataTable dt = new DataTable();
         foreach (GridViewColumn col in grid.VisibleColumns)
         {
             GridViewDataColumn dataColumn = col as GridViewDataColumn;
             if (dataColumn == null) continue;
             dt.Columns.Add(dataColumn.FieldName);
         }
         for (int i = 0; i < grid.VisibleRowCount; i++)
         {
             DataRow row = dt.Rows.Add();
             foreach (DataColumn col in dt.Columns)
                 row[col.ColumnName] = grid.GetRowValues(i, col.ColumnName);
         }
         return dt;
 }
        //Metodo que se ejecuta cuando se da clic en botón eliminar, descargar archivo o procesar archivo
        protected void ASPxGridView1_CustomButtonCallback(object sender, DevExpress.Web.ASPxGridViewCustomButtonCallbackEventArgs e)
        {
            try
            {
                if (Session["Cadena"] == null)
                {
                    Response.Redirect("Login.aspx");
                    return;
                }

                //ds_filesDS.ConnectionString = Session["Cadena"].ToString();

                string cmdString  = string.Empty;
                string connString = Session["Cadena"].ToString();

                ASPxGridView grid = sender as ASPxGridView;
                var          tmp  = grid.GetRowValues(e.VisibleIndex, grid.KeyFieldName);

                DataTable dt = new DataTable();



                if (e.ButtonID == "btnEliminar")
                {
                    cmdString = "DELETE FROM [FILESDS] WHERE [FILESDSKEY] = @FILESDSKEY";
                    using (SqlConnection conn = new SqlConnection(connString))
                    {
                        conn.Open();
                        using (SqlCommand comm = new SqlCommand())
                        {
                            comm.Connection  = conn;
                            comm.CommandText = cmdString;
                            comm.Parameters.Add("@FILESDSKEY", SqlDbType.UniqueIdentifier).Value = tmp;
                            using (SqlDataReader reader = comm.ExecuteReader())
                            {
                                if (!reader.HasRows)
                                {
                                    dt = null;
                                }
                                else
                                {
                                    dt.Load(reader);
                                }
                            }
                        }
                        conn.Close();
                    }

                    //Se actualiza grid
                    UpdateGrid();
                    AlertSuccess("Archivo eliminado con éxito");
                }
                else if (e.ButtonID == "ID_DOWNLOAD")
                {
                    byte[] bytes         = null;
                    string nombreArchivo = "";
                    var    parent        = System.IO.Directory.GetParent(Environment.CurrentDirectory);
                    string path          = parent.Parent + "\\DS";
                    string target        = path + "";

                    //Crea un directorio
                    if (!Directory.Exists(target))
                    {
                        Directory.CreateDirectory(target);
                    }

                    cmdString = "SELECT TOP 1 ARCHIVO, DSNAME FROM [FILESDS] WHERE [FILESDSKEY] = @val1 ";
                    using (SqlConnection conn = new SqlConnection(connString))
                    {
                        using (SqlCommand comm = new SqlCommand())
                        {
                            comm.Connection  = conn;
                            comm.CommandText = cmdString;
                            comm.Parameters.Add("@val1", SqlDbType.UniqueIdentifier).Value = tmp;

                            conn.Open();
                            SqlDataReader reader = comm.ExecuteReader();

                            if (!reader.HasRows)
                            {
                                dt = null;
                            }
                            else
                            {
                                reader.Read();
                                bytes         = (byte[])reader["ARCHIVO"];
                                nombreArchivo = (string)reader["DSNAME"];

                                File.WriteAllBytes(path + "\\" + nombreArchivo, bytes);
                                AlertSuccess("Se descargo el archivo: " + nombreArchivo);
                            }
                        }

                        //(sender as ASPxGridView).JSProperties["cpResult"] = "DS\\" + nombreArchivo;
                        conn.Close();
                    }

                    // Response.Clear();
                    // Response.ContentType = "application/winrar";
                    // Response.AddHeader("content-disposition", "attachment;filename=" + nombreArchivo);
                    //// Response.TransmitFile(Server.MapPath(path + "\\" + nombreArchivo));
                    // Response.TransmitFile(path + "\\" + nombreArchivo);
                    // HttpContext.Current.ApplicationInstance.CompleteRequest();
                    // Response.End();
                }

                if (e.ButtonID == "ID_PROCESAR")
                {
                    // AQUI SE DEBE MANDAR A EJECUTAR EL SP QUE PROCESA LOS ARCHIVOS.
                    try
                    {
                        string rfc = Session["RFC"].ToString().Trim();
                        if (rfc == null)
                        {
                            Response.Redirect("Login.aspx");
                            return;
                        }

                        TRespuesta res;
                        IExpedienteComercioservice v1 = new IExpedienteComercioservice();
                        res = v1.Procesads(tmp.ToString(), rfc);
                        string respuesta = res.ToString();
                    }
                    catch (Exception exc)
                    {
                        int    idusuario = 0;
                        string mensaje   = "";
                        if (Session["IdUsuario"] != null)
                        {
                            idusuario = int.Parse(Session["IdUsuario"].ToString());
                        }
                        excepcion.RegistrarExcepcion(idusuario, "CargasDataStage-ASPxGridView1_CustomButtonCallback", exc, lblCadena.Text, ref mensaje);

                        AlertError("Error al conectarse con el WebServices, intentelo más tarde");
                    }

                    #region codigo anterior
                    ////Valida de cada fila del grid si el estatus esta Procesado entonces el botón Procesar Archivo queda inhabilitado
                    //DataTable dtU = new DataTable();
                    //dtU = UpdateGrid();
                    //Session["Grid"] = dtU;


                    //if (Session["Grid"] != null && ((DataTable)(Session["Grid"])).Rows.Count > 0)
                    //{
                    //    for (int i = 0; i < ((DataTable)(Session["Grid"])).Rows.Count; i++)
                    //    {
                    //        var status = grid.GetRowValues(i, "STATUSDS");
                    //        if(status.ToString().ToUpper().Trim().Equals("PROCESADO"))
                    //        {
                    //            ASPxButton button = grid.FindRowCellTemplateControl(i, (GridViewDataColumn)grid.Columns["ACCION"], "ID_PROCESAR") as ASPxButton;

                    //            var col = ASPxGridView1. Columns[8] as GridViewCommandColumn;
                    //            col.CustomButtons["ID_PROCESAR"].Visibility = GridViewCustomButtonVisibility.Invisible;

                    //        }

                    //        //ASPxCheckBox chkConsultar = detailGridDocumentos.FindRowCellTemplateControl(i, (GridViewDataColumn)detailGridDocumentos.Columns["PDF"], "chkConsultar") as ASPxCheckBox;
                    //        //ASPxCheckBox chkConsultar = Grid2.FindRowCellTemplateControl(i, (GridViewDataColumn)Grid2.Columns["Consultar"], "chkConsultar") as ASPxCheckBox;
                    //        //ASPxButton btnProcesarFile = ASPxGridView1.FindRowCellTemplateControl(i, (GridViewDataColumn)ASPxGridView1.Columns["ACCIONES"], "btnProcesarFile") as ASPxButton;

                    //        //if (ASPxGridView1.GetRowValues(i, "STATUSDS").ToString().Equals("PROCESADO"))
                    //        //    btnProcesarFile.Enabled = false;
                    //        //else
                    //        //    btnProcesarFile.Enabled = true;
                    //    }


                    //    //foreach (DataRow fila in ((DataTable)(Session["Grid"])).Rows)
                    //    //{
                    //    //    if (fila["STATUSDS"].ToString().Trim().ToUpper().Equals("PROCESADO"))
                    //    //    {

                    //    //    }
                    //    //}
                    //}
                    #endregion

                    //Se actualiza grid
                    UpdateGrid();
                }
            }
            catch (Exception ex)
            {
                AlertError(ex.Message);

                int    idusuario = 0;
                string mensaje   = "";
                if (Session["IdUsuario"] != null)
                {
                    idusuario = int.Parse(Session["IdUsuario"].ToString());
                }
                excepcion.RegistrarExcepcion(idusuario, "CargasDataStage-ASPxGridView1_CustomButtonCallback", ex, lblCadena.Text, ref mensaje);
            }
        }
예제 #28
0
        protected void gvAudit_ToolbarItemClick(object source, DevExpress.Web.Data.ASPxGridViewToolbarItemClickEventArgs e)
        {
            ASPxGridView gridview       = source as ASPxGridView;
            string       activeLang     = (Session["lang"] == null) ? Languages.Default : Utils.ConvertToTrimmedString(Session["lang"]);
            var          auditId        = Utils.ConvertToNullableInt(gridview.GetRowValues(gridview.FocusedRowIndex, "audit_id"));
            var          auditDetailsId = Utils.ConvertToNullableInt(gridview.GetRowValues(gridview.FocusedRowIndex, "id"));
            var          allowedOK      = Utils.ConvertToNullableBool(gridview.GetRowValues(gridview.FocusedRowIndex, "answer_OK"));
            var          allowedNOK     = Utils.ConvertToNullableBool(gridview.GetRowValues(gridview.FocusedRowIndex, "answer_NOK"));
            var          allowedNC      = Utils.ConvertToNullableBool(gridview.GetRowValues(gridview.FocusedRowIndex, "answer_NC"));
            var          allowedNA      = Utils.ConvertToNullableBool(gridview.GetRowValues(gridview.FocusedRowIndex, "answer_NA"));

            if (allowedNA == null || allowedNC == null || allowedNOK == null || allowedOK == null || auditId == null || auditDetailsId == null)
            {
                throw new Exception("System error!");
            }
            var audit = new Audit((int)auditId);

            if (!audit.AuditExist() || audit.EndDate != null)
            {
                throw new Exception("Audit does not exist / has already been completed!");
            }
            bool refresh = false;
            bool move    = false;

            switch (e.Item.Name)
            {
            case ToolbarButtons.NextPage:
                ChangePage(ToolbarButtons.NextPage);
                gridview.FocusedRowIndex = 0;
                refresh = true;
                break;

            case ToolbarButtons.PrevPage:
                ChangePage(ToolbarButtons.PrevPage);
                gridview.FocusedRowIndex = 0;
                refresh = true;
                break;

            case ToolbarButtons.LangPol:
                Session["lang"] = Languages.Polish;
                refresh         = true;
                break;

            case ToolbarButtons.LangEng:
                Session["lang"] = Languages.English;
                refresh         = true;
                break;

            case ToolbarButtons.AnswerOK:
                ProcessAnswer(auditDetailsId, Answers.OK, allowedOK, allowedNOK, allowedNC, allowedNA);
                refresh = true;
                move    = true;
                break;

            case ToolbarButtons.AnswerNOK:
                ProcessAnswer(auditDetailsId, Answers.NOK, allowedOK, allowedNOK, allowedNC, allowedNA);
                refresh = true;
                break;

            case ToolbarButtons.AnswerNC:
                ProcessAnswer(auditDetailsId, Answers.NC, allowedOK, allowedNOK, allowedNC, allowedNA);
                refresh = true;
                break;

            case ToolbarButtons.AnswerNA:
                ProcessAnswer(auditDetailsId, Answers.NA, allowedOK, allowedNOK, allowedNC, allowedNA);
                refresh = true;
                move    = true;
                break;

            case ToolbarButtons.Camera:
                Session["audit_id"]        = auditId;
                Session["audit_detail_id"] = auditDetailsId;
                gridview.JSProperties["cp_launch_camera"] = true;
                break;

            case ToolbarButtons.DeleteAudit:
                audit.Delete();
                gridview.JSProperties["cp_escape_page"] = true;
                Session["lang"]            = null;
                Session["page"]            = null;
                Session["audit_id"]        = null;
                Session["audit_detail_id"] = null;
                Session["message"]         = "Audit removed!";
                break;

            case ToolbarButtons.PrintAudit:
                audit.SendEmailWithPdf(activeLang);
                break;

            case ToolbarButtons.EndAudit:
                if (audit.AuditQuestionAnsweredCount != audit.AuditQuestionCount)
                {
                    throw new Exception("Answer all questions!");
                }
                audit.End();
                Session["lang"]            = null;
                Session["page"]            = null;
                Session["audit_id"]        = null;
                Session["audit_detail_id"] = null;
                Session["message"]         = $"Audit completed with score {audit.AuditScoreCalculated.ToString("#.##")}%!";
                gridview.JSProperties["cp_escape_page"] = true;
                break;
            }
            if (refresh)
            {
                gridview.JSProperties["cp_refresh"] = true;
            }
            if (move)
            {
                gridview.JSProperties["cp_move"] = true;
            }
        }