private void RefreshGrid(ASPxGridView gv)
        {
            GridViewDataComboBoxColumn c = (GridViewDataComboBoxColumn)gv.Columns["IdentifTecno"];

            c.PropertiesComboBox.TextField = "Name";
            c.PropertiesComboBox.ValueField = "IdentifTecno";
            c.PropertiesComboBox.DataSource = Business.TecnologiaSoporte.ReadAll("");

            gv.DataSource = Business.MediosPublicitarios.ReadAllTipo("");
            gv.DataBind();
        }
        void InitDetailsAndPageHeader(ASPxGridView aspxGridView1)
        {
            ReadOnlyCollection<GridViewDataColumn> groupedColumns = aspxGridView1.GetGroupedColumns();

            int pagewidth = (report.PageWidth - (report.Margins.Left + report.Margins.Right)) - groupedColumns.Count * subGroupOffset;
            List<ColumnInfo> columns = GetColumnsInfo(aspxGridView1, pagewidth);
            CustomizeColumnsCollection(report, new ColumnsCreationEventArgs(pagewidth) { ColumnsInfo = columns });

            report.Bands.Add(new DetailBand() { HeightF = bandHeight });
            report.Bands.Add(new PageHeaderBand() { HeightF = bandHeight });

            XRTable headerTable = new XRTable();
            XRTableRow row = new XRTableRow();
            XRTable detailTable = new XRTable();
            XRTableRow row2 = new XRTableRow();

            for (int i = 0; i < columns.Count; i++)
            {
                if (columns[i].IsVisible)
                {
                    XRTableCell cell = new XRTableCell();
                    cell.Width = columns[i].ColumnWidth;
                    cell.Text = columns[i].FieldName;
                    row.Cells.Add(cell);

                    XRTableCell cell2 = new XRTableCell();
                    cell2.Width = columns[i].ColumnWidth;
                    ControlCustomizationEventArgs cc = new ControlCustomizationEventArgs() { FieldName = columns[i].FieldName, IsModified = false, Owner = cell2 };
                    CustomizeColumn(report, cc);
                    if (cc.IsModified == false)
                        cell2.DataBindings.Add("Text", null, columns[i].FieldName);
                    detailsInfo.Add(columns[i].GridViewColumn, cell2);
                    row2.Cells.Add(cell2);
                }
            }
            headerTable.Rows.Add(row);
            headerTable.Width = pagewidth;
            headerTable.LocationF = new PointF(groupedColumns.Count * subGroupOffset, 0);
            headerTable.Borders = BorderSide.Bottom;

            detailTable.Rows.Add(row2);
            detailTable.LocationF = new PointF(groupedColumns.Count * subGroupOffset, 0);
            detailTable.Width = pagewidth;

            report.Bands[BandKind.PageHeader].Controls.Add(headerTable);
            report.Bands[BandKind.Detail].Controls.Add(detailTable);
        }
Exemple #3
0
 public static void MostrarResultadoOperacionBd(ref ASPxGridView grilla, string texto, bool resultado)
 {
     var color = COLOR_RESULTADO_MAL;
     if ((resultado))
         color = COLOR_RESULTADO_BIEN;
     grilla.Controls.Add(new LiteralControl(string.Format("<span style='color:{0}; font-weight:bold; width:100%; text-align:center;'>{1}</span>", color, texto)));
 }
Exemple #4
0
 public static void GridApplyTheme(ASPxGridView Grid, string theTheme)
 {
     Grid.CssFilePath = "~/App_Themes/Glass/{0}/styles.css";
     Grid.CssPostfix = "Glass";
     Grid.Styles.CssFilePath = "~/App_Themes/Glass/{0}/styles.css";
     Grid.Styles.CssPostfix = "Glass";
     Grid.Styles.Header.SortingImageSpacing = 5;
 }
Exemple #5
0
        ASPxSplitter LayoutMasterDetail(Control detailControl, ASPxGridView gridView, IModelSplitLayout splitLayout) {
            ASPxSplitter splitter = CreateSplitter(splitLayout, PaneResized(gridView));
            var listPane = CreateSplitterListPane(splitter);
            listPane.Controls.Add(gridView);

            var callbackPanel = CreateSplitterDetailPane(splitter);
            callbackPanel.Controls.Add(detailControl);
            return splitter;
        }
Exemple #6
0
 public void GridColDesign(ASPxGridView gridView, string fieldName, string Caption, int Width , int Index, bool isVisible)
 {
     GenerateGridParams GridSetup;
        GridSetup = new GenerateGridParams(fieldName);
        GridSetup.Caption = Caption;
        GridSetup.Width = Width;
        GridSetup.Visible = isVisible;
        GridSetup.Index = Index;
        gridView.cxGenerateGrid(GridSetup);
 }
 public void DeleteFile(ASPxGridView gv, DevExpress.Web.Data.ASPxDataDeletingEventArgs e)
 {
     try{
         string path = gv.GetRowValuesByKeyValue(e.Keys[0], "Path").ToString();
         File.Delete(Server.MapPath(path));
     }
     catch (Exception)
     {
     }
 }
Exemple #8
0
 /// <summary>
 /// Searchs for combo by FindEditFormTemplateControl and returns selected value
 /// </summary>
 /// <param name="grid"></param>
 /// <param name="controlName"></param>
 /// <returns></returns>
 public static object GetEditFormComboValue(ASPxGridView grid, string controlName)
 {
     ASPxComboBox cbo = (ASPxComboBox)grid.FindEditFormTemplateControl(controlName);
     if (cbo != null)
         if (cbo.SelectedItem == null)
             return null;
         else
             return cbo.SelectedItem.Value;
     return null;
 }
 void ITemplate.InstantiateIn(Control container)
 {
     GridViewPagerBarTemplateContainer gridViewDataItemTemplateContainer = container as GridViewPagerBarTemplateContainer;
     if (gridViewDataItemTemplateContainer != null)
     {
         GridViewPagerBarTemplateContainer templateContainer = (GridViewPagerBarTemplateContainer)container;
         ASPxPager mypager =  new ASPxPager();
         grid = templateContainer.Grid;
         grid.SettingsPager.Summary.AllPagesText = "Trang {0}/{1} ({2} dòng dữ liệu)";
     }
 }
Exemple #10
0
    public void GenerateGrid(ASPxGridView grid, GenerateGridParams generateGridParams)
    {
        //if (sender == null) return;

        //var grid = sender as ASPxGridView;
        //if (grid == null) return;

        //var grid = ((ASPxGridView)sender);
        var fieldname = grid.Columns[generateGridParams.FieldName];
        fieldname.Visible = generateGridParams.Visible;
        fieldname.Width = generateGridParams.Width;
        fieldname.Caption = generateGridParams.Caption;
        fieldname.Index = generateGridParams.Index;
    }
        public void SetupGridView(ASPxGridView gridView, Action OnFocusedObjectChanged) {
            _gridView = gridView;
            gridView.SettingsBehavior.AllowFocusedRow = true;
            gridView.Load += (s, e) => OnFocusedObjectChanged();

            gridView.ClientSideEvents.Init = "function (s,e) { s.firstRowChangedAfterInit = true;}";
            gridView.ClientSideEvents.FocusedRowChanged =
                @"function(s,e) { 
                    var up = window.DetailUpdatePanelControl;
                    if (s.firstRowChangedAfterInit!==true && up && up.GetMainElement()) { 
                        up.PerformCallback(s.GetFocusedRowIndex());} 
                    s.firstRowChangedAfterInit = false; }";

            gridView.Settings.VerticalScrollBarMode = ScrollBarMode.Visible;
        }
        public void SetupGridView(ASPxGridView gridView, Action OnFocusedObjectChanged) {
            _gridView = gridView;
            gridView.SettingsBehavior.AllowFocusedRow = true;
            gridView.Load += (s, e) => OnFocusedObjectChanged();

            gridView.ClientSideEvents.Init = "function (s,e) { s.firstRowChangedAfterInit = true;}";
            gridView.ClientSideEvents.FocusedRowChanged =
                @"function(s,e) { 
                    var up = document.getElementById('DetailUpdatePanel');
                    if (s.firstRowChangedAfterInit!==true && up && up.ClientControl) { 
                        up.ClientControl.PerformCallback(s.GetFocusedRowIndex());} 
                    s.firstRowChangedAfterInit = false; }";

            gridView.Settings.ShowVerticalScrollBar = true;
        }
        public void SetupGridView(ASPxGridView gridView, Action OnFocusedObjectChanged) {
            _gridView = gridView;
            gridView.SettingsBehavior.AllowFocusedRow = true;
            gridView.Load += (s, e) => OnFocusedObjectChanged();

            gridView.ClientSideEvents.Init = "function (s,e) { s.firstRowChangedAfterInit = true;}";
            gridView.ClientSideEvents.FocusedRowChanged =
                @"function(s,e) { 
                    var parentSplitter = XpandHelper.GetParentControl(s);
                    var up = XpandHelper.GetFirstChildControl(parentSplitter.GetPane(1).GetElement().childNodes[0]);
                    if ((s.firstRowChangedAfterInit!==true || !XpandHelper.IsRootSplitter(parentSplitter)) && up && up.GetMainElement()) { 
                        up.PerformCallback(s.GetFocusedRowIndex());} 
                    s.firstRowChangedAfterInit = false; }";

            gridView.Settings.VerticalScrollBarMode = ScrollBarMode.Visible;
        }
 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;
     }
 }
Exemple #15
0
    /// <summary>
    /// Xử lý khi Save Callback kết thúc
    /// </summary>
    /// <param name="result">kết quả trả về khi callback xong</param>
    /// <param name="param">tham số e.Parameter của Callback Event</param>
    /// <param name="tblTemp">Tên bảng cần xóa dữ liệu tạm sau khi callback xong. Chỉ dành cho trường hợp lưu thành công</param>
    /// <param name="sessionname">Tên session lưu giữ sessionkey của bảng temp</param>
    /// 
    public static void gridProductDetailsAddInCallback(string parameter, ASPxGridView gv)
    {
        object tempID = -1;
        if (parameter.StartsWith("reorderlevel"))
        {

            object typeReorder = parameter.Split(';')[1];
            tempID = parameter.Split(';')[2];

            if (tempID != null)
            {
                EU.SALE_temp_reorderLevel(tempID, typeReorder);
                //LogAction(4, tempID + ";ReorderLevel :" + parameter);
                //throw new Exception("gridProductDetailsAddInCallback;" + tempID + ";param:" + parameter);
            }

        }
        gv.DataBind();
    }
        private void CreateControlCheckBoxes()
        {
            if (string.IsNullOrEmpty(this.GridID))
                throw new NullReferenceException("GridID property is null.");
            grid = NamingContainer.FindControl(GridID) as ASPxGridView;
            if (grid == null)
                throw new InvalidOperationException("ASPxGridView control was not found in NamingContainer.");
            foreach (GridViewDataColumn column in this.grid.Columns)
            {
                ASPxCheckBox columnCheckBox = new ASPxCheckBox();
                columnCheckBox.ID = "chb" + column.VisibleIndex.ToString();
                ASPxPopupControlDemo.Controls.Add(columnCheckBox);

                columnCheckBox.AutoPostBack = true;
                columnCheckBox.Text = column.Caption;//FieldName;
                columnCheckBox.Checked = column.Visible;
                columnCheckBox.CheckedChanged += new EventHandler(columnCheckBox_CheckedChanged);
            }
        }
