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);
}
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));
}
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);
}
/// <summary>
/// 更新菜单
/// </summary>
/// <param name="menu">菜单实体</param>
public int Update(Model.Menu menu)
{
ClearCache();
using (var db = new DataContext())
{
db.Update(menu);
return(db.SaveChanges());
}
}
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));
}
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));
}
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());
}
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));
}
public int Update(RoadFlow.Data.Model.Menu model)
{
ClearAllDataTableCache();
return(dataMenu.Update(model));
}
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));
}
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));
}
