コード例 #1
0
ファイル: Menu.cs プロジェクト: zmyz2013/RoadFlowMvc
        private List <RoadFlow.Data.Model.Menu> DataReaderToList(SqlDataReader dataReader)
        {
            List <RoadFlow.Data.Model.Menu> list = new List <RoadFlow.Data.Model.Menu>();

            RoadFlow.Data.Model.Menu menu = null;
            while (dataReader.Read())
            {
                menu          = new RoadFlow.Data.Model.Menu();
                menu.ID       = dataReader.GetGuid(0);
                menu.ParentID = dataReader.GetGuid(1);
                if (!dataReader.IsDBNull(2))
                {
                    menu.AppLibraryID = dataReader.GetGuid(2);
                }
                menu.Title = dataReader.GetString(3);
                if (!dataReader.IsDBNull(4))
                {
                    menu.Params = dataReader.GetString(4);
                }
                if (!dataReader.IsDBNull(5))
                {
                    menu.Ico = dataReader.GetString(5);
                }
                menu.Sort = dataReader.GetInt32(6);
                if (!dataReader.IsDBNull(7))
                {
                    menu.IcoColor = dataReader.GetString(7);
                }
                list.Add(menu);
            }
            return(list);
        }
コード例 #2
0
        public ActionResult Sort(FormCollection collection)
        {
            RoadFlow.Platform.Menu          menu = new RoadFlow.Platform.Menu();
            List <RoadFlow.Data.Model.Menu> list = new List <RoadFlow.Data.Model.Menu>();
            string str = base.Request.QueryString["id"];

            RoadFlow.Data.Model.Menu menu2 = menu.Get(str.ToGuid());
            list = menu.GetChild(menu2.ParentID);
            if (collection != null)
            {
                string text = base.Request.Form["sortapp"];
                if (text.IsNullOrEmpty())
                {
                    return(View(list));
                }
                string[] array = text.Split(',');
                for (int i = 0; i < array.Length; i++)
                {
                    Guid test;
                    if (array[i].IsGuid(out test))
                    {
                        menu.UpdateSort(test, i + 1);
                    }
                }
                string str2 = menu2.ParentID.ToString();
                base.ViewBag.Script = "parent.frames[0].reLoad('" + str2 + "');";
                list = menu.GetChild(menu2.ParentID);
                menu.ClearAllDataTableCache();
            }
            return(View(list));
        }
コード例 #3
0
        private List <RoadFlow.Data.Model.Menu> DataReaderToList(MySqlDataReader dataReader)
        {
            List <RoadFlow.Data.Model.Menu> list = new List <RoadFlow.Data.Model.Menu>();

            RoadFlow.Data.Model.Menu menu = null;
            while (((DbDataReader)dataReader).Read())
            {
                menu          = new RoadFlow.Data.Model.Menu();
                menu.ID       = ((DbDataReader)dataReader).GetString(0).ToGuid();
                menu.ParentID = ((DbDataReader)dataReader).GetString(1).ToGuid();
                if (!((DbDataReader)dataReader).IsDBNull(2))
                {
                    menu.AppLibraryID = ((DbDataReader)dataReader).GetString(2).ToGuid();
                }
                menu.Title = ((DbDataReader)dataReader).GetString(3);
                if (!((DbDataReader)dataReader).IsDBNull(4))
                {
                    menu.Params = ((DbDataReader)dataReader).GetString(4);
                }
                if (!((DbDataReader)dataReader).IsDBNull(5))
                {
                    menu.Ico = ((DbDataReader)dataReader).GetString(5);
                }
                menu.Sort = ((DbDataReader)dataReader).GetInt32(6);
                if (!((DbDataReader)dataReader).IsDBNull(7))
                {
                    menu.IcoColor = ((DbDataReader)dataReader).GetString(7);
                }
                list.Add(menu);
            }
            return(list);
        }
コード例 #4
0
 /// <summary>
 /// 更新菜单
 /// </summary>
 /// <param name="menu">菜单实体</param>
 public int Update(Model.Menu menu)
 {
     ClearCache();
     using (var db = new DataContext())
     {
         db.Update(menu);
         return(db.SaveChanges());
     }
 }