Exemple #17
0
    public static void BindData(ASPxGridView gv, DevExpress.Xpo.Session s, string objectname, string filter = "", string DefaultSorting="", params object[] parameter)
    {
        try
        {
            DynamicDataTableClassInfo classInfo = dynamicClasses[objectname];

            if (classInfo != null)
            {
                XPServerCollectionSource ds = new XPServerCollectionSource(s, dynamicClasses[objectname], CriteriaOperator.Parse(filter, parameter));
                ds.DefaultSorting = DefaultSorting;
                gv.DataSource = ds;
                //gv.KeyFieldName = classInfo.KeyProperty.DisplayName;
            }
            else
                throw new Exception(string.Format("Đối tượng {0} không tìm thấy trong database. Nếu không có dữ liệu hiển thị thì XPOProfiles để xem điều kiện lọc đúng chưa", objectname));
        }
        catch (Exception ex)
        {
            SiAuto.Main.LogColored(Color.Red, "Loi BindData:" + ex.ToString());
            throw ex;
        }
    }
Exemple #18
0
    protected void GridListagem_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
    {
        ASPxGridView gridView = (ASPxGridView)sender;

        //
        string   ID                  = "";
        string   apelido             = "";
        string   nome                = "";
        string   sexo                = "";
        string   cnpj                = "";
        string   inscmunicipal       = "";
        string   inscestadual        = "";
        string   regjuntacom         = "";
        string   nire                = "";
        string   rg                  = "";
        string   rguf                = "";
        string   rgemissor           = "";
        DateTime rgemissao           = Convert.ToDateTime("01/01/1900");
        string   endereco            = "";
        string   enderecores         = "";
        string   enderecoresnumero   = "";
        string   enderecorescomplem  = "";
        string   bairrores           = "";
        string   cidaderes           = "";
        string   ufres               = "";
        string   cepres              = "";
        string   fone1res            = "";
        string   fone2res            = "";
        string   fone3res            = "";
        string   enderecocom         = "";
        string   enderecocomnumero   = "";
        string   enderecocomcomplem  = "";
        string   bairrocom           = "";
        string   cidadecom           = "";
        string   ufcom               = "";
        string   cepcom              = "";
        string   fone1com            = "";
        string   fone2com            = "";
        string   fone3com            = "";
        string   email1              = "";
        string   email2              = "";
        string   email3              = "";
        string   email4              = "";
        string   email5              = "";
        string   gerente             = "";
        string   contato             = "";
        DateTime dtnascimento        = Convert.ToDateTime("01/01/1900");
        DateTime dtingresso          = Convert.ToDateTime("01/01/1900");
        string   ncontrato           = "";
        DateTime dtcontrato          = Convert.ToDateTime("01/01/1900");
        Boolean  ativo               = true;
        Boolean  acessointernet      = true;
        string   empregador          = "";
        string   cargo               = "";
        string   atividade           = "";
        string   obs1                = "";
        string   obs2                = "";
        string   obs3                = "";
        string   obs4                = "";
        string   obs5                = "";
        string   conjugenome         = "";
        string   conjugesexo         = "";
        string   conjugecnpj         = "";
        string   conjugerg           = "";
        string   conjugerguf         = "";
        string   conjugergemissor    = "";
        DateTime conjugergemissao    = Convert.ToDateTime("01/01/1900");
        DateTime dtnascimentoconjuge = Convert.ToDateTime("01/01/1900");
        string   fone1con            = "";
        string   fone2con            = "";
        string   fone3con            = "";
        string   conjugeemail1       = "";
        string   conjugeemail2       = "";
        string   instrcob1           = "";
        string   instrcob2           = "";
        string   diasprotesto        = "";
        string   conta1              = "";
        string   conta2              = "";
        string   conta3              = "";
        string   conta4              = "";
        string   conta5              = "";
        Boolean  dda                 = false;

        //
        // Empresa
        ID      = e.NewValues["ID"].ToString();
        apelido = e.NewValues["apelido"].ToString();
        nome    = e.NewValues["nome"].ToString();
        sexo    = e.NewValues["sexo"].ToString();
        cnpj    = e.NewValues["cnpj"].ToString();

        if (e.NewValues["inscmunicipal"] != null)
        {
            inscmunicipal = e.NewValues["inscmunicipal"].ToString();
        }
        if (e.NewValues["inscestadual"] != null)
        {
            inscestadual = e.NewValues["inscestadual"].ToString();
        }
        if (e.NewValues["regjuntacom"] != null)
        {
            regjuntacom = e.NewValues["regjuntacom"].ToString();
        }
        if (e.NewValues["nire"] != null)
        {
            nire = e.NewValues["nire"].ToString();
        }
        if (e.NewValues["rg"] != null)
        {
            rg = e.NewValues["rg"].ToString();
        }
        if (e.NewValues["rguf"] != null)
        {
            rguf = e.NewValues["rguf"].ToString();
        }
        if (e.NewValues["rgemissor"] != null)
        {
            rgemissor = e.NewValues["rgemissor"].ToString();
        }
        if (e.NewValues["rgemissao"] != null)
        {
            rgemissao = Convert.ToDateTime(e.NewValues["rgemissao"].ToString());
        }
        if (e.NewValues["endereco"] != null)
        {
            endereco = e.NewValues["endereco"].ToString();
        }
        if (e.NewValues["enderecores"] != null)
        {
            enderecores = e.NewValues["enderecores"].ToString();
        }
        if (e.NewValues["enderecoresnumero"] != null)
        {
            enderecoresnumero = e.NewValues["enderecoresnumero"].ToString();
        }
        if (e.NewValues["enderecorescomplem"] != null)
        {
            enderecorescomplem = e.NewValues["enderecorescomplem"].ToString();
        }
        if (e.NewValues["bairrores"] != null)
        {
            bairrores = e.NewValues["bairrores"].ToString();
        }
        if (e.NewValues["cidaderes"] != null)
        {
            cidaderes = e.NewValues["cidaderes"].ToString();
        }
        if (e.NewValues["ufres"] != null)
        {
            ufres = e.NewValues["ufres"].ToString();
        }
        if (e.NewValues["cepres"] != null)
        {
            cepres = e.NewValues["cepres"].ToString();
        }
        if (e.NewValues["fone1res"] != null)
        {
            fone1res = e.NewValues["fone1res"].ToString();
        }
        if (e.NewValues["fone2res"] != null)
        {
            fone2res = e.NewValues["fone2res"].ToString();
        }
        if (e.NewValues["fone3res"] != null)
        {
            fone3res = e.NewValues["fone3res"].ToString();
        }
        if (e.NewValues["enderecocom"] != null)
        {
            enderecocom = e.NewValues["enderecocom"].ToString();
        }
        if (e.NewValues["enderecocomnumero"] != null)
        {
            enderecocomnumero = e.NewValues["enderecocomnumero"].ToString();
        }
        if (e.NewValues["enderecocomcomplem"] != null)
        {
            enderecocomcomplem = e.NewValues["enderecocomcomplem"].ToString();
        }
        if (e.NewValues["bairrocom"] != null)
        {
            bairrocom = e.NewValues["bairrocom"].ToString();
        }
        if (e.NewValues["cidadecom"] != null)
        {
            cidadecom = e.NewValues["cidadecom"].ToString();
        }
        if (e.NewValues["ufcom"] != null)
        {
            ufcom = e.NewValues["ufcom"].ToString();
        }
        if (e.NewValues["cepcom"] != null)
        {
            cepcom = e.NewValues["cepcom"].ToString();
        }
        if (e.NewValues["fone1com"] != null)
        {
            fone1com = e.NewValues["fone1com"].ToString();
        }
        if (e.NewValues["fone2com"] != null)
        {
            fone2com = e.NewValues["fone2com"].ToString();
        }
        if (e.NewValues["fone3com"] != null)
        {
            fone3com = e.NewValues["fone3com"].ToString();
        }
        if (e.NewValues["email1"] != null)
        {
            email1 = e.NewValues["email1"].ToString();
        }
        if (e.NewValues["email2"] != null)
        {
            email2 = e.NewValues["email2"].ToString();
        }
        if (e.NewValues["email3"] != null)
        {
            email3 = e.NewValues["email3"].ToString();
        }
        if (e.NewValues["email4"] != null)
        {
            email4 = e.NewValues["email4"].ToString();
        }
        if (e.NewValues["email5"] != null)
        {
            email5 = e.NewValues["email5"].ToString();
        }
        if (e.NewValues["gerente"] != null)
        {
            gerente = e.NewValues["gerente"].ToString();
        }
        if (e.NewValues["contato"] != null)
        {
            contato = e.NewValues["contato"].ToString();
        }
        if (e.NewValues["dtnascimento"] != null)
        {
            dtnascimento = Convert.ToDateTime(e.NewValues["dtnascimento"].ToString());
        }
        if (e.NewValues["dtingresso"] != null)
        {
            dtingresso = Convert.ToDateTime(e.NewValues["dtingresso"].ToString());
        }
        if (e.NewValues["ncontrato"] != null)
        {
            ncontrato = e.NewValues["ncontrato"].ToString();
        }
        if (e.NewValues["dtcontrato"] != null)
        {
            dtcontrato = Convert.ToDateTime(e.NewValues["dtcontrato"].ToString());
        }
        if (e.NewValues["ativo"] != null)
        {
            ativo = Convert.ToBoolean(e.NewValues["ativo"].ToString());
        }
        if (e.NewValues["acessointernet"] != null)
        {
            acessointernet = Convert.ToBoolean(e.NewValues["acessointernet"].ToString());
        }
        if (e.NewValues["empregador"] != null)
        {
            empregador = e.NewValues["empregador"].ToString();
        }
        if (e.NewValues["cargo"] != null)
        {
            cargo = e.NewValues["cargo"].ToString();
        }
        if (e.NewValues["atividade"] != null)
        {
            atividade = e.NewValues["atividade"].ToString();
        }
        if (e.NewValues["obs1"] != null)
        {
            obs1 = e.NewValues["obs1"].ToString();
        }
        if (e.NewValues["obs2"] != null)
        {
            obs2 = e.NewValues["obs2"].ToString();
        }
        if (e.NewValues["obs3"] != null)
        {
            obs3 = e.NewValues["obs3"].ToString();
        }
        if (e.NewValues["obs4"] != null)
        {
            obs4 = e.NewValues["obs4"].ToString();
        }
        if (e.NewValues["obs5"] != null)
        {
            obs5 = e.NewValues["obs5"].ToString();
        }
        if (e.NewValues["conjugenome"] != null)
        {
            conjugenome = e.NewValues["conjugenome"].ToString();
        }
        if (e.NewValues["conjugesexo"] != null)
        {
            conjugesexo = e.NewValues["conjugesexo"].ToString();
        }
        if (e.NewValues["conjugecnpj"] != null)
        {
            conjugecnpj = e.NewValues["conjugecnpj"].ToString();
        }
        if (e.NewValues["conjugerg"] != null)
        {
            conjugerg = e.NewValues["rg"].ToString();
        }
        if (e.NewValues["conjugerguf"] != null)
        {
            conjugerguf = e.NewValues["conjugerguf"].ToString();
        }
        if (e.NewValues["conjugergemissor"] != null)
        {
            conjugergemissor = e.NewValues["conjugergemissor"].ToString();
        }
        if (e.NewValues["conjugergemissao"] != null)
        {
            conjugergemissao = Convert.ToDateTime(e.NewValues["conjugergemissao"].ToString());
        }
        if (e.NewValues["dtnascimentoconjuge"] != null)
        {
            dtnascimentoconjuge = Convert.ToDateTime(e.NewValues["dtnascimentoconjuge"].ToString());
        }
        if (e.NewValues["fone1con"] != null)
        {
            fone1con = e.NewValues["fone1con"].ToString();
        }
        if (e.NewValues["fone2con"] != null)
        {
            fone2con = e.NewValues["fone2con"].ToString();
        }
        if (e.NewValues["fone3con"] != null)
        {
            fone3con = e.NewValues["fone3con"].ToString();
        }
        if (e.NewValues["conjugeemail1"] != null)
        {
            conjugeemail1 = e.NewValues["conjugeemail1"].ToString();
        }
        if (e.NewValues["conjugeemail2"] != null)
        {
            conjugeemail2 = e.NewValues["conjugeemail2"].ToString();
        }
        if (e.NewValues["instrcob1"] != null)
        {
            instrcob1 = e.NewValues["instrcob1"].ToString();
        }
        if (e.NewValues["instrcob2"] != null)
        {
            instrcob2 = e.NewValues["instrcob2"].ToString();
        }
        if (e.NewValues["diasprotesto"] != null)
        {
            diasprotesto = e.NewValues["diasprotesto"].ToString();
        }
        if (e.NewValues["conta1"] != null)
        {
            conta1 = e.NewValues["conta1"].ToString();
        }
        if (e.NewValues["conta2"] != null)
        {
            conta2 = e.NewValues["conta2"].ToString();
        }
        if (e.NewValues["conta3"] != null)
        {
            conta3 = e.NewValues["conta3"].ToString();
        }
        if (e.NewValues["conta4"] != null)
        {
            conta4 = e.NewValues["conta4"].ToString();
        }
        if (e.NewValues["conta5"] != null)
        {
            conta5 = e.NewValues["conta5"].ToString();
        }
        if (e.NewValues["dda"] != null)
        {
            dda = Convert.ToBoolean(e.NewValues["dda"].ToString());
        }

        uContato.Altera(ID,
                        apelido,
                        nome,
                        sexo,
                        cnpj,
                        inscmunicipal,
                        inscestadual,
                        regjuntacom,
                        nire,
                        rg,
                        rguf,
                        rgemissor,
                        rgemissao,
                        endereco,
                        enderecores,
                        enderecoresnumero,
                        enderecorescomplem,
                        bairrores,
                        cidaderes,
                        ufres,
                        cepres,
                        fone1res,
                        fone2res,
                        fone3res,
                        enderecocom,
                        enderecocomnumero,
                        enderecocomcomplem,
                        bairrocom,
                        cidadecom,
                        ufcom,
                        cepcom,
                        fone1com,
                        fone2com,
                        fone3com,
                        email1,
                        email2,
                        email3,
                        email4,
                        email5,
                        gerente,
                        contato,
                        dtnascimento,
                        dtingresso,
                        ncontrato,
                        dtcontrato,
                        ativo,
                        acessointernet,
                        empregador,
                        cargo,
                        atividade,
                        conjugenome,
                        conjugesexo,
                        conjugecnpj,
                        conjugerg,
                        conjugerguf,
                        conjugergemissor,
                        conjugergemissao,
                        dtnascimentoconjuge,
                        fone1con,
                        fone2con,
                        fone3con,
                        conjugeemail1,
                        conjugeemail2,
                        obs1,
                        obs2,
                        obs3,
                        obs4,
                        obs5,
                        instrcob1,
                        instrcob2,
                        diasprotesto,
                        conta1,
                        conta2,
                        conta3,
                        conta4,
                        conta5,
                        dda);


        gridView.CancelEdit();
        e.Cancel = true;

        //Usando Classe uLog.MakeLog - Gravando Log
        fwObs_Log = "ALTERA CONTATO: " + ID + "/" + cnpj + "/" + apelido;
        SqlParameter[] param_log = { new SqlParameter("@login",    (String)Session["CodUsuario"]),
                                     new SqlParameter("@tabela",   fWtabela),
                                     new SqlParameter("@operacao", "CONTATO"),
                                     new SqlParameter("@obs",      "ALTERA"),
                                     new SqlParameter("@acao",     fwObs_Log) };
        uLog.MakeLog(param_log);

        //
        AtualizaGrid();
    }
        protected void gvMain_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
        {
            SetMandatory();
            ASPxGridView gv = (ASPxGridView)sender;

            string[] commands = e.Parameters.Split('=');
            string   command  = commands[0];

            if (command == "1" || command == "2" || command == "3")
            {
                string value1 = "0"; //OEMID
                string value2 = "0"; //TechID

                if (command == "1")  //OEM changed
                {
                    value1 = commands[1];
                    if (Session["NewTech"] != null)
                    {
                        value2 = Session["NewTech"].ToString();
                    }
                    Session["NewOEM"] = value1;
                }

                if (command == "2") //Tech changed
                {
                    value1             = Session["NewOEM"].ToString();
                    value2             = commands[1];
                    Session["NewTech"] = value2;
                    if (Session["NewTech"].ToString() == "null")
                    {
                        Session["NewTech"] = null;
                    }
                }

                if (command == "3") //Network Element changed
                {
                    value1 = Session["NewOEM"].ToString();
                    if (Session["NewTech"] != null)
                    {
                        value2 = Session["NewTech"].ToString();
                    }
                    else
                    {
                        value2 = "null";
                    }
                    Session["NewNetwork"] = commands[1];
                    if (Session["NewNetwork"].ToString() == "null")
                    {
                        Session["NewNetwork"] = null;
                    }
                }

                ASPxComboBox cb1 = gv.FindEditRowCellTemplateControl(gv.Columns["TechnologyID"] as GridViewDataColumn, "cbTech") as ASPxComboBox;
                ASPxComboBox cb2 = gv.FindEditRowCellTemplateControl(gv.Columns["NetworkElementID"] as GridViewDataColumn, "cbNetwork") as ASPxComboBox;

                string    sql = "SELECT ID, NAME FROM tblTechnology WHERE OEMID = " + value1;
                DataTable dt  = DataBase.GetDT(sql);
                cb1.DataSource = dt;
                cb1.DataBind();
                if (command == "1" || value2 == null)
                {
                    cb1.SelectedIndex  = -1;
                    Session["NewTech"] = null;
                    cb2.Items.Clear();
                    cb2.SelectedIndex     = -1;
                    Session["NewNetwork"] = null;
                }
                else if (command == "2")
                {
                    cb1.SelectedIndex = cb1.Items.FindByValue(value2).Index;
                    sql            = "SELECT ID, NAME FROM tblNetworkElement WHERE TechID = " + value2;
                    dt             = DataBase.GetDT(sql);
                    cb2.DataSource = dt;
                    cb2.DataBind();
                    cb2.SelectedIndex     = -1;
                    Session["NewNetwork"] = null;
                }
                else if (command == "3")
                {
                    sql            = "SELECT ID, NAME FROM tblNetworkElement WHERE TechID = " + value2;
                    dt             = DataBase.GetDT(sql);
                    cb2.DataSource = dt;
                    cb2.DataBind();
                    if (Session["NewNetwork"] == null)
                    {
                        cb2.SelectedIndex = -1;
                    }
                    else
                    {
                        cb2.SelectedIndex = cb2.Items.FindByValue(Session["NewNetwork"].ToString()).Index;
                    }
                }
            }
            if (command == "4")
            {
                string      value4 = commands[1];
                ASPxTextBox tb     = gv.FindEditRowCellTemplateControl(gv.Columns["ControllerIP"] as GridViewDataColumn, "tbControllerIP") as ASPxTextBox;
                string      sql    = "SELECT IPAddress FROM tblController WHERE ID = " + value4;
                DataTable   dt     = DataBase.GetDT(sql);
                tb.Text = dt.Rows[0][0].ToString();
            }
        }
    protected void detailGrid_DataSelect(object sender, EventArgs e)
    {
        ASPxGridView detailGrid = sender as ASPxGridView;

        detailGrid.DataSource = DataProvider.GetItems((int)detailGrid.GetMasterRowKeyValue());
    }
    protected void GridListagem_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e)
    {
        ASPxGridView gridView = (ASPxGridView)sender;

        uContasPagar.Exclui(e.Values["ID"].ToString());
        //

        gridView.CancelEdit();
        e.Cancel = true;

        //Usando Classe uLog.MakeLog - Gravando Log
        fwObs_Log = "EXCLUI CONTAS A PAGAR: " + e.Values["ID"].ToString() + "/" + e.Values["lancamento"].ToString().ToUpper();
        SqlParameter[] param_log = { new SqlParameter("@login",    (String)Session["CodUsuario"]),
                                     new SqlParameter("@tabela",   fWtabela),
                                     new SqlParameter("@operacao", "CONTAS A PAGAR"),
                                     new SqlParameter("@obs",      "EXCLUI"),
                                     new SqlParameter("@acao",     fwObs_Log) };
        uLog.MakeLog(param_log);

        //Todas
        if (rbparcelasituacao.SelectedIndex == 0)
        {
            //Todas/Lançamento
            if (rbordenacao.SelectedIndex == 0)
            {
                GridListagem.Visible = true;
                AtualizaGrid("T", "L");
            }
            //Todas/Classe Despesa
            if (rbordenacao.SelectedIndex == 1)
            {
                GridListagem.Visible = true;
                AtualizaGrid("T", "D");
            }
            //Todas/Fornecedores
            if (rbordenacao.SelectedIndex == 2)
            {
                GridListagem.Visible = true;
                AtualizaGrid("T", "F");
            }
            //Todas/Data Prevista
            if (rbordenacao.SelectedIndex == 3)
            {
                GridListagem.Visible = true;
                AtualizaGrid("T", "DP");
            }
            //Todas/Data Realizado
            if (rbordenacao.SelectedIndex == 4)
            {
                GridListagem.Visible = true;
                AtualizaGrid("T", "DR");
            }
            //Todas/Data Nota Fiscal
            if (rbordenacao.SelectedIndex == 5)
            {
                GridListagem.Visible = true;
                AtualizaGrid("T", "DN");
            }
        }
        //Previsto
        if (rbparcelasituacao.SelectedIndex == 1)
        {
            //Previsto/Lançamento
            if (rbordenacao.SelectedIndex == 0)
            {
                GridListagem.Visible = true;
                AtualizaGrid("P", "L");
            }
            //Previsto/Classe Despesa
            if (rbordenacao.SelectedIndex == 1)
            {
                GridListagem.Visible = true;
                AtualizaGrid("P", "D");
            }
            //Previsto/Fornecedores
            if (rbordenacao.SelectedIndex == 2)
            {
                GridListagem.Visible = true;
                AtualizaGrid("P", "F");
            }
            //Previsto/Data Prevista
            if (rbordenacao.SelectedIndex == 3)
            {
                GridListagem.Visible = true;
                AtualizaGrid("P", "DP");
            }
            //Previsto/Data Realizado
            if (rbordenacao.SelectedIndex == 4)
            {
                GridListagem.Visible = true;
                AtualizaGrid("P", "DR");
            }
            //Previsto/Data Nota Fiscal
            if (rbordenacao.SelectedIndex == 5)
            {
                GridListagem.Visible = true;
                AtualizaGrid("P", "DN");
            }
        }
        //Realizado
        if (rbparcelasituacao.SelectedIndex == 2)
        {
            //Realizado/Lançamento
            if (rbordenacao.SelectedIndex == 0)
            {
                GridListagem.Visible = true;
                AtualizaGrid("R", "L");
            }
            //Realizado/Classe Despesa
            if (rbordenacao.SelectedIndex == 1)
            {
                GridListagem.Visible = true;
                AtualizaGrid("R", "D");
            }
            //Realizado/Fornecedores
            if (rbordenacao.SelectedIndex == 2)
            {
                GridListagem.Visible = true;
                AtualizaGrid("R", "F");
            }
            //Realizado/Data Prevista
            if (rbordenacao.SelectedIndex == 3)
            {
                GridListagem.Visible = true;
                AtualizaGrid("R", "DP");
            }
            //Realizado/Data Realizado
            if (rbordenacao.SelectedIndex == 4)
            {
                GridListagem.Visible = true;
                AtualizaGrid("R", "DR");
            }
            //Realizado/Data Nota Fiscal
            if (rbordenacao.SelectedIndex == 5)
            {
                GridListagem.Visible = true;
                AtualizaGrid("R", "DN");
            }
        }
    }
        internal XtraReport GenerateReport(ASPxGridView ASPxGridView1, ObjectDataSource ObjectDataSource1)
        {
            report = new XtraReport();
            report.Landscape = true;
            report.PaperKind = System.Drawing.Printing.PaperKind.Letter;

            //InitDataSource(ObjectDataSource1);

            DataView dv = new DataView();
            DataTable dt = new DataTable();
            dv = ObjectDataSource1.Select() as DataView; //.Select(DataSourceSelectArguments.Empty) as DataView;
            dt = dv.ToTable();
            report.DataSource = dt;

            InitDetailsAndPageHeader(ASPxGridView1);
            InitSortings(ASPxGridView1);
            InitGroupHeaders(ASPxGridView1);
            InitFilters(ASPxGridView1);
            InitTotalSummaries(ASPxGridView1);
            return report;
        }
 /// <summary>
 /// GridView的直接子控件的显示情况(GridView.Column可填Caption/FieldName)
 /// </summary>
 /// <param name="gv"></param>
 /// <param name="Status"></param>
 public static void Bind_Authority(ASPxGridView gv, string Status)
 {
     Bind_Authority(gv, Status, "");
 }
