コード例 #1
0
 protected void AspxRowDeleting(object sender, ASPxDataDeletingEventArgs e)
 {
     try
     {
         var receptionDetailTemp = Convert.ToInt32(e.Keys["RECEPTION_DETAIL_TEMP"]);
         _wscalled.DeleteDetail(receptionDetailTemp, Session["connectionString"].ToString());
         e.Cancel = true;
         GridReception.CancelEdit();
         var pResult  = "";
         var dsDetail = _wscalled.GetIncomeDetailForIncomeHeader((int)Session["Header"], Session["connectionString"].ToString(), ref pResult);
         if (pResult == "")
         {
             GridReception.DataSource = dsDetail;
             GridReception.DataBind();
         }
         else
         {
             ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true);
         }
         pcConfirm.ShowOnPageLoad = false;
     }
     catch (Exception ex)
     {
         ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
     }
 }
コード例 #2
0
        protected void gdvCuentas_RowDeleting(object sender, ASPxDataDeletingEventArgs e)
        {
            var obec = ((BEParameters)Session["InitPar"]);

            e.Cancel = true;
            int j    = gdvCuentas.FindVisibleIndexByKeyValue(e.Keys[gdvCuentas.KeyFieldName]);
            var _lnm = (j + 1);

            ((List <BECuentasPago>)Session["rct4"]).RemoveAll(item => item.LineNum == _lnm);
            Set_LineNum();
            ((List <BECuentasPago>)Session["rct4"]).ForEach(i =>
            {
                if (i.ActCurr == "SOL")
                {
                    i.Total = Convert.ToDecimal(i.CurrTotal);
                }
                else if (i.ActCurr == "USD")
                {
                    i.Total = Convert.ToDecimal(i.CurrTotal) * obec.Rate;
                }
                else if (i.ActCurr == "EUR")
                {
                    i.Total = Convert.ToDecimal(i.CurrTotal) * obec.RateEur;
                }
            });

            gdvCuentas.JSProperties["cpSubTotalPlanCuenta"] = ((List <BECuentasPago>)Session["rct4"]).Sum(item => Math.Round(item.Total, 2));

            gdvCuentas.DataSource = ((List <BECuentasPago>)Session["rct4"]);
            gdvCuentas.DataBind();
        }
コード例 #3
0
ファイル: FmStatoCivile.aspx.cs プロジェクト: nicofari/emma
 protected void grdStatoCivile_RowDeleting(object sender, ASPxDataDeletingEventArgs e)
 {
     int id = Convert.ToInt32(e.Keys[0].ToString());
     DALRuntime.deleteStatoCivile(id);
     e.Cancel = true;
     grdDataBind(true, true);
 }
コード例 #4
0
ファイル: FmStruttura.aspx.cs プロジェクト: nicofari/emma
 protected void grdAQuestItem_RowDeleting(object sender, ASPxDataDeletingEventArgs e)
 {
     int id = Convert.ToInt32(e.Keys[0].ToString());
     DALRuntime.TRecQuestItem recQuestItem = new DALRuntime.TRecQuestItem();
     recQuestItem.deleteAQuestItem(id);
     e.Cancel = true;
 }
コード例 #5
0
 protected void grdTitoliDiStudio_RowDeleting(object sender, ASPxDataDeletingEventArgs e)
 {
     int id = Convert.ToInt32(e.Keys[0].ToString());
     DALRuntime.deleteTitolo(id);
     e.Cancel = true;
     grdDataBind(true, true);
 }
コード例 #6
0
        protected void GridSap_RowDeleting(object sender, ASPxDataDeletingEventArgs e)
        {
            try
            {
                var erpDoc = e.Values["ERP_DOC"].ToString();
                //BORRAR DEL DATASET

                var oldDs = (DataSet)Session["SAP_RECEPTION_DATA"];
                oldDs.Tables[0].Delete("ERP_DOC = '" + erpDoc + "'");
                oldDs.Tables[0].AcceptChanges();

                if (oldDs.Tables[0].Rows.Count == 0)
                {
                    Session["SAP_RECEPTION_TYPE"] = null;
                }

                Session["SAP_RECEPTION_DATA"] = oldDs;
                e.Cancel = true;
                GridReception.CancelEdit();

                GridReception.DataSource = Session["SAP_RECEPTION_DATA"];
                GridReception.DataBind();
            }
            catch (Exception ex)
            {
                ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
            }
        }