コード例 #5
0
ファイル: Menu.cs プロジェクト: zmyz2013/RoadFlowMvc
        public int Update(RoadFlow.Data.Model.Menu model)
        {
            string sql = "UPDATE Menu SET \r\n\t\t\t\tParentID=@ParentID,AppLibraryID=@AppLibraryID,Title=@Title,Params=@Params,Ico=@Ico,Sort=@Sort,IcoColor=@IcoColor \r\n\t\t\t\tWHERE ID=@ID";

            SqlParameter[] parameter = new SqlParameter[8]
            {
                new SqlParameter("@ParentID", SqlDbType.UniqueIdentifier, -1)
                {
                    Value = model.ParentID
                },
                (!model.AppLibraryID.HasValue) ? new SqlParameter("@AppLibraryID", SqlDbType.UniqueIdentifier, -1)
                {
                    Value = DBNull.Value
                } : new SqlParameter("@AppLibraryID", SqlDbType.UniqueIdentifier, -1)
                {
                    Value = model.AppLibraryID
                },
                new SqlParameter("@Title", SqlDbType.NVarChar, 1000)
                {
                    Value = model.Title
                },
                (model.Params == null) ? new SqlParameter("@Params", SqlDbType.VarChar, 5000)
                {
                    Value = DBNull.Value
                } : new SqlParameter("@Params", SqlDbType.VarChar, 5000)
                {
                    Value = model.Params
                },
                (model.Ico == null) ? new SqlParameter("@Ico", SqlDbType.VarChar, 500)
                {
                    Value = DBNull.Value
                } : new SqlParameter("@Ico", SqlDbType.VarChar, 500)
                {
                    Value = model.Ico
                },
                new SqlParameter("@Sort", SqlDbType.Int, -1)
                {
                    Value = model.Sort
                },
                (model.IcoColor == null) ? new SqlParameter("@IcoColor", SqlDbType.VarChar, 50)
                {
                    Value = DBNull.Value
                } : new SqlParameter("@IcoColor", SqlDbType.VarChar, 50)
                {
                    Value = model.IcoColor
                },
                new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1)
                {
                    Value = model.ID
                }
            };
            return(dbHelper.Execute(sql, parameter));
        }
コード例 #6
0
ファイル: Menu.cs プロジェクト: zmyz2013/RoadFlowMvc
        public int Add(RoadFlow.Data.Model.Menu model)
        {
            string sql = "INSERT INTO Menu\r\n\t\t\t\t(ID,ParentID,AppLibraryID,Title,Params,Ico,Sort,IcoColor) \r\n\t\t\t\tVALUES(@ID,@ParentID,@AppLibraryID,@Title,@Params,@Ico,@Sort,@IcoColor)";

            SqlParameter[] parameter = new SqlParameter[8]
            {
                new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1)
                {
                    Value = model.ID
                },
                new SqlParameter("@ParentID", SqlDbType.UniqueIdentifier, -1)
                {
                    Value = model.ParentID
                },
                (!model.AppLibraryID.HasValue) ? new SqlParameter("@AppLibraryID", SqlDbType.UniqueIdentifier, -1)
                {
                    Value = DBNull.Value
                } : new SqlParameter("@AppLibraryID", SqlDbType.UniqueIdentifier, -1)
                {
                    Value = model.AppLibraryID
                },
                new SqlParameter("@Title", SqlDbType.NVarChar, 1000)
                {
                    Value = model.Title
                },
                (model.Params == null) ? new SqlParameter("@Params", SqlDbType.VarChar, 5000)
                {
                    Value = DBNull.Value
                } : new SqlParameter("@Params", SqlDbType.VarChar, 5000)
                {
                    Value = model.Params
                },
                (model.Ico == null) ? new SqlParameter("@Ico", SqlDbType.VarChar, 500)
                {
                    Value = DBNull.Value
                } : new SqlParameter("@Ico", SqlDbType.VarChar, 500)
                {
                    Value = model.Ico
                },
                new SqlParameter("@Sort", SqlDbType.Int, -1)
                {
                    Value = model.Sort
                },
                (model.IcoColor == null) ? new SqlParameter("@IcoColor", SqlDbType.VarChar, 50)
                {
                    Value = DBNull.Value
                } : new SqlParameter("@IcoColor", SqlDbType.VarChar, 50)
                {
                    Value = model.IcoColor
                }
            };
            return(dbHelper.Execute(sql, parameter));
        }