Exemple #24
0
    protected void gvA_OnRowUpdating(object sender, ASPxDataUpdatingEventArgs e)
    {
        ASPxGridView gv = (ASPxGridView)sender;

        var selected_keys = gvA.GetSelectedFieldValues("ActionID");

        ASPxCheckBox chkAllSelected    = gv.FindEditFormLayoutItemTemplateControl("chkUpdateAllSelected") as ASPxCheckBox;
        bool         updateALLSelected = chkAllSelected.Checked;

        List <int> pkvals = new List <int>();

        foreach (object key in e.Keys.Values)
        {
            int  ikey;
            bool isint = int.TryParse(key.ToString(), out ikey);
            if (isint)
            {
                pkvals.Add(ikey);
            }
        }

        //Add the other selected rows to the update if the user has selected the "Update All" checkbox
        if (selected_keys.Count > 0 && updateALLSelected)
        {
            foreach (object k in selected_keys)
            {
                int  ikey;
                bool isint = int.TryParse(k.ToString(), out ikey);
                if (!pkvals.Contains(ikey))
                {
                    pkvals.Add(ikey);
                }
            }
        }

        ////Get the data from the ComboBoxes
        //ASPxComboBox cboMS = (ASPxComboBox)gvM.FindEditFormLayoutItemTemplateControl(  "CboMS");
        //ASPxComboBox cboMSD = (ASPxComboBox)gvM.FindEditFormLayoutItemTemplateControl(  "CboMSD");

        //e.NewValues["MeasStatusID"] = cboMS.Value;
        //e.NewValues["MeasStatusDetailID"] = cboMSD.Value;

        //ASPxMemo notes = (ASPxMemo)gvM.FindEditFormLayoutItemTemplateControl("notesEditor");
        //e.NewValues["Notes"] = notes.Value;

        ////string result = dxGrid_UpdateData(e.Keys, e.NewValues, "backend", "dbo", "tblStudyMeasSubj");
        //string result = dataops.dxGrid_UpdateData("studymeassubjID", pkvals, e.NewValues, "backend", "dbo", "tblStudyMeasSubj");



        popupdata.AddField(e.NewValues, gvA, "ActionStatusID", "CboAS", DevExpress.Web.ControlType.ASPxComboBox);
        popupdata.AddField(e.NewValues, gvA, "DateDone", "DateCalendarA", DevExpress.Web.ControlType.ASPxDateEdit);
        //popupdata.AddField(e.NewValues, gvA, "Clinician", "CboClinA", DevExpress.Web.ControlType.ASPxComboBox);
        popupdata.AddField(e.NewValues, gvA, "Notes", "notesEditorA", DevExpress.Web.ControlType.ASPxMemo);


        string result = dataops.dxGrid_UpdateData("actionID", pkvals, e.NewValues, "backend", "dbo", "tblAction");


        gvAstatus.Text = result;

        //gvM.JSProperties["gvM_IsUpdated"] = true;

        gv.CancelEdit();
        e.Cancel = true;

        gvA.DataBind();
    }