コード例 #7
0
 protected void ASPxGridView1_RowDeleting(object sender, ASPxDataDeletingEventArgs e)
 {
     ShoppingCartStorage.RemoveFromCart(Convert.ToInt32(e.Keys[0]));
     ASPxGridView1.CancelEdit();
     ASPxGridView1.DataBind();
     e.Cancel = true;
 }
コード例 #8
0
ファイル: DxDbOps.cs プロジェクト: jeffmun/Research2013
        public static string BuildDeleteSqlCode(ASPxDataDeletingEventArgs e, string tbl, string db, string schema)
        {
            var pkval = "";
            var pkfld = "";

            foreach (DictionaryEntry key in e.Keys)
            {
                pkfld = (key.Key == null) ? null : key.Key.ToString();
                pkval = (key.Value == null) ? null : key.Value.ToString();
            }
            string result = "";

            if (pkfld != "" && Convert.ToInt32(pkval) > 0)
            {
                result = BuildDeleteSqlCode(tbl, db, pkfld, Convert.ToInt32(pkval), "", schema);
            }
            else
            {
                result = "Not Implemented.";
            }



            return(result);
        }
コード例 #9
0
        protected override void RaiseRowDeleting(ASPxDataDeletingEventArgs e)
        {
            OnBeforeRowDeleting_BaseImplementation(e);

            base.RaiseRowDeleting(e);

            OnAfterRowDeleting_BaseImplementation(e);
        }
コード例 #10
0
        protected virtual void OnAfterRowDeleting_BaseImplementation(ASPxDataDeletingEventArgs e)
        {
            if (DataSource is ISmartDataSourse)
            {
                DataSource.Dirty();

                e.Cancel = true;
            }
        }
コード例 #11
0
 protected void treeList_NodeDeleting(object sender, ASPxDataDeletingEventArgs e)
 {
     if (ChecklistTemplateItems.CanDelete(decimal.Parse(e.Keys[0].ToString()), 0))
     {
         ChecklistTemplateItems.DeleteChecklistItemHard(decimal.Parse(e.Keys[0].ToString()));
         BindChecklistTree();
     }
     e.Cancel = true;
 }
コード例 #12
0
        protected void grid_RowDeleting(Object sender, ASPxDataDeletingEventArgs e)
        {
            var id       = Int32.Parse(e.Keys["ID"].ToString());
            var data     = FindData(id);
            var filepath = LocalHelper.ResolveFilePath(data.Name);

            Data.Remove(data);
            File.Delete(filepath);
            e.Cancel = true;
        }
コード例 #13
0
ファイル: gvCRUD.cs プロジェクト: jeffmun/Research2013
        public static void gvcrud_OnRowDeleting(ASPxGridView gv, ASPxDataDeletingEventArgs e)
        {
            //ASPxGridView gv = (ASPxGridView)sender;
            string gvname = gv.ClientInstanceName;

            DxDbOps.BuildDeleteSqlCode(e, gvname, "Data");

            gv.JSProperties["cpIsUpdated"] = gv.ClientInstanceName.ToString();
            gv.CancelEdit();
            e.Cancel = true;
        }
コード例 #14
0
    protected void gridLinkedREDCapForm_OnRowDeleting(object sender, ASPxDataDeletingEventArgs e)
    {
        ASPxGridView gv = (ASPxGridView)sender;

        DxDbOps.BuildDeleteSqlCode(e, "REDCap_Form", "data", "def");
        gv.CancelEdit();
        e.Cancel = true;
        Session["LinkedREDCapForm"] = null;

        LoadlinkedTables();
    }