コード例 #7
0
        public ActionResult AddApp(FormCollection collection)
        {
            RoadFlow.Platform.AppLibrary appLibrary = new RoadFlow.Platform.AppLibrary();
            RoadFlow.Platform.Menu       menu       = new RoadFlow.Platform.Menu();
            string text = base.Request.QueryString["id"];

            if (collection != null)
            {
                menu.Get(text.ToGuid());
                if (!base.Request.Form["Save"].IsNullOrEmpty())
                {
                    string text2 = base.Request.Form["Name"];
                    string text6 = base.Request.Form["Type"];
                    string str   = base.Request.Form["AppID"];
                    string text3 = base.Request.Form["Params"];
                    string text4 = base.Request.Form["Ico"];
                    string text5 = base.Request.Form["IcoColor"];
                    RoadFlow.Data.Model.Menu menu2 = new RoadFlow.Data.Model.Menu();
                    menu2.ID       = Guid.NewGuid();
                    menu2.ParentID = text.ToGuid();
                    menu2.Title    = text2.Trim();
                    menu2.Sort     = menu.GetMaxSort(menu2.ParentID);
                    if (str.IsGuid())
                    {
                        menu2.AppLibraryID = str.ToGuid();
                    }
                    else
                    {
                        menu2.AppLibraryID = null;
                    }
                    menu2.Params = (text3.IsNullOrEmpty() ? null : text3.Trim());
                    if (!text4.IsNullOrEmpty())
                    {
                        menu2.Ico = text4;
                    }
                    if (!text5.IsNullOrEmpty())
                    {
                        menu2.IcoColor = text5;
                    }
                    menu.Add(menu2);
                    RoadFlow.Platform.Log.Add("添加了菜单", menu2.Serialize(), RoadFlow.Platform.Log.Types.菜单权限);
                    string str2 = text;
                    base.ViewBag.Script = "alert('添加成功');parent.frames[0].reLoad('" + str2 + "');";
                    menu.ClearAllDataTableCache();
                }
            }
            base.ViewBag.AppTypesOptions = appLibrary.GetTypeOptions();
            return(View());
        }
コード例 #8
0
        public ActionResult Body(FormCollection collection)
        {
            RoadFlow.Platform.AppLibrary appLibrary = new RoadFlow.Platform.AppLibrary();
            RoadFlow.Platform.Menu       menu       = new RoadFlow.Platform.Menu();
            RoadFlow.Data.Model.Menu     menu2      = null;
            string str    = base.Request.QueryString["id"];
            string empty  = string.Empty;
            string value  = string.Empty;
            string empty2 = string.Empty;
            string empty3 = string.Empty;
            string empty4 = string.Empty;
            string empty5 = string.Empty;
            Guid   test;

            if (str.IsGuid(out test))
            {
                menu2 = menu.Get(test);
            }
            if (!base.Request.Form["Save"].IsNullOrEmpty())
            {
                empty  = base.Request.Form["Name"];
                value  = base.Request.Form["Type"];
                empty2 = base.Request.Form["AppID"];
                empty3 = base.Request.Form["Params"];
                empty4 = base.Request.Form["Ico"];
                empty5 = base.Request.Form["IcoColor"];
                string oldXML = menu2.Serialize();
                menu2.Title = empty.Trim();
                if (empty2.IsGuid())
                {
                    menu2.AppLibraryID = empty2.ToGuid();
                }
                else
                {
                    menu2.AppLibraryID = null;
                }
                menu2.Params = (empty3.IsNullOrEmpty() ? null : empty3.Trim());
                if (!empty4.IsNullOrEmpty())
                {
                    menu2.Ico = empty4;
                }
                else
                {
                    menu2.Ico = null;
                }
                if (!empty5.IsNullOrEmpty())
                {
                    menu2.IcoColor = empty5;
                }
                else
                {
                    menu2.IcoColor = null;
                }
                menu.Update(menu2);
                RoadFlow.Platform.Log.Add("修改了菜单", "", RoadFlow.Platform.Log.Types.菜单权限, oldXML, menu2.Serialize());
                string str2 = (menu2.ParentID == Guid.Empty) ? menu2.ID.ToString() : menu2.ParentID.ToString();
                base.ViewBag.Script = "parent.frames[0].reLoad('" + str2 + "');alert('保存成功!');";
                menu.ClearAllDataTableCache();
            }
            if (!base.Request.Form["Delete"].IsNullOrEmpty())
            {
                RoadFlow.Platform.Log.Add("删除了菜单及其所有下级共" + menu.DeleteAndAllChilds(menu2.ID).ToString() + "项", menu2.Serialize(), RoadFlow.Platform.Log.Types.菜单权限);
                string text = (menu2.ParentID == Guid.Empty) ? menu2.ID.ToString() : menu2.ParentID.ToString();
                base.ViewBag.Script = "parent.frames[0].reLoad('" + text + "');window.location='Body?id=" + text + "&appid=" + base.Request.QueryString["appid"] + "&tabid=" + base.Request.QueryString["tabid"] + "';";
                menu.ClearAllDataTableCache();
            }
            if (menu2 != null && menu2.AppLibraryID.HasValue)
            {
                RoadFlow.Data.Model.AppLibrary appLibrary2 = new RoadFlow.Platform.AppLibrary().Get(menu2.AppLibraryID.Value);
                if (appLibrary2 != null)
                {
                    value = appLibrary2.Type.ToString();
                }
            }
            base.ViewBag.AppTypesOptions = appLibrary.GetTypeOptions(value);
            base.ViewBag.AppID           = menu2.AppLibraryID.ToString();
            return(View(menu2));
        }