Exemple #25
0
    protected void gvM_OnRowUpdating(object sender, ASPxDataUpdatingEventArgs e)
    {
        ASPxGridView gv = (ASPxGridView)sender;

        var selected_keys = gvM.GetSelectedFieldValues("StudyMeasSubjID");

        ASPxCheckBox chkAllSelected    = gv.FindEditFormLayoutItemTemplateControl("chkUpdateAllSelected") as ASPxCheckBox;
        bool         updateALLSelected = chkAllSelected.Checked;

        List <int> pkvals = new List <int>();

        foreach (object key in e.Keys.Values)
        {
            int  ikey;
            bool isint = int.TryParse(key.ToString(), out ikey);
            if (isint)
            {
                pkvals.Add(ikey);
            }
        }

        //Add the other selected rows to the update if the user has selected the "Update All" checkbox
        if (selected_keys.Count > 0 && updateALLSelected)
        {
            foreach (object k in selected_keys)
            {
                int  ikey;
                bool isint = int.TryParse(k.ToString(), out ikey);
                if (!pkvals.Contains(ikey))
                {
                    pkvals.Add(ikey);
                }
            }
        }


        popupdata.AddField(e.NewValues, gvM, "MeasStatusID", "CboMS", DevExpress.Web.ControlType.ASPxComboBox);
        popupdata.AddField(e.NewValues, gvM, "MeasStatusDetailID", "CboMSD", DevExpress.Web.ControlType.ASPxComboBox);
        popupdata.AddField(e.NewValues, gvM, "Date", "DateCalendar", DevExpress.Web.ControlType.ASPxDateEdit);
        popupdata.AddField(e.NewValues, gvM, "Clinician", "CboClin", DevExpress.Web.ControlType.ASPxComboBox);
        popupdata.AddField(e.NewValues, gvM, "Notes", "notesEditor", DevExpress.Web.ControlType.ASPxMemo);


        ASPxRadioButtonList rblDate = gv.FindEditFormLayoutItemTemplateControl("rblDate") as ASPxRadioButtonList;

        if (rblDate.Value != null)
        {
            //remove the entered date as we will programmatically assign a different date
            e.NewValues.Remove("Date");

            //Update the date based on the selected mode
            string mode        = rblDate.Value.ToString();
            string date_update = dataops.dxGrid_Update_StudyMeasSubj_Dates(mode, pkvals);
        }


        string result = dataops.dxGrid_UpdateData("studymeassubjID", pkvals, e.NewValues, "backend", "dbo", "tblStudyMeasSubj");


        gvMstatus.Text = result;

        //gvM.JSProperties["gvM_IsUpdated"] = true;

        gv.CancelEdit();
        e.Cancel = true;

        //GetMeasureInfo(ID);
        gvM.DataBind();
    }
Exemple #26
0
    protected void grid_Init(object sender, EventArgs e)
    {
        ASPxGridView g = sender as ASPxGridView;

        g.Visible = g.IsCallback;
    }
 private LayoutItemBase GetEditFormLayoutItemByName(ASPxGridView grid, string name)
 {
     return(grid.EditFormLayoutProperties.FindItemOrGroupByName(name));
 }
Exemple #28
0
        protected void gridRepository_BeforePerformDataSelect(object sender, EventArgs e)
        {
            ASPxGridView gridRepository = (ASPxGridView)sender;

            gridRepository.DataSource = rc_services.GetRepository("P", false);
        }
