public int Add(RoadFlow.Data.Model.UserShortcut model) { string sql = "INSERT INTO UserShortcut\r\n\t\t\t\t(ID,MenuID,UserID,Sort) \r\n\t\t\t\tVALUES(:ID,:MenuID,:UserID,:Sort)"; OracleParameter[] oracleParameterArray = new OracleParameter[4]; int index1 = 0; OracleParameter oracleParameter1 = new OracleParameter(":ID", OracleDbType.Varchar2); oracleParameter1.Value = (object)model.ID; oracleParameterArray[index1] = oracleParameter1; int index2 = 1; OracleParameter oracleParameter2 = new OracleParameter(":MenuID", OracleDbType.Varchar2); oracleParameter2.Value = (object)model.MenuID; oracleParameterArray[index2] = oracleParameter2; int index3 = 2; OracleParameter oracleParameter3 = new OracleParameter(":UserID", OracleDbType.Varchar2); oracleParameter3.Value = (object)model.UserID; oracleParameterArray[index3] = oracleParameter3; int index4 = 3; OracleParameter oracleParameter4 = new OracleParameter(":Sort", OracleDbType.Int32); oracleParameter4.Value = (object)model.Sort; oracleParameterArray[index4] = oracleParameter4; OracleParameter[] parameter = oracleParameterArray; return(this.dbHelper.Execute(sql, parameter)); }
public int Update(RoadFlow.Data.Model.UserShortcut model) { string sql = "UPDATE UserShortcut SET \r\n\t\t\t\tMenuID=:MenuID,UserID=:UserID,Sort=:Sort\r\n\t\t\t\tWHERE ID=:ID"; OracleParameter[] oracleParameterArray = new OracleParameter[4]; int index1 = 0; OracleParameter oracleParameter1 = new OracleParameter(":MenuID", OracleDbType.Varchar2); oracleParameter1.Value = (object)model.MenuID; oracleParameterArray[index1] = oracleParameter1; int index2 = 1; OracleParameter oracleParameter2 = new OracleParameter(":UserID", OracleDbType.Varchar2); oracleParameter2.Value = (object)model.UserID; oracleParameterArray[index2] = oracleParameter2; int index3 = 2; OracleParameter oracleParameter3 = new OracleParameter(":Sort", OracleDbType.Int32); oracleParameter3.Value = (object)model.Sort; oracleParameterArray[index3] = oracleParameter3; int index4 = 3; OracleParameter oracleParameter4 = new OracleParameter(":ID", OracleDbType.Varchar2); oracleParameter4.Value = (object)model.ID; oracleParameterArray[index4] = oracleParameter4; OracleParameter[] parameter = oracleParameterArray; return(this.dbHelper.Execute(sql, parameter)); }
public int Update(RoadFlow.Data.Model.UserShortcut model) { string sql = "UPDATE UserShortcut SET \r\n\t\t\t\tMenuID=@MenuID,UserID=@UserID,Sort=@Sort\r\n\t\t\t\tWHERE ID=@ID"; SqlParameter[] sqlParameterArray = new SqlParameter[4]; int index1 = 0; SqlParameter sqlParameter1 = new SqlParameter("@MenuID", SqlDbType.UniqueIdentifier, -1); sqlParameter1.Value = (object)model.MenuID; sqlParameterArray[index1] = sqlParameter1; int index2 = 1; SqlParameter sqlParameter2 = new SqlParameter("@UserID", SqlDbType.UniqueIdentifier, -1); sqlParameter2.Value = (object)model.UserID; sqlParameterArray[index2] = sqlParameter2; int index3 = 2; SqlParameter sqlParameter3 = new SqlParameter("@Sort", SqlDbType.Int, -1); sqlParameter3.Value = (object)model.Sort; sqlParameterArray[index3] = sqlParameter3; int index4 = 3; SqlParameter sqlParameter4 = new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1); sqlParameter4.Value = (object)model.ID; sqlParameterArray[index4] = sqlParameter4; SqlParameter[] parameter = sqlParameterArray; return(this.dbHelper.Execute(sql, parameter, false)); }
public int Add(RoadFlow.Data.Model.UserShortcut model) { string sql = "INSERT INTO UserShortcut\r\n\t\t\t\t(ID,MenuID,UserID,Sort) \r\n\t\t\t\tVALUES(@ID,@MenuID,@UserID,@Sort)"; SqlParameter[] sqlParameterArray = new SqlParameter[4]; int index1 = 0; SqlParameter sqlParameter1 = new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1); sqlParameter1.Value = (object)model.ID; sqlParameterArray[index1] = sqlParameter1; int index2 = 1; SqlParameter sqlParameter2 = new SqlParameter("@MenuID", SqlDbType.UniqueIdentifier, -1); sqlParameter2.Value = (object)model.MenuID; sqlParameterArray[index2] = sqlParameter2; int index3 = 2; SqlParameter sqlParameter3 = new SqlParameter("@UserID", SqlDbType.UniqueIdentifier, -1); sqlParameter3.Value = (object)model.UserID; sqlParameterArray[index3] = sqlParameter3; int index4 = 3; SqlParameter sqlParameter4 = new SqlParameter("@Sort", SqlDbType.Int, -1); sqlParameter4.Value = (object)model.Sort; sqlParameterArray[index4] = sqlParameter4; SqlParameter[] parameter = sqlParameterArray; return(this.dbHelper.Execute(sql, parameter, false)); }
public int Update(RoadFlow.Data.Model.UserShortcut model) { string sql = "UPDATE usershortcut SET \r\n\t\t\t\tMenuID=@MenuID,UserID=@UserID,Sort=@Sort\r\n\t\t\t\tWHERE ID=@ID"; MySqlParameter[] mySqlParameterArray = new MySqlParameter[4]; int index1 = 0; MySqlParameter mySqlParameter1 = new MySqlParameter("@MenuID", MySqlDbType.VarChar, 36); mySqlParameter1.Value = (object)model.MenuID; mySqlParameterArray[index1] = mySqlParameter1; int index2 = 1; MySqlParameter mySqlParameter2 = new MySqlParameter("@UserID", MySqlDbType.VarChar, 36); mySqlParameter2.Value = (object)model.UserID; mySqlParameterArray[index2] = mySqlParameter2; int index3 = 2; MySqlParameter mySqlParameter3 = new MySqlParameter("@Sort", MySqlDbType.Int32, 11); mySqlParameter3.Value = (object)model.Sort; mySqlParameterArray[index3] = mySqlParameter3; int index4 = 3; MySqlParameter mySqlParameter4 = new MySqlParameter("@ID", MySqlDbType.VarChar, 36); mySqlParameter4.Value = (object)model.ID; mySqlParameterArray[index4] = mySqlParameter4; MySqlParameter[] parameter = mySqlParameterArray; return(this.dbHelper.Execute(sql, parameter, false)); }
public int Add(RoadFlow.Data.Model.UserShortcut model) { string sql = "INSERT INTO usershortcut\r\n\t\t\t\t(ID,MenuID,UserID,Sort) \r\n\t\t\t\tVALUES(@ID,@MenuID,@UserID,@Sort)"; MySqlParameter[] mySqlParameterArray = new MySqlParameter[4]; int index1 = 0; MySqlParameter mySqlParameter1 = new MySqlParameter("@ID", MySqlDbType.VarChar, 36); mySqlParameter1.Value = (object)model.ID; mySqlParameterArray[index1] = mySqlParameter1; int index2 = 1; MySqlParameter mySqlParameter2 = new MySqlParameter("@MenuID", MySqlDbType.VarChar, 36); mySqlParameter2.Value = (object)model.MenuID; mySqlParameterArray[index2] = mySqlParameter2; int index3 = 2; MySqlParameter mySqlParameter3 = new MySqlParameter("@UserID", MySqlDbType.VarChar, 36); mySqlParameter3.Value = (object)model.UserID; mySqlParameterArray[index3] = mySqlParameter3; int index4 = 3; MySqlParameter mySqlParameter4 = new MySqlParameter("@Sort", MySqlDbType.Int32, 11); mySqlParameter4.Value = (object)model.Sort; mySqlParameterArray[index4] = mySqlParameter4; MySqlParameter[] parameter = mySqlParameterArray; return(this.dbHelper.Execute(sql, parameter, false)); }
public int Update(RoadFlow.Data.Model.UserShortcut model) { return(this.dataUserShortcut.Update(model)); }
public int Add(RoadFlow.Data.Model.UserShortcut model) { return(this.dataUserShortcut.Add(model)); }
public ActionResult ShortcutSet(FormCollection collection) { RoadFlow.Platform.UserShortcut userShortcut = new RoadFlow.Platform.UserShortcut(); if (collection != null) { if (!this.Request.Form["issort"].IsNullOrEmpty()) { string[] strArray = (this.Request.Form["sort"] ?? "").Split(','); for (int index = 0; index < strArray.Length; ++index) { RoadFlow.Data.Model.UserShortcut model = userShortcut.Get(strArray[index].ToGuid()); if (model != null) { model.Sort = index; userShortcut.Update(model); } } // ISSUE: reference to a compiler-generated field if (UserInfoController.\u003C\u003Eo__5.\u003C\u003Ep__0 == null) { // ISSUE: reference to a compiler-generated field UserInfoController.\u003C\u003Eo__5.\u003C\u003Ep__0 = CallSite <Func <CallSite, object, string, object> > .Create(Binder.SetMember(CSharpBinderFlags.None, "script", typeof(UserInfoController), (IEnumerable <CSharpArgumentInfo>) new CSharpArgumentInfo[2] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, (string)null), CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.UseCompileTimeType | CSharpArgumentInfoFlags.Constant, (string)null) })); } // ISSUE: reference to a compiler-generated field // ISSUE: reference to a compiler-generated field object obj = UserInfoController.\u003C\u003Eo__5.\u003C\u003Ep__0.Target((CallSite)UserInfoController.\u003C\u003Eo__5.\u003C\u003Ep__0, this.ViewBag, "alert('排序保存成功!');window.location=window.location;"); } else { Guid currentUserId = RoadFlow.Platform.Users.CurrentUserID; string str1 = this.Request.Form["menuid"] ?? ""; using (TransactionScope transactionScope = new TransactionScope()) { userShortcut.DeleteByUserID(currentUserId); int num = 0; string str2 = str1; char[] chArray = new char[1] { ',' }; foreach (string str3 in str2.Split(chArray)) { if (str3.IsGuid()) { userShortcut.Add(new RoadFlow.Data.Model.UserShortcut() { ID = Guid.NewGuid(), MenuID = str3.ToGuid(), Sort = num++, UserID = currentUserId }); } } transactionScope.Complete(); // ISSUE: reference to a compiler-generated field if (UserInfoController.\u003C\u003Eo__5.\u003C\u003Ep__1 == null) { // ISSUE: reference to a compiler-generated field UserInfoController.\u003C\u003Eo__5.\u003C\u003Ep__1 = CallSite <Func <CallSite, object, string, object> > .Create(Binder.SetMember(CSharpBinderFlags.None, "script", typeof(UserInfoController), (IEnumerable <CSharpArgumentInfo>) new CSharpArgumentInfo[2] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, (string)null), CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.UseCompileTimeType | CSharpArgumentInfoFlags.Constant, (string)null) })); } // ISSUE: reference to a compiler-generated field // ISSUE: reference to a compiler-generated field object obj = UserInfoController.\u003C\u003Eo__5.\u003C\u003Ep__1.Target((CallSite)UserInfoController.\u003C\u003Eo__5.\u003C\u003Ep__1, this.ViewBag, "alert('保存成功!');window.location=window.location;"); } } userShortcut.ClearCache(); } return((ActionResult)this.View()); }