コード例 #9
0
ファイル: Menu.cs プロジェクト: zmyz2013/RoadFlowMvc
 public int Update(RoadFlow.Data.Model.Menu model)
 {
     ClearAllDataTableCache();
     return(dataMenu.Update(model));
 }
コード例 #10
0
        public int Add(RoadFlow.Data.Model.Menu model)
        {
            //IL_001a: Unknown result type (might be due to invalid IL or missing references)
            //IL_001f: Unknown result type (might be due to invalid IL or missing references)
            //IL_0030: Expected O, but got Unknown
            //IL_0031: Expected O, but got Unknown
            //IL_003f: Unknown result type (might be due to invalid IL or missing references)
            //IL_0044: Unknown result type (might be due to invalid IL or missing references)
            //IL_0055: Expected O, but got Unknown
            //IL_0056: Expected O, but got Unknown
            //IL_0074: Unknown result type (might be due to invalid IL or missing references)
            //IL_0079: Unknown result type (might be due to invalid IL or missing references)
            //IL_008a: Expected O, but got Unknown
            //IL_0098: Unknown result type (might be due to invalid IL or missing references)
            //IL_009d: Unknown result type (might be due to invalid IL or missing references)
            //IL_00a8: Expected O, but got Unknown
            //IL_00a9: Expected O, but got Unknown
            //IL_00b6: Unknown result type (might be due to invalid IL or missing references)
            //IL_00bb: Unknown result type (might be due to invalid IL or missing references)
            //IL_00c7: Expected O, but got Unknown
            //IL_00c8: Expected O, but got Unknown
            //IL_00dd: Unknown result type (might be due to invalid IL or missing references)
            //IL_00e2: Unknown result type (might be due to invalid IL or missing references)
            //IL_00ee: Expected O, but got Unknown
            //IL_00fb: Unknown result type (might be due to invalid IL or missing references)
            //IL_0100: Unknown result type (might be due to invalid IL or missing references)
            //IL_010b: Expected O, but got Unknown
            //IL_010c: Expected O, but got Unknown
            //IL_0121: Unknown result type (might be due to invalid IL or missing references)
            //IL_0126: Unknown result type (might be due to invalid IL or missing references)
            //IL_0132: Expected O, but got Unknown
            //IL_013f: Unknown result type (might be due to invalid IL or missing references)
            //IL_0144: Unknown result type (might be due to invalid IL or missing references)
            //IL_014f: Expected O, but got Unknown
            //IL_0150: Expected O, but got Unknown
            //IL_015a: Unknown result type (might be due to invalid IL or missing references)
            //IL_015f: Unknown result type (might be due to invalid IL or missing references)
            //IL_0170: Expected O, but got Unknown
            //IL_0171: Expected O, but got Unknown
            //IL_0187: Unknown result type (might be due to invalid IL or missing references)
            //IL_018c: Unknown result type (might be due to invalid IL or missing references)
            //IL_0198: Expected O, but got Unknown
            //IL_01a6: Unknown result type (might be due to invalid IL or missing references)
            //IL_01ab: Unknown result type (might be due to invalid IL or missing references)
            //IL_01b6: Expected O, but got Unknown
            //IL_01b7: Expected O, but got Unknown
            string sql = "INSERT INTO menu\r\n\t\t\t\t(ID,ParentID,AppLibraryID,Title,Params,Ico,Sort,IcoColor) \r\n\t\t\t\tVALUES(@ID,@ParentID,@AppLibraryID,@Title,@Params,@Ico,@Sort,@IcoColor)";

            MySqlParameter[] obj = new MySqlParameter[8];
            MySqlParameter   val = new MySqlParameter("@ID", 253, 36);

            ((DbParameter)val).Value = model.ID;
            obj[0] = val;
            MySqlParameter val2 = new MySqlParameter("@ParentID", 253, 36);

            ((DbParameter)val2).Value = model.ParentID;
            obj[1] = val2;
            _003F val3;

            if (model.AppLibraryID.HasValue)
            {
                val3 = new MySqlParameter("@AppLibraryID", 253, 36);
                ((DbParameter)val3).Value = model.AppLibraryID;
            }
            else
            {
                val3 = new MySqlParameter("@AppLibraryID", 253, 36);
                ((DbParameter)val3).Value = DBNull.Value;
            }
            obj[2] = val3;
            MySqlParameter val4 = new MySqlParameter("@Title", 752, -1);

            ((DbParameter)val4).Value = model.Title;
            obj[3] = val4;
            _003F val5;

            if (model.Params != null)
            {
                val5 = new MySqlParameter("@Params", 752, -1);
                ((DbParameter)val5).Value = model.Params;
            }
            else
            {
                val5 = new MySqlParameter("@Params", 752, -1);
                ((DbParameter)val5).Value = DBNull.Value;
            }
            obj[4] = val5;
            _003F val6;

            if (model.Ico != null)
            {
                val6 = new MySqlParameter("@Ico", 752, -1);
                ((DbParameter)val6).Value = model.Ico;
            }
            else
            {
                val6 = new MySqlParameter("@Ico", 752, -1);
                ((DbParameter)val6).Value = DBNull.Value;
            }
            obj[5] = val6;
            MySqlParameter val7 = new MySqlParameter("@Sort", 3, 11);

            ((DbParameter)val7).Value = model.Sort;
            obj[6] = val7;
            _003F val8;

            if (model.IcoColor != null)
            {
                val8 = new MySqlParameter("@IcoColor", 253, 50);
                ((DbParameter)val8).Value = model.IcoColor;
            }
            else
            {
                val8 = new MySqlParameter("@IcoColor", 253, 50);
                ((DbParameter)val8).Value = DBNull.Value;
            }
            obj[7] = val8;
            MySqlParameter[] parameter = (MySqlParameter[])obj;
            return(dbHelper.Execute(sql, parameter));
        }