コード例 #15
0
    protected void dxgrid_OnRowDeleting(object sender, ASPxDataDeletingEventArgs e)
    {
        bool         proceed_as_normal = true;
        ASPxGridView gv     = (ASPxGridView)sender;
        string       result = "Error (uninitialized.)";

        #region Conditions for specific grids
        //For people, first check if there are any subjects
        if (gv.ClientInstanceName == "grid_tblgroup")
        {
            var       pk  = e.Keys[0];
            SQL_utils sql = new SQL_utils("backend");
            int       n   = sql.IntScalar_from_SQLstring("select count(*) from tblSubject where groupID=" + pk.ToString());

            if (n > 0)
            {
                string study   = (n == 1) ? " study" : " studies";
                string subject = (n == 1) ? " this subject" : " these subjects";
                string msg     = "This group is assigned to " + n.ToString() + " subjects.  Please delete these first.";
                result            = msg;
                proceed_as_normal = false;
            }
            else
            {
                try
                {
                    sql.NonQuery_from_SQLstring("delete from tblStudyActionGroup where groupID=" + pk.ToString());
                    sql.NonQuery_from_SQLstring("delete from tblStudyMeasGroup where groupID=" + pk.ToString());
                    sql.NonQuery_from_SQLstring("delete from tblLabGroup_Staff where labgroupID in (select labgroupID from tblLabGroup where groupID=" + pk.ToString() + ")");
                    sql.NonQuery_from_SQLstring("delete from tblLabGroup where groupID =" + pk.ToString());
                }
                catch (Exception ex)
                { }
            }
            sql.Close();
        }


        #endregion


        if (proceed_as_normal)
        {
            result = DxDbOps.BuildDeleteSqlCode(e, GridnameToTable(gv.ClientInstanceName), "backend");
        }


        //
        ((ASPxGridView)sender).JSProperties["cpIsUpdated"] = String.Format("DELETED.{0}", result);
        gv.CancelEdit();
        e.Cancel = true;

        RefreshGrids();
    }
    protected void grid_RowDeleting(object sender, ASPxDataDeletingEventArgs e)
    {
        int     id = (int)e.Keys[0];
        DataRow dr = CustomDataSource.Rows.Find(id);

        CustomDataSource.Rows.Remove(dr);

        ASPxGridView grid = sender as ASPxGridView;

        grid.CancelEdit();
        e.Cancel = true;
    }
コード例 #17
0
        protected void gdvArticulos_RowDeleting(object sender, ASPxDataDeletingEventArgs e)
        {
            e.Cancel = true;
            int i    = gdvArticulos.FindVisibleIndexByKeyValue(e.Keys[gdvArticulos.KeyFieldName]);
            var _lnm = (i + 1);

            ((List <BEDocumentLine>)Session["wtr1"]).RemoveAll(item => item.LineNum == _lnm);
            Set_LineNum();

            gdvArticulos.DataSource = ((List <BEDocumentLine>)Session["wtr1"]);
            gdvArticulos.DataBind();
        }
    protected void grid_RowDeleting(object sender, ASPxDataDeletingEventArgs e)
    {
        int     id = (int)e.Keys[0];
        DataRow dr = CustomDataSourse.Rows.Find(id);

        dataTable.Rows.Remove(dr);

        ASPxGridView g = sender as ASPxGridView;

        UpdateData(g);
        e.Cancel = true;
    }
コード例 #19
0
        protected void gdvHijos_RowDeleting(object sender, ASPxDataDeletingEventArgs e)
        {
            e.Cancel = true;
            int i    = gdvHijos.FindVisibleIndexByKeyValue(e.Keys[gdvHijos.KeyFieldName]);
            var _lnm = (i + 1);

            {
                ((List <BEProduct>)Session["itt1"]).RemoveAll(item => item.ChildNum == _lnm);
            }
            Set_LineNum();
            gdvHijos.DataSource = ((List <BEProduct>)Session["itt1"]);
            gdvHijos.DataBind();
        }