Exemple #29
0
    protected void GridListagem_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
    {
        ASPxGridView gridView = (ASPxGridView)sender;

        //
        string   ID                  = "";
        string   apelido             = "";
        string   nome                = "";
        string   sexo                = "";
        string   cnpj                = "";
        string   inscmunicipal       = "";
        string   inscestadual        = "";
        string   regjuntacom         = "";
        string   nire                = "";
        string   rg                  = "";
        string   rguf                = "";
        string   rgemissor           = "";
        DateTime rgemissao           = Convert.ToDateTime("01/01/1900");
        string   endereco            = "";
        string   enderecores         = "";
        string   enderecoresnumero   = "";
        string   enderecorescomplem  = "";
        string   bairrores           = "";
        string   cidaderes           = "";
        string   ufres               = "";
        string   cepres              = "";
        string   fone1res            = "";
        string   fone2res            = "";
        string   fone3res            = "";
        string   enderecocom         = "";
        string   enderecocomnumero   = "";
        string   enderecocomcomplem  = "";
        string   bairrocom           = "";
        string   cidadecom           = "";
        string   ufcom               = "";
        string   cepcom              = "";
        string   fone1com            = "";
        string   fone2com            = "";
        string   fone3com            = "";
        string   email1              = "";
        string   email2              = "";
        string   email3              = "";
        string   email4              = "";
        string   email5              = "";
        string   gerente             = "";
        string   contato             = "";
        DateTime dtnascimento        = Convert.ToDateTime("01/01/1900");
        DateTime dtingresso          = Convert.ToDateTime("01/01/1900");
        string   ncontrato           = "";
        DateTime dtcontrato          = Convert.ToDateTime("01/01/1900");
        Boolean  ativo               = true;
        Boolean  acessointernet      = true;
        string   empregador          = "";
        string   cargo               = "";
        string   atividade           = "";
        string   obs1                = "";
        string   obs2                = "";
        string   obs3                = "";
        string   obs4                = "";
        string   obs5                = "";
        string   conjugenome         = "";
        string   conjugesexo         = "";
        string   conjugecnpj         = "";
        string   conjugerg           = "";
        string   conjugerguf         = "";
        string   conjugergemissor    = "";
        DateTime conjugergemissao    = Convert.ToDateTime("01/01/1900");
        DateTime dtnascimentoconjuge = Convert.ToDateTime("01/01/1900");
        string   fone1con            = "";
        string   fone2con            = "";
        string   fone3con            = "";
        string   conjugeemail1       = "";
        string   conjugeemail2       = "";
        string   instrcob1           = "";
        string   instrcob2           = "";
        string   diasprotesto        = "";
        string   conta1              = "";
        string   conta2              = "";
        string   conta3              = "";
        string   conta4              = "";
        string   conta5              = "";
        Boolean  dda                 = false;

        //
        // Empresa
        ID      = uContato.ProximoID();
        apelido = e.NewValues["apelido"].ToString().ToUpper();
        nome    = e.NewValues["nome"].ToString().ToUpper();
        sexo    = e.NewValues["sexo"].ToString().ToUpper();
        cnpj    = e.NewValues["cnpj"].ToString();
        if (e.NewValues["inscmunicipal"] != null)
        {
            inscmunicipal = e.NewValues["inscmunicipal"].ToString();
        }
        if (e.NewValues["inscestadual"] != null)
        {
            inscestadual = e.NewValues["inscestadual"].ToString();
        }
        if (e.NewValues["regjuntacom"] != null)
        {
            regjuntacom = e.NewValues["regjuntacom"].ToString();
        }
        if (e.NewValues["nire"] != null)
        {
            nire = e.NewValues["nire"].ToString();
        }
        if (e.NewValues["rg"] != null)
        {
            rg = e.NewValues["rg"].ToString();
        }
        if (e.NewValues["rguf"] != null)
        {
            rguf = e.NewValues["rguf"].ToString();
        }
        if (e.NewValues["rgemissor"] != null)
        {
            rgemissor = e.NewValues["rgemissor"].ToString();
        }
        if (e.NewValues["rgemissao"] != null)
        {
            rgemissao = Convert.ToDateTime(e.NewValues["rgemissao"].ToString());
        }
        if (e.NewValues["endereco"] != null)
        {
            endereco = e.NewValues["endereco"].ToString();
        }
        //
        if (e.NewValues["enderecores"] != null)
        {
            enderecores = e.NewValues["enderecores"].ToString();
        }
        if (e.NewValues["enderecoresnumero"] != null)
        {
            enderecoresnumero = e.NewValues["enderecoresnumero"].ToString();
        }
        if (e.NewValues["enderecorescomplem"] != null)
        {
            enderecorescomplem = e.NewValues["enderecorescomplem"].ToString();
        }
        if (e.NewValues["bairrores"] != null)
        {
            bairrores = e.NewValues["bairrores"].ToString();
        }
        if (e.NewValues["cidaderes"] != null)
        {
            cidaderes = e.NewValues["cidaderes"].ToString();
        }
        if (e.NewValues["ufres"] != null)
        {
            ufres = e.NewValues["ufres"].ToString();
        }
        if (e.NewValues["cepres"] != null)
        {
            cepres = e.NewValues["cepres"].ToString();
        }
        if (e.NewValues["fone1res"] != null)
        {
            fone1res = e.NewValues["fone1res"].ToString();
        }
        if (e.NewValues["fone2res"] != null)
        {
            fone2res = e.NewValues["fone2res"].ToString();
        }
        if (e.NewValues["fone3res"] != null)
        {
            fone3res = e.NewValues["fone3res"].ToString();
        }
        //
        if (e.NewValues["enderecocom"] != null)
        {
            enderecocom = e.NewValues["enderecocom"].ToString();
        }
        if (e.NewValues["enderecocomnumero"] != null)
        {
            enderecocomnumero = e.NewValues["enderecocomnumero"].ToString();
        }
        if (e.NewValues["enderecocomcomplem"] != null)
        {
            enderecocomcomplem = e.NewValues["enderecocomcomplem"].ToString();
        }
        if (e.NewValues["bairrocom"] != null)
        {
            bairrocom = e.NewValues["bairrocom"].ToString();
        }
        if (e.NewValues["cidadecom"] != null)
        {
            cidadecom = e.NewValues["cidadecom"].ToString();
        }
        if (e.NewValues["ufcom"] != null)
        {
            ufcom = e.NewValues["ufcom"].ToString();
        }
        if (e.NewValues["cepcom"] != null)
        {
            cepcom = e.NewValues["cepcom"].ToString();
        }
        if (e.NewValues["fone1com"] != null)
        {
            fone1com = e.NewValues["fone1com"].ToString();
        }
        if (e.NewValues["fone2com"] != null)
        {
            fone2com = e.NewValues["fone2com"].ToString();
        }
        if (e.NewValues["fone3com"] != null)
        {
            fone3com = e.NewValues["fone3com"].ToString();
        }
        //
        if (e.NewValues["email1"] != null)
        {
            email1 = e.NewValues["email1"].ToString();
        }
        if (e.NewValues["email2"] != null)
        {
            email2 = e.NewValues["email2"].ToString();
        }
        if (e.NewValues["email3"] != null)
        {
            email3 = e.NewValues["email3"].ToString();
        }
        if (e.NewValues["email4"] != null)
        {
            email4 = e.NewValues["email4"].ToString();
        }
        if (e.NewValues["email5"] != null)
        {
            email5 = e.NewValues["email5"].ToString();
        }
        if (e.NewValues["gerente"] != null)
        {
            gerente = e.NewValues["gerente"].ToString().ToUpper();
        }
        if (e.NewValues["contato"] != null)
        {
            contato = e.NewValues["contato"].ToString().ToUpper();
        }
        if (e.NewValues["dtnascimento"] != null)
        {
            dtnascimento = Convert.ToDateTime(e.NewValues["dtnascimento"].ToString());
        }
        if (e.NewValues["dtingresso"] != null)
        {
            dtingresso = Convert.ToDateTime(e.NewValues["dtingresso"].ToString());
        }
        if (e.NewValues["ncontrato"] != null)
        {
            ncontrato = e.NewValues["ncontrato"].ToString();
        }
        if (e.NewValues["dtcontrato"] != null)
        {
            dtcontrato = Convert.ToDateTime(e.NewValues["dtcontrato"].ToString());
        }
        if (e.NewValues["ativo"] != null)
        {
            ativo = Convert.ToBoolean(e.NewValues["ativo"].ToString());
        }
        if (e.NewValues["acessointernet"] != null)
        {
            acessointernet = Convert.ToBoolean(e.NewValues["acessointernet"].ToString());
        }
        //
        if (e.NewValues["empregador"] != null)
        {
            empregador = e.NewValues["empregador"].ToString();
        }
        if (e.NewValues["cargo"] != null)
        {
            cargo = e.NewValues["cargo"].ToString();
        }
        if (e.NewValues["atividade"] != null)
        {
            atividade = e.NewValues["atividade"].ToString();
        }
        //
        if (e.NewValues["obs1"] != null)
        {
            obs1 = e.NewValues["obs1"].ToString();
        }
        if (e.NewValues["obs2"] != null)
        {
            obs2 = e.NewValues["obs2"].ToString();
        }
        if (e.NewValues["obs3"] != null)
        {
            obs3 = e.NewValues["obs3"].ToString();
        }
        if (e.NewValues["obs4"] != null)
        {
            obs4 = e.NewValues["obs4"].ToString();
        }
        if (e.NewValues["obs5"] != null)
        {
            obs5 = e.NewValues["obs5"].ToString();
        }
        if (e.NewValues["instrcob1"] != null)
        {
            instrcob1 = e.NewValues["instrcob1"].ToString();
        }
        if (e.NewValues["instrcob2"] != null)
        {
            instrcob2 = e.NewValues["instrcob2"].ToString();
        }
        if (e.NewValues["diasprotesto"] != null)
        {
            diasprotesto = e.NewValues["diasprotesto"].ToString();
        }
        if (e.NewValues["conta1"] != null)
        {
            conta1 = e.NewValues["conta1"].ToString();
        }
        if (e.NewValues["conta2"] != null)
        {
            conta2 = e.NewValues["conta2"].ToString();
        }
        if (e.NewValues["conta3"] != null)
        {
            conta3 = e.NewValues["conta3"].ToString();
        }
        if (e.NewValues["conta4"] != null)
        {
            conta4 = e.NewValues["conta4"].ToString();
        }
        if (e.NewValues["conta5"] != null)
        {
            conta5 = e.NewValues["conta5"].ToString();
        }
        if (e.NewValues["dda"] != null)
        {
            dda = Convert.ToBoolean(e.NewValues["dda"].ToString());
        }

        if (uContato.PesquisaCpfCnpj(cnpj).Trim() == "")
        {
            uContato.Grava(ID,
                           apelido,
                           nome,
                           sexo,
                           cnpj,
                           inscmunicipal,
                           inscestadual,
                           regjuntacom,
                           nire,
                           rg,
                           rguf,
                           rgemissor,
                           rgemissao,
                           endereco,
                           enderecores,
                           enderecoresnumero,
                           enderecorescomplem,
                           bairrores,
                           cidaderes,
                           ufres,
                           cepres,
                           fone1res,
                           fone2res,
                           fone3res,
                           enderecocom,
                           enderecocomnumero,
                           enderecocomcomplem,
                           bairrocom,
                           cidadecom,
                           ufcom,
                           cepcom,
                           fone1com,
                           fone2com,
                           fone3com,
                           email1,
                           email2,
                           email3,
                           email4,
                           email5,
                           gerente,
                           contato,
                           dtnascimento,
                           dtingresso,
                           ncontrato,
                           dtcontrato,
                           ativo,
                           acessointernet,
                           empregador,
                           cargo,
                           atividade,
                           conjugenome,
                           conjugesexo,
                           conjugecnpj,
                           conjugerg,
                           conjugerguf,
                           conjugergemissor,
                           conjugergemissao,
                           dtnascimentoconjuge,
                           fone1con,
                           fone2con,
                           fone3con,
                           conjugeemail1,
                           conjugeemail2,
                           obs1,
                           obs2,
                           obs3,
                           obs4,
                           obs5,
                           instrcob1,
                           instrcob2,
                           diasprotesto,
                           conta1,
                           conta2,
                           conta3,
                           conta4,
                           conta5,
                           dda);


            gridView.CancelEdit();
            e.Cancel = true;

            //Usando Classe uLog.MakeLog - Gravando Log
            fwObs_Log = "INCLUI CONTATO: NOVO/" + cnpj + "/" + apelido;
            SqlParameter[] param_log = { new SqlParameter("@login",    (String)Session["CodUsuario"]),
                                         new SqlParameter("@tabela",   fWtabela),
                                         new SqlParameter("@operacao", "CONTATO"),
                                         new SqlParameter("@obs",      "INCLUI"),
                                         new SqlParameter("@acao",     fwObs_Log) };
            uLog.MakeLog(param_log);
            //
            AtualizaGrid();
            //
        }
        else
        {
            //ScriptManager.RegisterStartupScript(UpdatePanel, GetType(), "msgbox", "alert('CPF/CNPJ ja existe no Cadastro!');", true);
            ScriptManager.RegisterStartupScript(this.Page, typeof(Page), Guid.NewGuid().ToString(),
                                                "toastr.error('CPF/CNPJ ja existe no Cadastro!', 'Atenção!')", true);
        }
    }
Exemple #30
0
 string PaneResized(ASPxGridView gridView) {
     return string.Format(CultureInfo.InvariantCulture,
                          "function (s,e) {{ if (e.pane.name==='listPane') {{ {0}.SetWidth(e.pane.GetClientWidth()); {0}.SetHeight(e.pane.GetClientHeight());}}}}",
                          gridView.ClientInstanceName);
 }
Exemple #31
0
 void SetupViewItems(ASPxGridView gridView) {
     if (string.IsNullOrEmpty(gridView.ClientInstanceName))
         gridView.ClientInstanceName = "gridViewInSplitter";
 }
 /// <summary>
 /// GridView的直接子控件的显示情况(GridView.Column可填Caption/FieldName)
 /// </summary>
 /// <param name="gv"></param>
 public static void Bind_Authority(ASPxGridView gv)
 {
     Bind_Authority(gv, "", "");
 }
 List<GridViewDataColumn> GetVisibleDataColumns(ASPxGridView aspxGridView1)
 {
     List<GridViewDataColumn> columns = new List<GridViewDataColumn>();
     foreach (GridViewColumn column in aspxGridView1.VisibleColumns)
     {
         if (column is GridViewDataColumn)
             columns.Add(column as GridViewDataColumn);
     }
     return columns;
 }
        private bool DeleteButtonVisibleCriteria(ASPxGridView grid, int visibleIndex)
        {
            object row = grid.GetRow(visibleIndex);

            return(((SPPBModel.SPPB)(row)).StatusDesc.ToString().ToUpper().Contains("SAVE"));
        }
 protected void FocusThisRowGrid(ASPxGridView grid, int keyVal)
 {
     grid.FocusedRowIndex = grid.FindVisibleIndexByKeyValue(keyVal);
 }
