public string GetDataSourceString(RoadFlow.Data.Model.HomeItems item)
{
if (item != null)
{
switch (item.DataSourceType)
{
case 0:
if (item.DBConnID.HasValue)
{
return(getSqlString(item.DataSource, item.Type, item.DBConnID.Value));
}
return("");
case 1:
return(GetCsharpMethodString(item.DataSource));
case 2:
return(GetUrlString(item.DataSource));
default:
return("");
}
}
return("");
}
private List <RoadFlow.Data.Model.HomeItems> DataReaderToList(SqlDataReader dataReader)
{
List <RoadFlow.Data.Model.HomeItems> list = new List <RoadFlow.Data.Model.HomeItems>();
RoadFlow.Data.Model.HomeItems homeItems = null;
while (dataReader.Read())
{
homeItems = new RoadFlow.Data.Model.HomeItems();
homeItems.ID = dataReader.GetGuid(0);
homeItems.Type = dataReader.GetInt32(1);
homeItems.Name = dataReader.GetString(2);
homeItems.Title = dataReader.GetString(3);
homeItems.DataSourceType = dataReader.GetInt32(4);
if (!dataReader.IsDBNull(5))
{
homeItems.DataSource = dataReader.GetString(5);
}
if (!dataReader.IsDBNull(6))
{
homeItems.Ico = dataReader.GetString(6);
}
if (!dataReader.IsDBNull(7))
{
homeItems.BgColor = dataReader.GetString(7);
}
if (!dataReader.IsDBNull(8))
{
homeItems.Color = dataReader.GetString(8);
}
if (!dataReader.IsDBNull(9))
{
homeItems.DBConnID = dataReader.GetGuid(9);
}
if (!dataReader.IsDBNull(10))
{
homeItems.LinkURL = dataReader.GetString(10);
}
if (!dataReader.IsDBNull(11))
{
homeItems.UseOrganizes = dataReader.GetString(11);
}
if (!dataReader.IsDBNull(12))
{
homeItems.UseUsers = dataReader.GetString(12);
}
if (!dataReader.IsDBNull(13))
{
homeItems.Sort = dataReader.GetInt32(13);
}
if (!dataReader.IsDBNull(14))
{
homeItems.Note = dataReader.GetString(14);
}
list.Add(homeItems);
}
return(list);
}
public ActionResult SetAdd(FormCollection collection)
{
RoadFlow.Platform.HomeItems homeItems = new RoadFlow.Platform.HomeItems();
RoadFlow.Data.Model.HomeItems homeItems2 = null;
string str = base.Request.QueryString["id"];
if (str.IsGuid())
{
homeItems2 = homeItems.Get(str.ToGuid());
}
if (collection != null)
{
string name = base.Request.Form["Name1"];
string title = base.Request.Form["Title1"];
string str2 = base.Request.Form["Type"];
string str3 = base.Request.Form["DataSourceType"];
string dataSource = base.Request.Form["DataSource"];
string ico = base.Request.Form["Ico"];
string bgColor = base.Request.Form["BgColor"];
string useOrganizes = base.Request.Form["UseOrganizes"];
string str4 = base.Request.Form["DBConnID"];
string linkURL = base.Request.Form["LinkURL"];
string note = base.Request.Form["Note"];
string str5 = base.Request.Form["Sort"];
bool flag = false;
if (homeItems2 == null)
{
homeItems2 = new RoadFlow.Data.Model.HomeItems();
homeItems2.ID = Guid.NewGuid();
flag = true;
}
homeItems2.Title = title;
homeItems2.Name = name;
homeItems2.Type = str2.ToInt();
homeItems2.DataSourceType = str3.ToInt();
homeItems2.DataSource = dataSource;
homeItems2.Ico = ico;
homeItems2.BgColor = bgColor;
homeItems2.UseOrganizes = useOrganizes;
homeItems2.Sort = (str5.IsInt() ? str5.ToInt() : homeItems.GetMaxSort(homeItems2.Type));
if (str4.IsGuid())
{
homeItems2.DBConnID = str4.ToGuid();
}
else
{
homeItems2.DBConnID = null;
}
homeItems2.LinkURL = linkURL;
homeItems2.Note = note;
if (flag)
{
homeItems.Add(homeItems2);
}
else
{
homeItems.Update(homeItems2);
}
homeItems.ClearCache();
base.ViewBag.script = "alert('保存成功!');window.location='SetList" + base.Request.Url.Query + "';";
}
base.ViewBag.TypeOptions = homeItems.getTypeOptions((homeItems2 == null) ? "" : homeItems2.Type.ToString());
base.ViewBag.DataSourceTypeOptions = homeItems.getDataSourceOptions((homeItems2 == null) ? "" : homeItems2.DataSourceType.ToString());
base.ViewBag.DBConnIDOptions = new RoadFlow.Platform.DBConnection().GetAllOptions((homeItems2 == null) ? "" : homeItems2.DBConnID.ToString());
if (homeItems2 == null)
{
homeItems2 = new RoadFlow.Data.Model.HomeItems();
}
return(View(homeItems2));
}
public int Update(RoadFlow.Data.Model.HomeItems model)
{
return(dataHomeItems.Update(model));
}
public int Add(RoadFlow.Data.Model.HomeItems model)
{
return(dataHomeItems.Add(model));
}
public int Add(RoadFlow.Data.Model.HomeItems model)
{
string sql = "INSERT INTO HomeItems\r\n\t\t\t\t(ID,Type,Name,Title,DataSourceType,DataSource,Ico,BgColor,Color,DBConnID,LinkURL,UseOrganizes,UseUsers,Sort,Note) \r\n\t\t\t\tVALUES(@ID,@Type,@Name,@Title,@DataSourceType,@DataSource,@Ico,@BgColor,@Color,@DBConnID,@LinkURL,@UseOrganizes,@UseUsers,@Sort,@Note)";
SqlParameter[] parameter = new SqlParameter[15]
{
new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.ID
},
new SqlParameter("@Type", SqlDbType.Int, -1)
{
Value = model.Type
},
new SqlParameter("@Name", SqlDbType.NVarChar, 1000)
{
Value = model.Name
},
new SqlParameter("@Title", SqlDbType.NVarChar, 1000)
{
Value = model.Title
},
new SqlParameter("@DataSourceType", SqlDbType.Int, -1)
{
Value = model.DataSourceType
},
(model.DataSource == null) ? new SqlParameter("@DataSource", SqlDbType.VarChar, -1)
{
Value = DBNull.Value
} : new SqlParameter("@DataSource", SqlDbType.VarChar, -1)
{
Value = model.DataSource
},
(model.Ico == null) ? new SqlParameter("@Ico", SqlDbType.VarChar, 2000)
{
Value = DBNull.Value
} : new SqlParameter("@Ico", SqlDbType.VarChar, 2000)
{
Value = model.Ico
},
(model.BgColor == null) ? new SqlParameter("@BgColor", SqlDbType.VarChar, 50)
{
Value = DBNull.Value
} : new SqlParameter("@BgColor", SqlDbType.VarChar, 50)
{
Value = model.BgColor
},
(model.Color == null) ? new SqlParameter("@Color", SqlDbType.VarChar, 50)
{
Value = DBNull.Value
} : new SqlParameter("@Color", SqlDbType.VarChar, 50)
{
Value = model.Color
},
(!model.DBConnID.HasValue) ? new SqlParameter("@DBConnID", SqlDbType.UniqueIdentifier, -1)
{
Value = DBNull.Value
} : new SqlParameter("@DBConnID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.DBConnID
},
(model.LinkURL == null) ? new SqlParameter("@LinkURL", SqlDbType.VarChar, 2000)
{
Value = DBNull.Value
} : new SqlParameter("@LinkURL", SqlDbType.VarChar, 2000)
{
Value = model.LinkURL
},
(model.UseOrganizes == null) ? new SqlParameter("@UseOrganizes", SqlDbType.VarChar, -1)
{
Value = DBNull.Value
} : new SqlParameter("@UseOrganizes", SqlDbType.VarChar, -1)
{
Value = model.UseOrganizes
},
(model.UseUsers == null) ? new SqlParameter("@UseUsers", SqlDbType.VarChar, -1)
{
Value = DBNull.Value
} : new SqlParameter("@UseUsers", SqlDbType.VarChar, -1)
{
Value = model.UseUsers
},
(!model.Sort.HasValue) ? new SqlParameter("@Sort", SqlDbType.Int, -1)
{
Value = DBNull.Value
} : new SqlParameter("@Sort", SqlDbType.Int, -1)
{
Value = model.Sort
},
(model.Note == null) ? new SqlParameter("@Note", SqlDbType.NVarChar, 4000)
{
Value = DBNull.Value
} : new SqlParameter("@Note", SqlDbType.NVarChar, 4000)
{
Value = model.Note
}
};
return(dbHelper.Execute(sql, parameter));
}
public int Update(RoadFlow.Data.Model.HomeItems model)
{
string sql = "UPDATE HomeItems SET \r\n\t\t\t\tType=@Type,Name=@Name,Title=@Title,DataSourceType=@DataSourceType,DataSource=@DataSource,Ico=@Ico,BgColor=@BgColor,Color=@Color,DBConnID=@DBConnID,LinkURL=@LinkURL,UseOrganizes=@UseOrganizes,UseUsers=@UseUsers,Sort=@Sort,Note=@Note\r\n\t\t\t\tWHERE ID=@ID";
SqlParameter[] parameter = new SqlParameter[15]
{
new SqlParameter("@Type", SqlDbType.Int, -1)
{
Value = model.Type
},
new SqlParameter("@Name", SqlDbType.NVarChar, 1000)
{
Value = model.Name
},
new SqlParameter("@Title", SqlDbType.NVarChar, 1000)
{
Value = model.Title
},
new SqlParameter("@DataSourceType", SqlDbType.Int, -1)
{
Value = model.DataSourceType
},
(model.DataSource == null) ? new SqlParameter("@DataSource", SqlDbType.VarChar, -1)
{
Value = DBNull.Value
} : new SqlParameter("@DataSource", SqlDbType.VarChar, -1)
{
Value = model.DataSource
},
(model.Ico == null) ? new SqlParameter("@Ico", SqlDbType.VarChar, 2000)
{
Value = DBNull.Value
} : new SqlParameter("@Ico", SqlDbType.VarChar, 2000)
{
Value = model.Ico
},
(model.BgColor == null) ? new SqlParameter("@BgColor", SqlDbType.VarChar, 50)
{
Value = DBNull.Value
} : new SqlParameter("@BgColor", SqlDbType.VarChar, 50)
{
Value = model.BgColor
},
(model.Color == null) ? new SqlParameter("@Color", SqlDbType.VarChar, 50)
{
Value = DBNull.Value
} : new SqlParameter("@Color", SqlDbType.VarChar, 50)
{
Value = model.Color
},
(!model.DBConnID.HasValue) ? new SqlParameter("@DBConnID", SqlDbType.UniqueIdentifier, -1)
{
Value = DBNull.Value
} : new SqlParameter("@DBConnID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.DBConnID
},
(model.LinkURL == null) ? new SqlParameter("@LinkURL", SqlDbType.VarChar, 2000)
{
Value = DBNull.Value
} : new SqlParameter("@LinkURL", SqlDbType.VarChar, 2000)
{
Value = model.LinkURL
},
(model.UseOrganizes == null) ? new SqlParameter("@UseOrganizes", SqlDbType.VarChar, -1)
{
Value = DBNull.Value
} : new SqlParameter("@UseOrganizes", SqlDbType.VarChar, -1)
{
Value = model.UseOrganizes
},
(model.UseUsers == null) ? new SqlParameter("@UseUsers", SqlDbType.VarChar, -1)
{
Value = DBNull.Value
} : new SqlParameter("@UseUsers", SqlDbType.VarChar, -1)
{
Value = model.UseUsers
},
(!model.Sort.HasValue) ? new SqlParameter("@Sort", SqlDbType.Int, -1)
{
Value = DBNull.Value
} : new SqlParameter("@Sort", SqlDbType.Int, -1)
{
Value = model.Sort
},
(model.Note == null) ? new SqlParameter("@Note", SqlDbType.NVarChar, 4000)
{
Value = DBNull.Value
} : new SqlParameter("@Note", SqlDbType.NVarChar, 4000)
{
Value = model.Note
},
new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.ID
}
};
return(dbHelper.Execute(sql, parameter));
}
public int Update(RoadFlow.Data.Model.HomeItems model)
{
//IL_0017: Unknown result type (might be due to invalid IL or missing references)
//IL_001c: Unknown result type (might be due to invalid IL or missing references)
//IL_002d: Expected O, but got Unknown
//IL_002e: Expected O, but got Unknown
//IL_003b: Unknown result type (might be due to invalid IL or missing references)
//IL_0040: Unknown result type (might be due to invalid IL or missing references)
//IL_004c: Expected O, but got Unknown
//IL_004d: Expected O, but got Unknown
//IL_005a: Unknown result type (might be due to invalid IL or missing references)
//IL_005f: Unknown result type (might be due to invalid IL or missing references)
//IL_006b: Expected O, but got Unknown
//IL_006c: Expected O, but got Unknown
//IL_0076: Unknown result type (might be due to invalid IL or missing references)
//IL_007b: Unknown result type (might be due to invalid IL or missing references)
//IL_008c: Expected O, but got Unknown
//IL_008d: Expected O, but got Unknown
//IL_00a2: Unknown result type (might be due to invalid IL or missing references)
//IL_00a7: Unknown result type (might be due to invalid IL or missing references)
//IL_00b3: Expected O, but got Unknown
//IL_00c0: Unknown result type (might be due to invalid IL or missing references)
//IL_00c5: Unknown result type (might be due to invalid IL or missing references)
//IL_00d0: Expected O, but got Unknown
//IL_00d1: Expected O, but got Unknown
//IL_00e6: Unknown result type (might be due to invalid IL or missing references)
//IL_00eb: Unknown result type (might be due to invalid IL or missing references)
//IL_00f7: Expected O, but got Unknown
//IL_0104: Unknown result type (might be due to invalid IL or missing references)
//IL_0109: Unknown result type (might be due to invalid IL or missing references)
//IL_0114: Expected O, but got Unknown
//IL_0115: Expected O, but got Unknown
//IL_012b: Unknown result type (might be due to invalid IL or missing references)
//IL_0130: Unknown result type (might be due to invalid IL or missing references)
//IL_013c: Expected O, but got Unknown
//IL_014a: Unknown result type (might be due to invalid IL or missing references)
//IL_014f: Unknown result type (might be due to invalid IL or missing references)
//IL_015a: Expected O, but got Unknown
//IL_015b: Expected O, but got Unknown
//IL_0171: Unknown result type (might be due to invalid IL or missing references)
//IL_0176: Unknown result type (might be due to invalid IL or missing references)
//IL_0182: Expected O, but got Unknown
//IL_0190: Unknown result type (might be due to invalid IL or missing references)
//IL_0195: Unknown result type (might be due to invalid IL or missing references)
//IL_01a0: Expected O, but got Unknown
//IL_01a1: Expected O, but got Unknown
//IL_01bf: Unknown result type (might be due to invalid IL or missing references)
//IL_01c4: Unknown result type (might be due to invalid IL or missing references)
//IL_01d5: Expected O, but got Unknown
//IL_01e3: Unknown result type (might be due to invalid IL or missing references)
//IL_01e8: Unknown result type (might be due to invalid IL or missing references)
//IL_01f3: Expected O, but got Unknown
//IL_01f4: Expected O, but got Unknown
//IL_020a: Unknown result type (might be due to invalid IL or missing references)
//IL_020f: Unknown result type (might be due to invalid IL or missing references)
//IL_021b: Expected O, but got Unknown
//IL_0228: Unknown result type (might be due to invalid IL or missing references)
//IL_022d: Unknown result type (might be due to invalid IL or missing references)
//IL_0238: Expected O, but got Unknown
//IL_0239: Expected O, but got Unknown
//IL_024f: Unknown result type (might be due to invalid IL or missing references)
//IL_0254: Unknown result type (might be due to invalid IL or missing references)
//IL_0260: Expected O, but got Unknown
//IL_026d: Unknown result type (might be due to invalid IL or missing references)
//IL_0272: Unknown result type (might be due to invalid IL or missing references)
//IL_027d: Expected O, but got Unknown
//IL_027e: Expected O, but got Unknown
//IL_0294: Unknown result type (might be due to invalid IL or missing references)
//IL_0299: Unknown result type (might be due to invalid IL or missing references)
//IL_02a5: Expected O, but got Unknown
//IL_02b2: Unknown result type (might be due to invalid IL or missing references)
//IL_02b7: Unknown result type (might be due to invalid IL or missing references)
//IL_02c2: Expected O, but got Unknown
//IL_02c3: Expected O, but got Unknown
//IL_02de: Unknown result type (might be due to invalid IL or missing references)
//IL_02e3: Unknown result type (might be due to invalid IL or missing references)
//IL_02f4: Expected O, but got Unknown
//IL_02fe: Unknown result type (might be due to invalid IL or missing references)
//IL_0303: Unknown result type (might be due to invalid IL or missing references)
//IL_030e: Expected O, but got Unknown
//IL_030f: Expected O, but got Unknown
//IL_0325: Unknown result type (might be due to invalid IL or missing references)
//IL_032a: Unknown result type (might be due to invalid IL or missing references)
//IL_0336: Expected O, but got Unknown
//IL_0343: Unknown result type (might be due to invalid IL or missing references)
//IL_0348: Unknown result type (might be due to invalid IL or missing references)
//IL_0353: Expected O, but got Unknown
//IL_0354: Expected O, but got Unknown
//IL_0363: Unknown result type (might be due to invalid IL or missing references)
//IL_0368: Unknown result type (might be due to invalid IL or missing references)
//IL_0379: Expected O, but got Unknown
//IL_037a: Expected O, but got Unknown
string sql = "UPDATE homeitems SET \r\n\t\t\t\tType=@Type,Name=@Name,Title=@Title,DataSourceType=@DataSourceType,DataSource=@DataSource,Ico=@Ico,BgColor=@BgColor,Color=@Color,DBConnID=@DBConnID,LinkURL=@LinkURL,UseOrganizes=@UseOrganizes,UseUsers=@UseUsers,Sort=@Sort,Note=@Note\r\n\t\t\t\tWHERE ID=@ID";
MySqlParameter[] obj = new MySqlParameter[15];
MySqlParameter val = new MySqlParameter("@Type", 3, 11);
((DbParameter)val).Value = model.Type;
obj[0] = val;
MySqlParameter val2 = new MySqlParameter("@Name", 752, -1);
((DbParameter)val2).Value = model.Name;
obj[1] = val2;
MySqlParameter val3 = new MySqlParameter("@Title", 752, -1);
((DbParameter)val3).Value = model.Title;
obj[2] = val3;
MySqlParameter val4 = new MySqlParameter("@DataSourceType", 3, 11);
((DbParameter)val4).Value = model.DataSourceType;
obj[3] = val4;
_003F val5;
if (model.DataSource != null)
{
val5 = new MySqlParameter("@DataSource", 751, -1);
((DbParameter)val5).Value = model.DataSource;
}
else
{
val5 = new MySqlParameter("@DataSource", 751, -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;
_003F val7;
if (model.BgColor != null)
{
val7 = new MySqlParameter("@BgColor", 253, 50);
((DbParameter)val7).Value = model.BgColor;
}
else
{
val7 = new MySqlParameter("@BgColor", 253, 50);
((DbParameter)val7).Value = DBNull.Value;
}
obj[6] = val7;
_003F val8;
if (model.Color != null)
{
val8 = new MySqlParameter("@Color", 253, 50);
((DbParameter)val8).Value = model.Color;
}
else
{
val8 = new MySqlParameter("@Color", 253, 50);
((DbParameter)val8).Value = DBNull.Value;
}
obj[7] = val8;
_003F val9;
if (model.DBConnID.HasValue)
{
val9 = new MySqlParameter("@DBConnID", 253, 36);
((DbParameter)val9).Value = model.DBConnID;
}
else
{
val9 = new MySqlParameter("@DBConnID", 253, 36);
((DbParameter)val9).Value = DBNull.Value;
}
obj[8] = val9;
_003F val10;
if (model.LinkURL != null)
{
val10 = new MySqlParameter("@LinkURL", 752, -1);
((DbParameter)val10).Value = model.LinkURL;
}
else
{
val10 = new MySqlParameter("@LinkURL", 752, -1);
((DbParameter)val10).Value = DBNull.Value;
}
obj[9] = val10;
_003F val11;
if (model.UseOrganizes != null)
{
val11 = new MySqlParameter("@UseOrganizes", 751, -1);
((DbParameter)val11).Value = model.UseOrganizes;
}
else
{
val11 = new MySqlParameter("@UseOrganizes", 751, -1);
((DbParameter)val11).Value = DBNull.Value;
}
obj[10] = val11;
_003F val12;
if (model.UseUsers != null)
{
val12 = new MySqlParameter("@UseUsers", 751, -1);
((DbParameter)val12).Value = model.UseUsers;
}
else
{
val12 = new MySqlParameter("@UseUsers", 751, -1);
((DbParameter)val12).Value = DBNull.Value;
}
obj[11] = val12;
_003F val13;
if (model.Sort.HasValue)
{
val13 = new MySqlParameter("@Sort", 3, 11);
((DbParameter)val13).Value = model.Sort;
}
else
{
val13 = new MySqlParameter("@Sort", 3, 11);
((DbParameter)val13).Value = DBNull.Value;
}
obj[12] = val13;
_003F val14;
if (model.Note != null)
{
val14 = new MySqlParameter("@Note", 752, -1);
((DbParameter)val14).Value = model.Note;
}
else
{
val14 = new MySqlParameter("@Note", 752, -1);
((DbParameter)val14).Value = DBNull.Value;
}
obj[13] = val14;
MySqlParameter val15 = new MySqlParameter("@ID", 253, 36);
((DbParameter)val15).Value = model.ID;
obj[14] = val15;
MySqlParameter[] parameter = (MySqlParameter[])obj;
return(dbHelper.Execute(sql, parameter));
}
public int Add(RoadFlow.Data.Model.HomeItems model)
{
//IL_001b: Unknown result type (might be due to invalid IL or missing references)
//IL_0020: Unknown result type (might be due to invalid IL or missing references)
//IL_0031: Expected O, but got Unknown
//IL_0032: Expected O, but got Unknown
//IL_003c: Unknown result type (might be due to invalid IL or missing references)
//IL_0041: Unknown result type (might be due to invalid IL or missing references)
//IL_0052: Expected O, but got Unknown
//IL_0053: Expected O, but got Unknown
//IL_0060: Unknown result type (might be due to invalid IL or missing references)
//IL_0065: Unknown result type (might be due to invalid IL or missing references)
//IL_0071: Expected O, but got Unknown
//IL_0072: Expected O, but got Unknown
//IL_007f: Unknown result type (might be due to invalid IL or missing references)
//IL_0084: Unknown result type (might be due to invalid IL or missing references)
//IL_0090: Expected O, but got Unknown
//IL_0091: Expected O, but got Unknown
//IL_009b: Unknown result type (might be due to invalid IL or missing references)
//IL_00a0: Unknown result type (might be due to invalid IL or missing references)
//IL_00b1: Expected O, but got Unknown
//IL_00b2: Expected O, but got Unknown
//IL_00c7: Unknown result type (might be due to invalid IL or missing references)
//IL_00cc: Unknown result type (might be due to invalid IL or missing references)
//IL_00d8: Expected O, but got Unknown
//IL_00e5: Unknown result type (might be due to invalid IL or missing references)
//IL_00ea: Unknown result type (might be due to invalid IL or missing references)
//IL_00f5: Expected O, but got Unknown
//IL_00f6: Expected O, but got Unknown
//IL_010b: Unknown result type (might be due to invalid IL or missing references)
//IL_0110: Unknown result type (might be due to invalid IL or missing references)
//IL_011c: Expected O, but got Unknown
//IL_0129: Unknown result type (might be due to invalid IL or missing references)
//IL_012e: Unknown result type (might be due to invalid IL or missing references)
//IL_0139: Expected O, but got Unknown
//IL_013a: Expected O, but got Unknown
//IL_0150: Unknown result type (might be due to invalid IL or missing references)
//IL_0155: Unknown result type (might be due to invalid IL or missing references)
//IL_0161: Expected O, but got Unknown
//IL_016f: Unknown result type (might be due to invalid IL or missing references)
//IL_0174: Unknown result type (might be due to invalid IL or missing references)
//IL_017f: Expected O, but got Unknown
//IL_0180: Expected O, but got Unknown
//IL_0196: Unknown result type (might be due to invalid IL or missing references)
//IL_019b: Unknown result type (might be due to invalid IL or missing references)
//IL_01a7: Expected O, but got Unknown
//IL_01b5: Unknown result type (might be due to invalid IL or missing references)
//IL_01ba: Unknown result type (might be due to invalid IL or missing references)
//IL_01c5: Expected O, but got Unknown
//IL_01c6: Expected O, but got Unknown
//IL_01e5: Unknown result type (might be due to invalid IL or missing references)
//IL_01ea: Unknown result type (might be due to invalid IL or missing references)
//IL_01fb: Expected O, but got Unknown
//IL_0209: Unknown result type (might be due to invalid IL or missing references)
//IL_020e: Unknown result type (might be due to invalid IL or missing references)
//IL_0219: Expected O, but got Unknown
//IL_021a: Expected O, but got Unknown
//IL_0230: Unknown result type (might be due to invalid IL or missing references)
//IL_0235: Unknown result type (might be due to invalid IL or missing references)
//IL_0241: Expected O, but got Unknown
//IL_024e: Unknown result type (might be due to invalid IL or missing references)
//IL_0253: Unknown result type (might be due to invalid IL or missing references)
//IL_025e: Expected O, but got Unknown
//IL_025f: Expected O, but got Unknown
//IL_0275: Unknown result type (might be due to invalid IL or missing references)
//IL_027a: Unknown result type (might be due to invalid IL or missing references)
//IL_0286: Expected O, but got Unknown
//IL_0293: Unknown result type (might be due to invalid IL or missing references)
//IL_0298: Unknown result type (might be due to invalid IL or missing references)
//IL_02a3: Expected O, but got Unknown
//IL_02a4: Expected O, but got Unknown
//IL_02ba: Unknown result type (might be due to invalid IL or missing references)
//IL_02bf: Unknown result type (might be due to invalid IL or missing references)
//IL_02cb: Expected O, but got Unknown
//IL_02d8: Unknown result type (might be due to invalid IL or missing references)
//IL_02dd: Unknown result type (might be due to invalid IL or missing references)
//IL_02e8: Expected O, but got Unknown
//IL_02e9: Expected O, but got Unknown
//IL_0304: Unknown result type (might be due to invalid IL or missing references)
//IL_0309: Unknown result type (might be due to invalid IL or missing references)
//IL_031a: Expected O, but got Unknown
//IL_0324: Unknown result type (might be due to invalid IL or missing references)
//IL_0329: Unknown result type (might be due to invalid IL or missing references)
//IL_0334: Expected O, but got Unknown
//IL_0335: Expected O, but got Unknown
//IL_034b: Unknown result type (might be due to invalid IL or missing references)
//IL_0350: Unknown result type (might be due to invalid IL or missing references)
//IL_035c: Expected O, but got Unknown
//IL_0369: Unknown result type (might be due to invalid IL or missing references)
//IL_036e: Unknown result type (might be due to invalid IL or missing references)
//IL_0379: Expected O, but got Unknown
//IL_037a: Expected O, but got Unknown
string sql = "INSERT INTO homeitems\r\n\t\t\t\t(ID,Type,Name,Title,DataSourceType,DataSource,Ico,BgColor,Color,DBConnID,LinkURL,UseOrganizes,UseUsers,Sort,Note) \r\n\t\t\t\tVALUES(@ID,@Type,@Name,@Title,@DataSourceType,@DataSource,@Ico,@BgColor,@Color,@DBConnID,@LinkURL,@UseOrganizes,@UseUsers,@Sort,@Note)";
MySqlParameter[] obj = new MySqlParameter[15];
MySqlParameter val = new MySqlParameter("@ID", 253, 36);
((DbParameter)val).Value = model.ID;
obj[0] = val;
MySqlParameter val2 = new MySqlParameter("@Type", 3, 11);
((DbParameter)val2).Value = model.Type;
obj[1] = val2;
MySqlParameter val3 = new MySqlParameter("@Name", 752, -1);
((DbParameter)val3).Value = model.Name;
obj[2] = val3;
MySqlParameter val4 = new MySqlParameter("@Title", 752, -1);
((DbParameter)val4).Value = model.Title;
obj[3] = val4;
MySqlParameter val5 = new MySqlParameter("@DataSourceType", 3, 11);
((DbParameter)val5).Value = model.DataSourceType;
obj[4] = val5;
_003F val6;
if (model.DataSource != null)
{
val6 = new MySqlParameter("@DataSource", 751, -1);
((DbParameter)val6).Value = model.DataSource;
}
else
{
val6 = new MySqlParameter("@DataSource", 751, -1);
((DbParameter)val6).Value = DBNull.Value;
}
obj[5] = val6;
_003F val7;
if (model.Ico != null)
{
val7 = new MySqlParameter("@Ico", 752, -1);
((DbParameter)val7).Value = model.Ico;
}
else
{
val7 = new MySqlParameter("@Ico", 752, -1);
((DbParameter)val7).Value = DBNull.Value;
}
obj[6] = val7;
_003F val8;
if (model.BgColor != null)
{
val8 = new MySqlParameter("@BgColor", 253, 50);
((DbParameter)val8).Value = model.BgColor;
}
else
{
val8 = new MySqlParameter("@BgColor", 253, 50);
((DbParameter)val8).Value = DBNull.Value;
}
obj[7] = val8;
_003F val9;
if (model.Color != null)
{
val9 = new MySqlParameter("@Color", 253, 50);
((DbParameter)val9).Value = model.Color;
}
else
{
val9 = new MySqlParameter("@Color", 253, 50);
((DbParameter)val9).Value = DBNull.Value;
}
obj[8] = val9;
_003F val10;
if (model.DBConnID.HasValue)
{
val10 = new MySqlParameter("@DBConnID", 253, 36);
((DbParameter)val10).Value = model.DBConnID;
}
else
{
val10 = new MySqlParameter("@DBConnID", 253, 36);
((DbParameter)val10).Value = DBNull.Value;
}
obj[9] = val10;
_003F val11;
if (model.LinkURL != null)
{
val11 = new MySqlParameter("@LinkURL", 752, -1);
((DbParameter)val11).Value = model.LinkURL;
}
else
{
val11 = new MySqlParameter("@LinkURL", 752, -1);
((DbParameter)val11).Value = DBNull.Value;
}
obj[10] = val11;
_003F val12;
if (model.UseOrganizes != null)
{
val12 = new MySqlParameter("@UseOrganizes", 751, -1);
((DbParameter)val12).Value = model.UseOrganizes;
}
else
{
val12 = new MySqlParameter("@UseOrganizes", 751, -1);
((DbParameter)val12).Value = DBNull.Value;
}
obj[11] = val12;
_003F val13;
if (model.UseUsers != null)
{
val13 = new MySqlParameter("@UseUsers", 751, -1);
((DbParameter)val13).Value = model.UseUsers;
}
else
{
val13 = new MySqlParameter("@UseUsers", 751, -1);
((DbParameter)val13).Value = DBNull.Value;
}
obj[12] = val13;
_003F val14;
if (model.Sort.HasValue)
{
val14 = new MySqlParameter("@Sort", 3, 11);
((DbParameter)val14).Value = model.Sort;
}
else
{
val14 = new MySqlParameter("@Sort", 3, 11);
((DbParameter)val14).Value = DBNull.Value;
}
obj[13] = val14;
_003F val15;
if (model.Note != null)
{
val15 = new MySqlParameter("@Note", 752, -1);
((DbParameter)val15).Value = model.Note;
}
else
{
val15 = new MySqlParameter("@Note", 752, -1);
((DbParameter)val15).Value = DBNull.Value;
}
obj[14] = val15;
MySqlParameter[] parameter = (MySqlParameter[])obj;
return(dbHelper.Execute(sql, parameter));
}