コード例 #20
0
        protected void trlDepartamentos_NodeDeleting(object sender, ASPxDataDeletingEventArgs e)
        {
            string    strParentKey = trlDepartamentos.FocusedNode.Key;
            DataTable dtbTrl       = (DataTable)Session[Constantes.SesionTablaDepartamentos];
            DataRow   dtrRow       = dtbTrl.Rows.Find(new object[] { e.Keys[0] });

            dtrRow.Delete();
            new ClsDepartamento().AdministrarDepartamento((DataTable)Session[Constantes.SesionTablaCentroCostos], (int)EnumAccionTabla.Delete);
            Session[Constantes.SesionTablaDepartamentos] = dtbTrl;
            trlDepartamentos.DataBind();
            e.Cancel = true;
            trlDepartamentos.CancelEdit();
        }
    public static void DeleteNode(ASPxTreeList treeList, ASPxDataDeletingEventArgs e)
    {
        AddHiddenNodeValues(e.Values, e.Keys[0], treeList);

        XmlDataSource xmlDataXource = treeList.Page.FindControl(treeList.DataSourceID) as XmlDataSource;
        XmlDocument   docum         = xmlDataXource.GetXmlDocument();

        XmlNode node = FindNode(docum, e.Values["Id"]);

        node.ParentNode.RemoveChild(node);

        RearrangeAndSaveXml(docum);
    }
コード例 #22
0
        protected void gdvrin1_RowDeleting(object sender, ASPxDataDeletingEventArgs e)
        {
            e.Cancel = true;
            int i    = gdvrin1.FindVisibleIndexByKeyValue(e.Keys[gdvrin1.KeyFieldName]);
            var _lnm = (i + 1);

            ((List <BEDocumentLine>)Session["rin1"]).RemoveAll(item => item.LineNum == _lnm);
            Set_LineNum();

            gdvrin1.JSProperties["cpSubTotal"] = ((List <BEDocumentLine>)Session["rin1"]).Sum(item => Math.Round(item.LineTotal, 2));

            gdvrin1.DataSource = ((List <BEDocumentLine>)Session["rin1"]);
            gdvrin1.DataBind();
        }
コード例 #23
0
        protected void gvcontacto_RowDeleting(object sender, ASPxDataDeletingEventArgs e)
        {
            e.Cancel = true;
            int i    = gvcontacto.FindVisibleIndexByKeyValue(e.Keys[gvcontacto.KeyFieldName]);
            var _lnm = (i + 1);

            ((List <BEContactLines>)Session["crd1"]).RemoveAll(item => item.CntctCode == _lnm);
            Set_LineNum();

            //gvcontacto.JSProperties["cpSubTotal"] = ((List<BEContactLines>)Session["inv1"]).Sum(item => Math.Round(item.LineTotal, 2));

            gvcontacto.DataSource = ((List <BEContactLines>)Session["crd1"]);
            gvcontacto.DataBind();
        }
コード例 #24
0
    protected void gvcrud_OnRowDeleting(object sender, ASPxDataDeletingEventArgs e)
    {
        string key = e.Keys[0].ToString();

        // Delete the staffevents and staffproperties first
        SQL_utils sql = new SQL_utils("backend");

        string sqlcode = String.Format("update stf.staff set is_deleted = 1, updated=getdate(), updatedby=sec.systemuser() where staffpk = {0}", key);

        sql.NonQuery_from_SQLstring(sqlcode);

        gv_staff.JSProperties["cpIsUpdated"] = gv_staff.ClientInstanceName.ToString();
        gv_staff.CancelEdit();
        e.Cancel = true;
    }
コード例 #25
0
        public void Effect_Deleting(object sender, ASPxDataDeletingEventArgs e)
        {
            SqlCommand   cmd;
            ASPxGridView EffectGrid = (ASPxGridView)sender;
            string       obid       = e.Keys[EffectGrid.KeyFieldName].ToString();
            string       qry        = " UPDATE TBLSYSTEM_TEMPLATE SET N1TERMINATIONDATE = REPLACE(REPLACE(CONVERT(varchar(23), GETDATE(), 121), '-','/'),'  ', '-'),  ";

            qry = qry + "N1TERMINATIONID = '" + SessionInfo.UserID + "'  ";
            qry = qry + "WHERE OBID = '" + obid + "' ";
            cmd = new SqlCommand(qry, fgm_moduler.func_Class.conn);
            cmd.ExecuteNonQuery();

            e.Cancel = true;
            EffectGrid.CancelEdit();
        }