Exemple #36
0
 ASPxPageControl FindPageControl(ASPxGridView grid)
 {
     return(grid.FindEditFormTemplateControl("pageControl") as ASPxPageControl);
 }
Exemple #37
0
    protected void grid_CerDet_BeforePerformDataSelect(object sender, EventArgs e)
    {
        ASPxGridView grd = sender as ASPxGridView;

        this.dsCertificateDet.FilterExpression = "CerNo='" + SafeValue.SafeInt(grd.GetMasterRowKeyValue(), 0) + "'";
    }
Exemple #38
0
    /// <summary>
    /// 绑定超链接
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void grid_CustomColumnDisplayText(object sender, ASPxGridViewColumnDisplayTextEventArgs e)
    {
        ASPxGridView gv = sender as ASPxGridView;
        DataTable    dt = gv.DataSource as DataTable;

        if (dt != null && e.Column.Index > 2 && e.Value.ToString() != "0")
        {
            string date      = Convert.ToString(dt.Rows[e.VisibleRowIndex][0]);
            string shiftName = Convert.ToString(dt.Rows[e.VisibleRowIndex][1]);
            string trxType   = Convert.ToString(dt.Rows[e.VisibleRowIndex][2]);
            string isHistory = this.rbtHistory.Checked ? "1" : "0";
            string colHeader = e.Column.FieldName;

            var results = from item in this._dtSource.AsEnumerable()
                          where Convert.ToString(item["CALC_DATE"]) == date &&
                          Convert.ToString(item["SHIFT_NAME"]) == shiftName &&
                          Convert.ToString(item["OPERATION_NAME"]) == colHeader
                          select new { StartTime = item["START_TIME"], EndTime = item["END_TIME"] };
            if (colHeader == "SUM_VALUE")
            {
                colHeader = "ALL";
                results   = from item in this._dtSource.AsEnumerable()
                            where Convert.ToString(item["CALC_DATE"]) == date &&
                            Convert.ToString(item["SHIFT_NAME"]) == shiftName
                            select new { StartTime = item["START_TIME"], EndTime = item["END_TIME"] };
            }
            string startTime = Convert.ToString(results.Min(a => a.StartTime));
            string endTime   = Convert.ToString(results.Max(a => a.EndTime));

            if (!this.rbtHistory.Checked)
            {
                string inputStartTime = this.dateStart.Text + " " + this.deStartTime.Text;
                string inputEndTime   = this.dateEnd.Text + " " + this.deEndTime.Text;
                if (startTime.CompareTo(inputStartTime) < 0)
                {
                    startTime = inputStartTime;
                }

                if (endTime.CompareTo(inputEndTime) > 0)
                {
                    endTime = inputEndTime;
                }
            }

            if (sender == this.grid && trxType != "CELL_REAL_SCRAP_QTY")
            {
                string url = string.Format(@"WipOperationOutputDetail_Line.aspx?date={0}&shiftName={1}&startTime={2}&endTime={3}&trxType={4}&stepName={5}&roomName={6}&proId={7}&workOrderNo={8}&isHistory={9}&partNumber={10}&oprline={11}",
                                           Server.UrlEncode(date),
                                           Server.UrlEncode(shiftName),
                                           Server.UrlEncode(startTime),
                                           Server.UrlEncode(endTime),
                                           Server.UrlEncode(trxType),
                                           Server.UrlEncode(colHeader),
                                           Server.UrlEncode(this.cmbWorkPlace.Text),
                                           Server.UrlEncode(this.cmbProduct.Text),
                                           Server.UrlEncode(this.cmbWorkOrderNumber.Text),
                                           isHistory,
                                           Server.UrlEncode(this.cmbPartNumber.Text),
                                           Server.UrlEncode(lineName)
                                           );

                e.DisplayText = string.Format("<a href=\"javascript:void(0);\" onclick=\"javascript:window.open('{1}')\" class=\"dxgv\" style=\"text-decoration:underline;\">{0}</a>",
                                              e.Value, url);
            }
        }
        if (e.Column.Index == 2)
        {
            e.DisplayText = dic[Convert.ToString(e.Value)];
        }
        if (e.Column.Index > 2 && string.IsNullOrEmpty(e.Value.ToString()))
        {
            e.DisplayText = "0";
        }
    }
Exemple #39
0
 private void RefreshGrid(ASPxGridView gv)
 {
     gv.DataSource = CRUDHelper.ReadAll("", BusinessMapper.GetDaoByEntity(BusinessMapper.eEntities.EspacioCont));
     gv.DataBind();
 }
Exemple #40
0
 public StatusBarTemplate(ASPxGridView grid)
 {
     _grid = grid;
 }
Exemple #41
0
        //private void SpecificServersRebuildGrids(object fromGridVal, object toGridVal)
        //{
        //    ASPxGridView fromGrid = (ASPxGridView)fromGridVal;
        //    ASPxGridView toGrid = (ASPxGridView)toGridVal;
        //    DataTable dataFrom = new DataTable();
        //    DataTable dataTo = new DataTable();
        //    dataTo.Columns.Add("ID");
        //    dataTo.Columns.Add("ServerName");
        //    dataTo.Columns.Add("Location");
        //    dataTo.Columns.Add("ServerType");
        //    if (Session["visible"] != null && Session["visible"] != "")
        //    {
        //        dataFrom = (DataTable)Session["visible"];
        //    }
        //    //else
        //    //{
        //    //    dataFrom = (DataTable)Session["ServerVisibleDataGrid"];
        //    //}
        //    List<int> Id = new List<int>();
        //    List<Object> SelectItemServerID = fromGrid.GetSelectedFieldValues("ID");
        //    foreach (object SelectItemID in SelectItemServerID)
        //    {
        //        foreach (DataRow Dr in dataFrom.Rows)
        //        {
        //            if (Dr["ID"].ToString() == SelectItemID.ToString())
        //            {

        //                Id.Add(dataFrom.Rows.IndexOf(Dr));
        //                dataTo.ImportRow(Dr);
        //                //dataFrom.Rows.Remove(Dr);

        //            }
        //            dataTo.AcceptChanges();

        //        }

        //    }
        //    foreach (int DrID in Id)
        //    {
        //        dataFrom.Rows[DrID].Delete();
        //    }

        //    dataFrom.AcceptChanges();

        //    DataTable NotVisible = new DataTable();
        //    NotVisible.Columns.Add("ID");
        //    NotVisible.Columns.Add("ServerName");
        //    NotVisible.Columns.Add("Location");
        //    NotVisible.Columns.Add("ServerType");
        //    if (Session["NotVisible"] != null && Session["NotVisible"] != "")
        //    {
        //        NotVisible = (DataTable)Session["NotVisible"];
        //        foreach (DataRow dr in dataTo.Rows)
        //        {
        //            NotVisible.ImportRow(dr);
        //        }

        //    }
        //    else
        //    {
        //        Session["NotVisible"] = dataTo;
        //    }
        //    fromGrid.DataSource = dataFrom;
        //    fromGrid.KeyFieldName = "ID";
        //    fromGrid.DataBind();
        //    fromGrid.Selection.UnselectAll();
        //    Session["visible"] = dataFrom;
        //    if (NotVisible.Rows.Count == 0)
        //    {
        //        toGrid.DataSource = (DataTable)Session["NotVisible"];
        //    }
        //    else
        //    {
        //        toGrid.DataSource = NotVisible;
        //    }
        //    toGrid.KeyFieldName = "ID";
        //    toGrid.DataBind();
        //}

        private void SpecificServersRebuildGrids(object fromGridVal, object toGridVal, string fromSession, string toSession)
        {
            ASPxGridView fromGrid = (ASPxGridView)fromGridVal;
            ASPxGridView toGrid   = (ASPxGridView)toGridVal;
            DataTable    dataFrom = new DataTable();
            DataTable    dataTo   = new DataTable();

            dataTo.Columns.Add("ID");
            dataTo.Columns.Add("ServerName");
            dataTo.Columns.Add("Location");
            dataTo.Columns.Add("ServerType");
            if (Session[fromSession] != null && Session[fromSession] != "")
            {
                dataFrom = (DataTable)Session[fromSession];
            }

            //else
            //{
            //    dataFrom = (DataTable)Session["ServerVisibleDataGrid"];
            //}
            List <int>    Id = new List <int>();
            List <Object> SelectItemServerID = fromGrid.GetSelectedFieldValues("ID");

            foreach (object SelectItemID in SelectItemServerID)
            {
                foreach (DataRow Dr in dataFrom.Rows)
                {
                    try
                    {
                        if (Dr["ID"].ToString() == SelectItemID.ToString())
                        {
                            Id.Add(dataFrom.Rows.IndexOf(Dr));
                            dataTo.ImportRow(Dr);
                            //dataFrom.Rows.Remove(Dr);
                        }
                        dataTo.AcceptChanges();
                    }
                    catch { }
                }
            }
            foreach (int DrID in Id)
            {
                dataFrom.Rows[DrID].Delete();
            }

            dataFrom.AcceptChanges();

            DataTable NotVisible = new DataTable();

            NotVisible.Columns.Add("ID");
            NotVisible.Columns.Add("ServerName");
            NotVisible.Columns.Add("Location");
            NotVisible.Columns.Add("ServerType");
            if (Session[toSession] != null && Session[toSession] != "")
            {
                NotVisible = (DataTable)Session[toSession];
                foreach (DataRow dr in dataTo.Rows)
                {
                    NotVisible.ImportRow(dr);
                }
            }
            else
            {
                Session[toSession] = dataTo;
            }
            fromGrid.DataSource   = dataFrom;
            fromGrid.KeyFieldName = "ID";
            fromGrid.DataBind();
            fromGrid.Selection.UnselectAll();
            Session[fromSession] = dataFrom;
            if (NotVisible.Rows.Count == 0)
            {
                toGrid.DataSource = (DataTable)Session[toSession];
            }
            else
            {
                toGrid.DataSource = NotVisible;
            }
            toGrid.KeyFieldName = "ID";
            toGrid.DataBind();
            //9/21/2015 NS added
            Session[toSession] = NotVisible;
        }
Exemple #42
0
 protected object GetValueFromControlSettings(ASPxGridView grid, string idName)
 {
     return GetValueFromControlGeneric(idName, grid, "settingsPageControl");
 }
 void InitFilters(ASPxGridView aspxGridView1)
 {
     report.FilterString = aspxGridView1.FilterExpression;
 }
        void detailView_Load(object sender, EventArgs e)
        {
            ASPxGridView detailView = (ASPxGridView)sender;

            detailView.DataBind();
        }