コード例 #11
0
        public int Update(RoadFlow.Data.Model.Menu model)
        {
            //IL_001a: Unknown result type (might be due to invalid IL or missing references)
            //IL_001f: Unknown result type (might be due to invalid IL or missing references)
            //IL_0030: Expected O, but got Unknown
            //IL_0031: Expected O, but got Unknown
            //IL_004f: Unknown result type (might be due to invalid IL or missing references)
            //IL_0054: Unknown result type (might be due to invalid IL or missing references)
            //IL_0065: Expected O, but got Unknown
            //IL_0073: Unknown result type (might be due to invalid IL or missing references)
            //IL_0078: Unknown result type (might be due to invalid IL or missing references)
            //IL_0083: Expected O, but got Unknown
            //IL_0084: Expected O, but got Unknown
            //IL_0091: Unknown result type (might be due to invalid IL or missing references)
            //IL_0096: Unknown result type (might be due to invalid IL or missing references)
            //IL_00a2: Expected O, but got Unknown
            //IL_00a3: Expected O, but got Unknown
            //IL_00b8: Unknown result type (might be due to invalid IL or missing references)
            //IL_00bd: Unknown result type (might be due to invalid IL or missing references)
            //IL_00c9: Expected O, but got Unknown
            //IL_00d6: Unknown result type (might be due to invalid IL or missing references)
            //IL_00db: Unknown result type (might be due to invalid IL or missing references)
            //IL_00e6: Expected O, but got Unknown
            //IL_00e7: Expected O, but got Unknown
            //IL_00fc: Unknown result type (might be due to invalid IL or missing references)
            //IL_0101: Unknown result type (might be due to invalid IL or missing references)
            //IL_010d: Expected O, but got Unknown
            //IL_011a: Unknown result type (might be due to invalid IL or missing references)
            //IL_011f: Unknown result type (might be due to invalid IL or missing references)
            //IL_012a: Expected O, but got Unknown
            //IL_012b: Expected O, but got Unknown
            //IL_0135: Unknown result type (might be due to invalid IL or missing references)
            //IL_013a: Unknown result type (might be due to invalid IL or missing references)
            //IL_014b: Expected O, but got Unknown
            //IL_014c: Expected O, but got Unknown
            //IL_0162: Unknown result type (might be due to invalid IL or missing references)
            //IL_0167: Unknown result type (might be due to invalid IL or missing references)
            //IL_0173: Expected O, but got Unknown
            //IL_0181: Unknown result type (might be due to invalid IL or missing references)
            //IL_0186: Unknown result type (might be due to invalid IL or missing references)
            //IL_0191: Expected O, but got Unknown
            //IL_0192: Expected O, but got Unknown
            //IL_01a0: Unknown result type (might be due to invalid IL or missing references)
            //IL_01a5: Unknown result type (might be due to invalid IL or missing references)
            //IL_01b6: Expected O, but got Unknown
            //IL_01b7: Expected O, but got Unknown
            string sql = "UPDATE menu SET \r\n\t\t\t\tParentID=@ParentID,AppLibraryID=@AppLibraryID,Title=@Title,Params=@Params,Ico=@Ico,Sort=@Sort,IcoColor=@IcoColor \r\n\t\t\t\tWHERE ID=@ID";

            MySqlParameter[] obj = new MySqlParameter[8];
            MySqlParameter   val = new MySqlParameter("@ParentID", 253, 36);

            ((DbParameter)val).Value = model.ParentID;
            obj[0] = val;
            _003F val2;

            if (model.AppLibraryID.HasValue)
            {
                val2 = new MySqlParameter("@AppLibraryID", 253, 36);
                ((DbParameter)val2).Value = model.AppLibraryID;
            }
            else
            {
                val2 = new MySqlParameter("@AppLibraryID", 253, 36);
                ((DbParameter)val2).Value = DBNull.Value;
            }
            obj[1] = val2;
            MySqlParameter val3 = new MySqlParameter("@Title", 752, -1);

            ((DbParameter)val3).Value = model.Title;
            obj[2] = val3;
            _003F val4;

            if (model.Params != null)
            {
                val4 = new MySqlParameter("@Params", 752, -1);
                ((DbParameter)val4).Value = model.Params;
            }
            else
            {
                val4 = new MySqlParameter("@Params", 752, -1);
                ((DbParameter)val4).Value = DBNull.Value;
            }
            obj[3] = val4;
            _003F val5;

            if (model.Ico != null)
            {
                val5 = new MySqlParameter("@Ico", 752, -1);
                ((DbParameter)val5).Value = model.Ico;
            }
            else
            {
                val5 = new MySqlParameter("@Ico", 752, -1);
                ((DbParameter)val5).Value = DBNull.Value;
            }
            obj[4] = val5;
            MySqlParameter val6 = new MySqlParameter("@Sort", 3, 11);

            ((DbParameter)val6).Value = model.Sort;
            obj[5] = val6;
            _003F val7;

            if (model.IcoColor != null)
            {
                val7 = new MySqlParameter("@IcoColor", 253, 50);
                ((DbParameter)val7).Value = model.IcoColor;
            }
            else
            {
                val7 = new MySqlParameter("@IcoColor", 253, 50);
                ((DbParameter)val7).Value = DBNull.Value;
            }
            obj[6] = val7;
            MySqlParameter val8 = new MySqlParameter("@ID", 253, 36);

            ((DbParameter)val8).Value = model.ID;
            obj[7] = val8;
            MySqlParameter[] parameter = (MySqlParameter[])obj;
            return(dbHelper.Execute(sql, parameter));
        }