コード例 #26
0
    protected void gridDict_OnRowDeleting(object sender, ASPxDataDeletingEventArgs e)
    {
        ASPxGridView gv = (ASPxGridView)sender;

        SQL_utils sql   = new SQL_utils("data");
        int       tblpk = sql.IntScalar_from_SQLstring("select tblpk from def.tbl where measureID=" + Request.QueryString["mID"]);



        DxDbOps.BuildDeleteSqlCode(e, "fld", "data", "def");
        //((ASPxGridView)sender).JSProperties["cpIsUpdated"] = gv.ClientInstanceName.ToString();
        gv.CancelEdit();
        e.Cancel = true;

        gridDict.DataBind();
    }
コード例 #27
0
        protected void PriceGrid_OnRowDeleting(object Sender, ASPxDataDeletingEventArgs E)
        {
            var xml = string.Format(@"<data>
                                           <work_week_id>{0}</work_week_id>
                                           <theater_id>{1}</theater_id>
                                           <seat_type_id>{2}</seat_type_id>
                                           <from_time>{3}</from_time>
                                       </data>",
                                    _workWeekID,
                                    _theaterID,
                                    _seatTypeID,
                                    E.Values["StartTime"]);

            E.Keys.Remove("StartTime");
            PriceDataSource.DeleteParameters["Xml"].DefaultValue = xml;
        }
コード例 #28
0
        protected void gvDirecciones_RowDeleting(object sender, ASPxDataDeletingEventArgs e)
        {
            e.Cancel = true;
            int i    = gvDirecciones.FindVisibleIndexByKeyValue(e.Keys[gvDirecciones.KeyFieldName]);
            var _lnm = (i + 1);

            ((List <BEClientAddress>)Session["dire"]).Where(item => item.LineNum == i).ToList().ForEach(x =>
            {
                x.Borrar = "Y";
            });
            Set_LineNum_Direcciones();

            //gvcontacto.JSProperties["cpSubTotal"] = ((List<BEContactLines>)Session["inv1"]).Sum(item => Math.Round(item.LineTotal, 2));

            gvDirecciones.DataSource = ((List <BEClientAddress>)Session["dire"]).Where(z => z.Borrar != "Y");
            gvDirecciones.DataBind();
        }
コード例 #29
0
        public void Effect_Deleting(object sender, ASPxDataDeletingEventArgs e)
        {
            SqlCommand cmd;

            ASPxGridView detailGridView = (ASPxGridView)sender;
            string       Selected_OBID  = e.Keys[detailGridView.KeyFieldName].ToString(); //detailGridView.GetRowValues(detailGridView.FocusedRowIndex, "OBID").ToString();

            string qry = " UPDATE TB_DE_LINK SET N1TERMINATIONDATE = REPLACE(REPLACE(CONVERT(varchar(23), GETDATE(), 121), '-','/'),'  ', '-'),  ";

            qry = qry + "N1TERMINATIONSESID = '" + SessionInfo.UserName + "'  ";
            qry = qry + "WHERE OBID = '" + Selected_OBID + "' ";
            cmd = new SqlCommand(qry, fgm_moduler.func_Class.conn);
            cmd.ExecuteNonQuery();

            e.Cancel = true;
            Detector_Grid.CancelEdit();
        }