Exemple #45
0
        protected object GetValueFromControlGeneric(string idName, ASPxGridView grid, string pageControlID)
        {
            ASPxPageControl pageControl = grid.FindEditFormTemplateControl(pageControlID) as ASPxPageControl;
            if (pageControl == null) return null;
            object control = pageControl.FindControl(idName);
            if (control is ASPxTextBox)
            {
                ASPxTextBox t = control as ASPxTextBox;
                return t.Text;
            }
            else if (control is ASPxSpinEdit)
            {
                ASPxSpinEdit t = control as ASPxSpinEdit;
                return t.Value;
            }
            else if (control is ASPxDateEdit)
            {
                ASPxDateEdit t = control as ASPxDateEdit;
                return t.Date;
            }
            else if (control is ASPxComboBox)
            {
                ASPxComboBox t = control as ASPxComboBox;
                return t.Value;
            }
            else if (control is ASPxMemo)
            {
                ASPxMemo t = control as ASPxMemo;
                return t.Text;
            }
            else if (control is ASPxCheckBox)
            {
                ASPxCheckBox t = control as ASPxCheckBox;
                return t.Checked;
            }
            else if (control is DevExpress.Web.ASPxHtmlEditor.ASPxHtmlEditor)
            {
                DevExpress.Web.ASPxHtmlEditor.ASPxHtmlEditor t = control as DevExpress.Web.ASPxHtmlEditor.ASPxHtmlEditor;
                return t.Html;
            }

            return "";
        }
 void InitSortings(ASPxGridView aspxGridView1)
 {
     List<GridViewDataColumn> columns = GetVisibleDataColumns(aspxGridView1);
     ReadOnlyCollection<GridViewDataColumn> groupedColumns = aspxGridView1.GetGroupedColumns();
     for (int i = 0; i < columns.Count; i++)
     {
         if (!groupedColumns.Contains(columns[i]))
         {
             if (columns[i].SortOrder != ColumnSortOrder.None)
                 ((DetailBand)report.Bands[BandKind.Detail]).SortFields.Add(new GroupField(columns[i].FieldName, columns[i].SortOrder == ColumnSortOrder.Ascending ? XRColumnSortOrder.Ascending : XRColumnSortOrder.Descending));
         }
     }
 }
 private void SetFirstRowChangeAfterInit(ASPxGridView grid, bool value) {
     grid.ClientSideEvents.Init = string.Format(CultureInfo.InvariantCulture,
         "function (s,e) {{ s.firstRowChangedAfterInit = {0};}}", value ? "true" : "false");
 }
Exemple #48
0
 private void RefreshGrid(ASPxGridView gv)
 {
     gv.DataSource = Business.TecnologiaSoporte.ReadAll("");
     gv.DataBind();
 }
Exemple #49
0
        protected void ASPxGridView2_BeforePerformDataSelect(object sender, EventArgs e)
        {
            ASPxGridView grdTransactionDetail = (ASPxGridView)sender;

            Session["TransactionId"] = grdTransactionDetail.GetMasterRowKeyValue();
        }
Exemple #50
0
        protected void CapexGridApproval_DataBound(object sender, EventArgs e)
        {
            ASPxGridView grid = sender as ASPxGridView;

            MRPClass.VisibilityRevDesc(grid, entitycode);
        }
        public XtraReport GenerateReport(ASPxGridView aspxGridView1, SqlDataSource aspDataSource)
        {
            report = new XtraReport();
            report.Landscape = true;
            report.PaperKind = System.Drawing.Printing.PaperKind.Letter;

            InitDataSource(aspDataSource);
            InitDetailsAndPageHeader(aspxGridView1);
            InitSortings(aspxGridView1);
            InitGroupHeaders(aspxGridView1);
            InitFilters(aspxGridView1);
            InitTotalSummaries(aspxGridView1);
            return report;
        }
Exemple #52
0
    protected string SaveJob()
    {
        try
        {
            ASPxGridView g = this.grid_Transport;


            ASPxTextBox houseId              = g.FindEditFormTemplateControl("txt_Id") as ASPxTextBox;
            int         Id                   = SafeValue.SafeInt(houseId.Text, 0);
            ASPxTextBox parentId             = g.FindEditFormTemplateControl("txt_ParentId") as ASPxTextBox;
            Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(Container), "Id='" + Id + "'");
            Container al    = C2.Manager.ORManager.GetObject(query) as Container;
            bool      isNew = false;
            if (Id == 0)
            {
                isNew = true;
                al    = new Container();
            }
            ASPxTextBox  containerNo   = g.FindEditFormTemplateControl("txt_ContainerNo") as ASPxTextBox;
            ASPxComboBox containerType = g.FindEditFormTemplateControl("cmb_ContainerType") as ASPxComboBox;
            if (containerNo.Text.Trim().Length == 0 || containerType.Text.Trim().Length == 0)
            {
                return("ContainerNo and ContainerType are require");
            }
            string checkContainerNO = "select COUNT(*) from Ref_Container where [id]<>" + Id + " and containerNo='" + containerNo.Text + "' ";
            int    checkResult      = SafeValue.SafeInt(ConnectSql.GetTab(checkContainerNO).Rows[0][0], 0);
            if (checkResult > 0)
            {
                return("This ContainerNo is Existed");
            }
            al.ContainerNo = containerNo.Text;
            ASPxDateEdit commDate = g.FindEditFormTemplateControl("date_CommissionDate") as ASPxDateEdit;
            al.CommDate = commDate.Date;
            ASPxComboBox containerCategory = g.FindEditFormTemplateControl("cmb_ContainerCategory") as ASPxComboBox;
            al.TankCat = containerCategory.Text;
            ASPxTextBox lessor = g.FindEditFormTemplateControl("txt_Lessor") as ASPxTextBox;
            al.Lessor = lessor.Text;
            ASPxDateEdit onHireDateTime = g.FindEditFormTemplateControl("date_OnHireDate") as ASPxDateEdit;
            al.OnHireDateTime = onHireDateTime.Date;
            ASPxDateEdit offHireDateTime = g.FindEditFormTemplateControl("date_OffHireDate") as ASPxDateEdit;
            al.OffHireDateTime = offHireDateTime.Date;
            ASPxDateEdit manuDate = g.FindEditFormTemplateControl("date_Manufacture") as ASPxDateEdit;
            al.ManuDate = manuDate.Date;
            ASPxTextBox manufacturer = g.FindEditFormTemplateControl("txt_Manufacturer") as ASPxTextBox;
            al.Manufacturer = manufacturer.Text;
            ASPxTextBox plateNo = g.FindEditFormTemplateControl("txt_PlateNo") as ASPxTextBox;
            al.PlateNo       = plateNo.Text;
            al.ContainerType = containerType.Text;
            ASPxSpinEdit externalLength = g.FindEditFormTemplateControl("spin_ExternalLength") as ASPxSpinEdit;
            al.ExternalLength = SafeValue.SafeDecimal(externalLength.Value, 0);
            ASPxSpinEdit externalWidth = g.FindEditFormTemplateControl("spin_ExternalWidth") as ASPxSpinEdit;
            al.ExternalBreadth = SafeValue.SafeDecimal(externalWidth.Value, 0);
            ASPxSpinEdit externalHeight = g.FindEditFormTemplateControl("spin_ExternalHeight") as ASPxSpinEdit;
            al.ExternalHeight = SafeValue.SafeDecimal(externalHeight.Value, 0);
            ASPxSpinEdit internalLength = g.FindEditFormTemplateControl("spin_InternalLength") as ASPxSpinEdit;
            al.InternalLength = SafeValue.SafeDecimal(internalLength.Value, 0);
            ASPxSpinEdit internalBreadth = g.FindEditFormTemplateControl("spin_InternalBreadth") as ASPxSpinEdit;
            al.InternalBreadth = SafeValue.SafeDecimal(internalBreadth.Value, 0);
            ASPxSpinEdit internalHeight = g.FindEditFormTemplateControl("spin_InternalHeight") as ASPxSpinEdit;
            al.InternalHeight = SafeValue.SafeDecimal(internalHeight.Value, 0);
            ASPxTextBox material = g.FindEditFormTemplateControl("txt_Material") as ASPxTextBox;
            al.Material = material.Text;
            ASPxTextBox externalCoat = g.FindEditFormTemplateControl("txt_ExternalCoat") as ASPxTextBox;
            al.ExternalCoat = externalCoat.Text;
            ASPxSpinEdit capacity = g.FindEditFormTemplateControl("spin_Capacity") as ASPxSpinEdit;
            al.Capacity = SafeValue.SafeDecimal(capacity.Value, 0);
            ASPxSpinEdit maxGrossWeight = g.FindEditFormTemplateControl("spin_MaxGrossWeight") as ASPxSpinEdit;
            al.MaxGrossWeight = SafeValue.SafeDecimal(maxGrossWeight.Value, 0);
            ASPxSpinEdit tareWeight = g.FindEditFormTemplateControl("spin_TareWeight") as ASPxSpinEdit;
            al.TareWeight = SafeValue.SafeDecimal(tareWeight.Value, 0);
            ASPxSpinEdit maxPayload = g.FindEditFormTemplateControl("spin_MaxPayload") as ASPxSpinEdit;
            al.MaxPayload = SafeValue.SafeDecimal(maxPayload.Value, 0);
            ASPxSpinEdit testPress = g.FindEditFormTemplateControl("spin_TestPress") as ASPxSpinEdit;
            al.TestPress = SafeValue.SafeDecimal(testPress.Value, 0);
            ASPxSpinEdit thickness = g.FindEditFormTemplateControl("spin_Thickness") as ASPxSpinEdit;
            al.Thickness = SafeValue.SafeDecimal(thickness.Value, 0);
            ASPxMemo approvals = g.FindEditFormTemplateControl("txt_Approvals") as ASPxMemo;
            al.Approvals = approvals.Text;
            ASPxComboBox inActive = g.FindEditFormTemplateControl("cbb_InActive") as ASPxComboBox;
            al.StatusCode = inActive.Text;


            if (isNew)
            {
                al.CreateBy       = EzshipHelper.GetUserName();
                al.CreateDateTime = DateTime.Now;
                //al.StatusCode = "Use";
                C2.Manager.ORManager.StartTracking(al, Wilson.ORMapper.InitialState.Inserted);
                C2.Manager.ORManager.PersistChanges(al);


                houseId.Text = al.Id.ToString();
                //this.txt_JobNo.Text = tpt1.JobNo;
                //Session["TptWhere"] = "Id='" + al.Id + "'";
                this.dsTransport.FilterExpression = "";
                //if (this.grid_Transport.GetRow(0) != null)
                //    this.grid_Transport.StartEdit(this.grid_Transport.VisibleRowCount);
            }
            else
            {
                al.UpdateBy       = EzshipHelper.GetUserName();
                al.UpdateDateTime = DateTime.Now;
                C2.Manager.ORManager.StartTracking(al, Wilson.ORMapper.InitialState.Updated);
                C2.Manager.ORManager.PersistChanges(al);
            }
            this.grid_Transport.CancelEdit();
        }
        catch (Exception ex)
        { throw new Exception(ex.Message + ex.StackTrace); }
        return("Success");
    }
 private List<ColumnInfo> GetColumnsInfo(ASPxGridView aspxGridView1, int pagewidth)
 {
     List<ColumnInfo> columns = new List<ColumnInfo>();
     List<GridViewDataColumn> visibleColumns = GetVisibleDataColumns(aspxGridView1);
     foreach (GridViewDataColumn dataColumn in visibleColumns)
     {
         ColumnInfo column = new ColumnInfo(dataColumn) { ColumnCaption = string.IsNullOrEmpty(dataColumn.Caption) ? dataColumn.FieldName : dataColumn.Caption, ColumnWidth = ((int)pagewidth / visibleColumns.Count), FieldName = dataColumn.FieldName, IsVisible = true };
         columns.Add(column);
     }
     return columns;
 }
        protected void grdSCMProcurementOffDetails_BeforeGetCallbackResult(object sender, EventArgs e)
        {
            ASPxGridView grid = sender as ASPxGridView;

            MRPClass.SetBehaviorGrid(grid);
        }