コード例 #30
0
        protected void grdvPendientes_RowDeleting(object sender, ASPxDataDeletingEventArgs e)
        {
            e.Cancel = true;
            int       i            = grdvPendientes.FindVisibleIndexByKeyValue(e.Keys[grdvPendientes.KeyFieldName]);
            Hashtable copiedValues = null;

            string[] copiedFields = new string[] { "U_DXP_COD_ABONADO", "U_DXP_ABONADO", "U_DXP_DIREC_ABO", "U_DXP_DIRECCION", "U_DXP_PLAN_INT",
                                                   "U_DXP_FECHA_REG1", "U_DXP_FEC_CORT_INT1", "U_DXP_FEC_CORT_CABLE1", "U_DXP_MAC_EQUIPO", "U_DXP_ESTADO_INT", "U_DXP_ESTADO_CABLE" };
            copiedValues = new Hashtable();
            foreach (string fieldName in copiedFields)
            {
                copiedValues[fieldName] = grdvPendientes.GetRowValues(i, fieldName);
            }
            ((List <BEAbonado>)Session["DXP_ISP_REGISTRO"]).RemoveAll(item => item.U_DXP_COD_ABONADO == Convert.ToString(copiedValues["U_DXP_COD_ABONADO"]));

            grdvPendientes.DataSource = ((List <BEAbonado>)Session["DXP_ISP_REGISTRO"]);
            grdvPendientes.DataBind();
        }
コード例 #31
0
        protected void gdvAsiento_RowDeleting(object sender, ASPxDataDeletingEventArgs e)
        {
            e.Cancel = true;
            int i      = gdvAsiento.FindVisibleIndexByKeyValue(e.Keys[gdvAsiento.KeyFieldName]);
            var _lnm   = (i + 1);
            var father = "";

            ((List <BEDocumentLine>)Session["asientoPrinc"]).Where(item => item.LineNum == _lnm).ToList().ForEach(x => {
                father = x.Father;
            });
            ((List <BEDocumentLine>)Session["asientoPrinc"]).RemoveAll(item => item.Father == father);
            Set_LineNum();

            //gdvAsiento.JSProperties["cpSubTotal"] = ((List<BEDocumentLine>)Session["inv1"]).Sum(item => Math.Round(item.LineTotal, 2));

            gdvAsiento.DataSource = ((List <BEDocumentLine>)Session["asientoPrinc"]);
            gdvAsiento.DataBind();
        }
コード例 #32
0
        protected void grdvOnusRegistro_RowDeleting(object sender, ASPxDataDeletingEventArgs e)
        {
            e.Cancel = true;
            int       i            = grdvOnusRegistro.FindVisibleIndexByKeyValue(e.Keys[grdvOnusRegistro.KeyFieldName]);
            Hashtable copiedValues = null;

            string[] copiedFields = new string[] { "U_DXP_ABO_MIKROT", "U_DXP_ONU_CODABO", "U_DXP_ONU_TARJETA", "U_DXP_ONU_PUERTO",
                                                   "U_DXP_ONU_ABONADO", "U_DXP_COD_ONU", "U_DXP_ONU_TYPE", "U_U_DXP_ONU_SERIAL", "U_DXP_ONU_ESTADO" };
            copiedValues = new Hashtable();
            foreach (string fieldName in copiedFields)
            {
                copiedValues[fieldName] = grdvOnusRegistro.GetRowValues(i, fieldName);
            }
            ((List <BEOnu>)Session["DXP_REGISTRO_ONU"]).RemoveAll(item => item.U_DXP_ABO_MIKROT == Convert.ToString(copiedValues["U_DXP_ABO_MIKROT"]));

            grdvOnusRegistro.DataSource = ((List <BEOnu>)Session["DXP_REGISTRO_ONU"]);
            grdvOnusRegistro.DataBind();
        }
コード例 #33
0
        protected void tree_NodeDeleting(object sender, ASPxDataDeletingEventArgs e)
        {
            string       key  = e.Keys[0].ToString();
            TreeListNode node = tree.FindNodeByKeyValue(key);

            EnsureNode(node);
            string name = node.GetValue(FileManagerHelper.FullPathName).ToString();

            if (Directory.Exists(name))
            {
                Directory.Delete(name);
            }
            else if (File.Exists(name))
            {
                File.Delete(name);
            }
            tree.RefreshVirtualTree(node.ParentNode);
        }
コード例 #34
0
        /// <summary>
        /// 
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void OnRowDeleting(object sender, ASPxDataDeletingEventArgs e)
        {
            int id = Convert.ToInt32(e.Keys[0]);
            string ModifiedBy = "testuserdel";
            objclsDemographicBAL = new clsDemographicBAL();
            DataSet objDS = new DataSet();

            objclsDemographicBAL.DeteteDemographicDetails_BAL(id, ModifiedBy, ref objDS);

            objclsDemographicBAL = new clsDemographicBAL();
            objclsDemographicBAL.getDemographicDetails_BAL(ref objDS);
            if (objDS.Tables.Count > 0)
            {
                gvDemographicData.DataSource = objDS.Tables[0];
                gvDemographicData.DataBind();
            }
            ApplyLayout(0);
            e.Cancel = true;
        }
コード例 #35
0
ファイル: FDMVoting.aspx.cs プロジェクト: KijongNam/EDIS
        public void Effect_Deleting(object sender, ASPxDataDeletingEventArgs e)
        {
            SqlCommand cmd;
           
            ASPxGridView detailGridView = (ASPxGridView)sender;
            string Selected_OBID = e.Keys[detailGridView.KeyFieldName].ToString(); //detailGridView.GetRowValues(detailGridView.FocusedRowIndex, "OBID").ToString();
            
            string qry = " UPDATE TB_DE_LINK SET N1TERMINATIONDATE = REPLACE(REPLACE(CONVERT(varchar(23), GETDATE(), 121), '-','/'),'  ', '-'),  ";
            qry = qry + "N1TERMINATIONSESID = '" + SessionInfo.UserName + "'  ";
            qry = qry + "WHERE OBID = '" + Selected_OBID + "' ";
            cmd = new SqlCommand(qry, fgm_moduler.func_Class.conn);
            cmd.ExecuteNonQuery();

            e.Cancel = true;
            Detector_Grid.CancelEdit();
        }
コード例 #36
0
        protected void gridFondMove_OnRowDeleting(object sender, ASPxDataDeletingEventArgs e)
        {
            int idFondMoveDetails = Convert.ToInt32(e.Keys["IdFondMoveDetail"]);
            var fondMoveEditorAction = new FondMoveEditorActions();

            string result = fondMoveEditorAction.FondMoveEditorDelete(idFondMoveDetails);
            gridFondMove.JSProperties["cpFondMoveEditorResultInfo"] = result;

            e.Cancel = true;
            gridFondMove.CancelEdit();
        }
コード例 #37
0
ファイル: FGMMain.aspx.cs プロジェクト: KijongNam/EDIS
        protected void gv1temp_RowDeleting(object sender, ASPxDataDeletingEventArgs e)
        {
            SqlCommand del_cmd = new SqlCommand();
            del_cmd.Connection = fgm_moduler.func_Class.conn;

            //SqlDataAdapter data_adapter;

            ASPxGridView gv = sender as ASPxGridView;
            string Selected_N3OBJATTR_OBID = e.Keys[gv1temp.KeyFieldName].ToString();
            string delet_Tag = e.Values["TagNo"].ToString();
            //string selected_tag = e.Values[""]
            //string loc2 = gv.GetRowValues(GridGroupDetector.FocusedRowIndex, "LOC2").ToString();
            string loc2 = e.Values["LOC2"].ToString();

            string qry = " UPDATE N3OBJATTR SET N1TERMINATIONDATE = REPLACE(REPLACE(CONVERT(varchar(23), GETDATE(), 121), '-','/'),'  ', '-'),";
            qry = qry + "N1TERMINATIONSESID = '" + SessionInfo.UserID + "' ";
            qry = qry + "WHERE OBID = '" + Selected_N3OBJATTR_OBID + "' AND N1TERMINATIONDATE =''";

            //data_adapter = new SqlDataAdapter(qry, fgm_moduler.func_Class.connString);
            del_cmd.CommandText = qry;
            del_cmd.ExecuteNonQuery();

            if (loc2 == "CLEAN AGENT" || loc2 == "DELUGE" || loc2 == "ESD" || loc2 == "FOAM")
            {
                string qry2 = " UPDATE TBLSYSTEM_INTERFACE SET N1TERMINATIONDATE = REPLACE(REPLACE(CONVERT(varchar(23), GETDATE(), 121), '-','/'),'  ', '-'),";
                qry2 = qry2 + "N1TERMINATIONID = '" + SessionInfo.UserID + "' ";
                qry2 = qry2 + "WHERE EFFECT_TAG = '" + delet_Tag + "' ";
                del_cmd.CommandText = qry2;
                del_cmd.ExecuteNonQuery();
            }

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

            gv1temp.JSProperties["cpNewWindowUrl"] = null;
        }