Exemple #55
0
    protected void grid_InvDet_BeforePerformDataSelect(object sender, EventArgs e)
    {
        ASPxGridView grd = sender as ASPxGridView;

        this.dsArInvoiceDet.FilterExpression = "DocId='" + SafeValue.SafeInt(grd.GetMasterRowKeyValue(), 0) + "'";
    }
    protected void GridListagem_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
    {
        ASPxGridView gridView = (ASPxGridView)sender;

        DateTime dtcompensacao = Convert.ToDateTime(e.NewValues["dtcompensacao"]);

        //
        uContasPagar.AlteraCompensacao(e.NewValues["ID"].ToString(), dtcompensacao.ToString().Substring(0, 10));
        //

        gridView.CancelEdit();
        e.Cancel = true;

        //Usando Classe uLog.MakeLog - Gravando Log
        fwObs_Log = "ALTERAÇÃO CONTAS A PAGAR - COMPENSAÇÃO ID/Lançamento/Data: " +
                    e.NewValues["ID"].ToString() + "/" +
                    e.NewValues["lancamento"].ToString().ToUpper() + "/" +
                    dtcompensacao.ToString().Substring(0, 10);

        SqlParameter[] param_log = { new SqlParameter("@login",    (String)Session["CodUsuario"]),
                                     new SqlParameter("@tabela",   fWtabela),
                                     new SqlParameter("@operacao", "CONTAS A PAGAR"),
                                     new SqlParameter("@obs",      "ALTERAÇÃO"),
                                     new SqlParameter("@acao",     fwObs_Log) };
        uLog.MakeLog(param_log);

        //Todas
        if (rbparcelasituacao.SelectedIndex == 0)
        {
            //Todas/Lançamento
            if (rbordenacao.SelectedIndex == 0)
            {
                GridListagem.Visible = true;
                AtualizaGrid("T", "L");
            }
            //Todas/Classe Despesa
            if (rbordenacao.SelectedIndex == 1)
            {
                GridListagem.Visible = true;
                AtualizaGrid("T", "D");
            }
            //Todas/Fornecedores
            if (rbordenacao.SelectedIndex == 2)
            {
                GridListagem.Visible = true;
                AtualizaGrid("T", "F");
            }
            //Todas/Data Prevista
            if (rbordenacao.SelectedIndex == 3)
            {
                GridListagem.Visible = true;
                AtualizaGrid("T", "DP");
            }
            //Todas/Data Realizado
            if (rbordenacao.SelectedIndex == 4)
            {
                GridListagem.Visible = true;
                AtualizaGrid("T", "DR");
            }
            //Todas/Data Nota Fiscal
            if (rbordenacao.SelectedIndex == 5)
            {
                GridListagem.Visible = true;
                AtualizaGrid("T", "DN");
            }
        }
        //Previsto
        if (rbparcelasituacao.SelectedIndex == 1)
        {
            //Previsto/Lançamento
            if (rbordenacao.SelectedIndex == 0)
            {
                GridListagem.Visible = true;
                AtualizaGrid("P", "L");
            }
            //Previsto/Classe Despesa
            if (rbordenacao.SelectedIndex == 1)
            {
                GridListagem.Visible = true;
                AtualizaGrid("P", "D");
            }
            //Previsto/Fornecedores
            if (rbordenacao.SelectedIndex == 2)
            {
                GridListagem.Visible = true;
                AtualizaGrid("P", "F");
            }
            //Previsto/Data Prevista
            if (rbordenacao.SelectedIndex == 3)
            {
                GridListagem.Visible = true;
                AtualizaGrid("P", "DP");
            }
            //Previsto/Data Realizado
            if (rbordenacao.SelectedIndex == 4)
            {
                GridListagem.Visible = true;
                AtualizaGrid("P", "DR");
            }
            //Previsto/Data Nota Fiscal
            if (rbordenacao.SelectedIndex == 5)
            {
                GridListagem.Visible = true;
                AtualizaGrid("P", "DN");
            }
        }
        //Realizado
        if (rbparcelasituacao.SelectedIndex == 2)
        {
            //Realizado/Lançamento
            if (rbordenacao.SelectedIndex == 0)
            {
                GridListagem.Visible = true;
                AtualizaGrid("R", "L");
            }
            //Realizado/Classe Despesa
            if (rbordenacao.SelectedIndex == 1)
            {
                GridListagem.Visible = true;
                AtualizaGrid("R", "D");
            }
            //Realizado/Fornecedores
            if (rbordenacao.SelectedIndex == 2)
            {
                GridListagem.Visible = true;
                AtualizaGrid("R", "F");
            }
            //Realizado/Data Prevista
            if (rbordenacao.SelectedIndex == 3)
            {
                GridListagem.Visible = true;
                AtualizaGrid("R", "DP");
            }
            //Realizado/Data Realizado
            if (rbordenacao.SelectedIndex == 4)
            {
                GridListagem.Visible = true;
                AtualizaGrid("R", "DR");
            }
            //Realizado/Data Nota Fiscal
            if (rbordenacao.SelectedIndex == 5)
            {
                GridListagem.Visible = true;
                AtualizaGrid("R", "DN");
            }
        }
    }
 void InitGroupHeaders(ASPxGridView aspxGridView1)
 {
     ReadOnlyCollection<GridViewDataColumn> groupedColumns = aspxGridView1.GetGroupedColumns();
     for (int i = groupedColumns.Count - 1; i >= 0; i--)
     {
         {
             GridViewDataColumn groupedColumn = groupedColumns[i];
             GroupHeaderBand gb = new GroupHeaderBand();
             gb.Height = bandHeight;
             XRLabel l = new XRLabel();
             l.Text = groupedColumn.FieldName + ": [" + groupedColumn.FieldName + "]";
             l.LocationF = new PointF(initialGroupOffset + i * 10, 0);
             l.BackColor = Color.Beige;
             l.SizeF = new SizeF((report.PageWidth - (report.Margins.Left + report.Margins.Right)) - (initialGroupOffset + i * subGroupOffset), bandHeight);
             gb.Controls.Add(l);
             gb.RepeatEveryPage = shouldRepeatGroupHeadersOnEveryPage;
             GroupField gf = new GroupField(groupedColumn.FieldName, groupedColumn.SortOrder == ColumnSortOrder.Ascending ? XRColumnSortOrder.Ascending : XRColumnSortOrder.Descending);
             gb.GroupFields.Add(gf);
             report.Bands.Add(gb);
         }
     }
 }
Exemple #58
0
    protected void GridListagem_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
    {
        ASPxGridView gridView = (ASPxGridView)sender;

        //
        string   ID        = "";
        string   cod_banco = "";
        string   nome      = "";
        DateTime data;
        string   drive           = "";
        string   pasta_remessa   = "";
        string   pasta_retorno   = "";
        string   pasta_envelope  = "";
        string   assunto         = "";
        string   caixa_postal    = "";
        string   mascara_remessa = "";
        string   mascara_retorno = "";
        string   nome_arquivo    = "";
        string   numero_arquivo  = "";
        string   prazo_fol       = "";
        string   prazo_dev       = "";
        string   prazo_pro       = "";
        string   multa           = "";
        string   juros           = "";
        string   comissao        = "";
        string   carteira        = "";
        string   num_inicial     = "";
        string   num_final       = "";
        string   sequencia       = "";
        string   numero_atual    = "";
        string   complemento     = "";

        //
        //
        ID        = e.NewValues["ID"].ToString();
        cod_banco = e.NewValues["cod_banco"].ToString();
        nome      = e.NewValues["nome"].ToString();
        data      = Convert.ToDateTime(e.NewValues["data"].ToString().Substring(0, 10));
        //drive = e.NewValues["drive"].ToString();
        //pasta_remessa = e.NewValues["pasta_remessa"].ToString();
        //pasta_retorno = e.NewValues["pasta_retorno"].ToString();
        //pasta_envelope = e.NewValues["pasta_envelope"].ToString();
        //assunto = e.NewValues["assunto"].ToString();
        //caixa_postal = e.NewValues["caixa_postal"].ToString();
        //mascara_remessa = e.NewValues["mascara_remessa"].ToString();
        //mascara_retorno = e.NewValues["mascara_retorno"].ToString();
        //prazo_fol = e.NewValues["prazo_fol"].ToString();
        //prazo_dev = e.NewValues["prazo_dev"].ToString();
        //prazo_pro = e.NewValues["prazo_pro"].ToString();
        //multa = e.NewValues["multa"].ToString();
        //juros = e.NewValues["juros"].ToString();
        //comissao = e.NewValues["comissao"].ToString();
        //carteira = e.NewValues["carteira"].ToString();
        //num_inicial = e.NewValues["num_inicial"].ToString();
        //num_final = e.NewValues["num_final"].ToString();
        //sequencia = e.NewValues["sequencia"].ToString();
        //numero_atual = e.NewValues["numero_atual"].ToString();
        //complemento = e.NewValues["complemento"].ToString();


        uBanco_2.Grava(cod_banco,
                       nome,
                       data,
                       drive,
                       pasta_remessa,
                       pasta_retorno,
                       pasta_envelope,
                       assunto,
                       caixa_postal,
                       mascara_remessa,
                       mascara_retorno,
                       nome_arquivo,
                       numero_arquivo,
                       prazo_fol,
                       prazo_dev,
                       prazo_pro,
                       multa,
                       juros,
                       comissao,
                       carteira,
                       num_inicial,
                       num_final,
                       sequencia,
                       numero_atual,
                       complemento
                       );


        gridView.CancelEdit();
        e.Cancel = true;

        //Usando Classe uLog.MakeLog - Gravando Log
        fwObs_Log = "INCLUI BANCOS: " + cod_banco + "/" + nome;
        SqlParameter[] param_log = { new SqlParameter("@login",    (String)Session["CodUsuario"]),
                                     new SqlParameter("@tabela",   fWtabela),
                                     new SqlParameter("@operacao", "BANCOS"),
                                     new SqlParameter("@obs",      "INCLUI"),
                                     new SqlParameter("@acao",     fwObs_Log) };
        uLog.MakeLog(param_log);

        //
        AtualizaGrid();
    }
 void InitTotalSummaries(ASPxGridView aspxGridView1)
 {
     if (aspxGridView1.TotalSummary.Count > 0)
     {
         report.Bands.Add(new ReportFooterBand() { HeightF = bandHeight });
         foreach (ASPxSummaryItem item in aspxGridView1.TotalSummary)
         {
             GridViewColumn col = aspxGridView1.Columns[item.ShowInColumn == string.Empty ? item.FieldName : item.ShowInColumn];
             if (col != null)
             {
                 if (detailsInfo.Contains(col))
                 {
                     XRLabel label = new XRLabel();
                     label.LocationF = ((XRTableCell)detailsInfo[col]).LocationF;
                     label.SizeF = ((XRTableCell)detailsInfo[col]).SizeF;
                     label.DataBindings.Add("Text", null, ((GridViewDataColumn)col).FieldName);
                     label.Summary = new XRSummary() { Running = SummaryRunning.Report };
                     label.Summary.FormatString = item.DisplayFormat;
                     label.Summary.Func = GetSummaryFunc(item.SummaryType);
                     report.Bands[BandKind.ReportFooter].Controls.Add(label);
                 }
             }
         }
     }
 }
Exemple #60
0
        protected void CapexGridApproval_BeforeGetCallbackResult(object sender, EventArgs e)
        {
            ASPxGridView grid = sender as ASPxGridView;

            MRPClass.SetBehaviorGrid(grid);
        }