コード例 #38
0
 protected void grid_RowDeleting(object sender, ASPxDataDeletingEventArgs e)
 {
 }
コード例 #39
0
ファイル: FmStruttura.aspx.cs プロジェクト: nicofari/emma
 protected void grdAQuestSezioni_RowDeleting(object sender, ASPxDataDeletingEventArgs e)
 {
     int id = Convert.ToInt32(e.Keys[0].ToString());
     DALRuntime.deleteAQuestSezione(id);
     e.Cancel = true;
     //    grdDataBind(true, true);
 }
コード例 #40
0
ファイル: FDMVoting.aspx.cs プロジェクト: KijongNam/EDIS
        public void DetectorVoting_Deleting(object sender, ASPxDataDeletingEventArgs e)
        {
            SqlCommand cmd;
            ASPxGridView detailGridView = (ASPxGridView)sender;



            string Selected_OBID = e.Keys[Detector_Grid.KeyFieldName].ToString();
            
            string qry = " UPDATE TBLDETECTOR_VOTING SET N1TERMINATIONDATE = REPLACE(REPLACE(CONVERT(varchar(23), GETDATE(), 121), '-','/'),'  ', '-'),  ";
            qry = qry + "N1TERMINATIONSESID = '" + SessionInfo.UserID + "'  ";
            qry = qry + "WHERE OBID = '" + Selected_OBID + "' ";
            cmd = new SqlCommand(qry, fgm_moduler.func_Class.conn);
            cmd.ExecuteNonQuery();

            e.Cancel = true;
            Detector_Grid.CancelEdit();
            detailGridView.CancelEdit();
            //Detector_Grid.CancelEdit();
        }
コード例 #41
0
        public void Effect_Deleting(object sender, ASPxDataDeletingEventArgs e)
        {
            SqlCommand cmd;
            ASPxGridView EffectGrid = (ASPxGridView)sender;
            string obid = e.Keys[EffectGrid.KeyFieldName].ToString();
            string qry = " UPDATE TBLSYSTEM_TEMPLATE SET N1TERMINATIONDATE = REPLACE(REPLACE(CONVERT(varchar(23), GETDATE(), 121), '-','/'),'  ', '-'),  ";
            qry = qry + "N1TERMINATIONID = '" + SessionInfo.UserID + "'  ";
            qry = qry + "WHERE OBID = '" + obid + "' ";
            cmd = new SqlCommand(qry, fgm_moduler.func_Class.conn);
            cmd.ExecuteNonQuery();

            e.Cancel = true;
            EffectGrid.CancelEdit();
        }
コード例 #42
0
 protected virtual void OnBeforeRowDeleting_BaseImplementation(ASPxDataDeletingEventArgs e)
 {
 }
コード例 #43
0
        protected virtual void OnAfterRowDeleting_BaseImplementation(ASPxDataDeletingEventArgs e)
        {
            if (DataSource is ISmartDataSourse)
            {
                DataSource.Dirty();

                e.Cancel = true;
            }
        }
コード例 #44
0
        protected override void RaiseRowDeleting(ASPxDataDeletingEventArgs e)
        {
            OnBeforeRowDeleting_BaseImplementation(e);

            base.RaiseRowDeleting(e);

            OnAfterRowDeleting_BaseImplementation(e);
        }