public ActionResult DocRead() { RoadFlow.Data.Model.Documents documents = null; RoadFlow.Platform.Documents documents2 = new RoadFlow.Platform.Documents(); RoadFlow.Platform.DocumentsReadUsers documentsReadUsers = new RoadFlow.Platform.DocumentsReadUsers(); bool flag = false; string str = base.Request.QueryString["docid"]; Guid currentUserID = RoadFlow.Platform.Users.CurrentUserID; if (str.IsGuid()) { documents = documents2.Get(str.ToGuid()); if (documents != null) { if (documentsReadUsers.Get(documents.ID, currentUserID) == null) { base.Response.Write("您无权查看该文档!"); base.Response.End(); return(null); } flag = (new RoadFlow.Platform.DocumentDirectory().HasPublish(documents.DirectoryID, currentUserID) || new RoadFlow.Platform.DocumentDirectory().HasManage(documents.DirectoryID, currentUserID)); documents2.UpdateReadCount(documents.ID); documentsReadUsers.UpdateRead(documents.ID, currentUserID); } } base.ViewBag.IsEdit = flag; if (documents == null) { documents = new RoadFlow.Data.Model.Documents(); } return(View(documents)); }
public string DocDelete() { RoadFlow.Data.Model.Documents documents = null; RoadFlow.Platform.Documents documents2 = new RoadFlow.Platform.Documents(); string str = base.Request.QueryString["docid"]; if (str.IsGuid()) { documents = documents2.Get(str.ToGuid()); } if (documents != null) { documents2.Delete(documents.ID); new RoadFlow.Platform.DocumentsReadUsers().Delete(documents.ID); RoadFlow.Platform.Log.Add("删除了文档", documents.Serialize(), RoadFlow.Platform.Log.Types.文档中心); return("1"); } return("未找到文档"); }
private List <RoadFlow.Data.Model.Documents> DataReaderToList(SqlDataReader dataReader) { List <RoadFlow.Data.Model.Documents> list = new List <RoadFlow.Data.Model.Documents>(); RoadFlow.Data.Model.Documents documents = null; while (dataReader.Read()) { documents = new RoadFlow.Data.Model.Documents(); documents.ID = dataReader.GetGuid(0); documents.DirectoryID = dataReader.GetGuid(1); documents.DirectoryName = dataReader.GetString(2); documents.Title = dataReader.GetString(3); documents.Source = dataReader.GetString(4); documents.Contents = dataReader.GetString(5); if (!dataReader.IsDBNull(6)) { documents.Files = dataReader.GetString(6); } documents.WriteTime = dataReader.GetDateTime(7); documents.WriteUserID = dataReader.GetGuid(8); documents.WriteUserName = dataReader.GetString(9); if (!dataReader.IsDBNull(10)) { documents.EditTime = dataReader.GetDateTime(10); } if (!dataReader.IsDBNull(11)) { documents.EditUserID = dataReader.GetGuid(11); } if (!dataReader.IsDBNull(12)) { documents.EditUserName = dataReader.GetString(12); } if (!dataReader.IsDBNull(13)) { documents.ReadUsers = dataReader.GetString(13); } documents.ReadCount = dataReader.GetInt32(14); list.Add(documents); } return(list); }
public ActionResult DocAdd(FormCollection collection) { string str = base.Request.QueryString["docid"]; RoadFlow.Platform.Documents documents = new RoadFlow.Platform.Documents(); RoadFlow.Platform.DocumentDirectory documentDirectory = new RoadFlow.Platform.DocumentDirectory(); RoadFlow.Platform.DocumentsReadUsers documentsReadUsers = new RoadFlow.Platform.DocumentsReadUsers(); RoadFlow.Data.Model.Documents documents2 = null; if (str.IsGuid()) { documents2 = documents.Get(str.ToGuid()); } if (collection != null) { string str2 = base.Request.Form["DirectoryID"]; string str3 = base.Request.Form["Title1"]; string readUsers = base.Request.Form["ReadUsers"]; string text = base.Request.Form["Source"]; string contents = base.Request.Form["Contents"]; string files = base.Request.Form["Files"]; string oldXML = string.Empty; bool flag = false; if (documents2 == null) { flag = true; documents2 = new RoadFlow.Data.Model.Documents(); documents2.ID = Guid.NewGuid(); documents2.ReadCount = 0; documents2.WriteTime = DateTimeNew.Now; documents2.WriteUserID = RoadFlow.Platform.Users.CurrentUserID; documents2.WriteUserName = RoadFlow.Platform.Users.CurrentUserName; } else { oldXML = documents2.Serialize(); } documents2.Contents = contents; documents2.DirectoryID = str2.ToGuid(); documents2.DirectoryName = documentDirectory.GetName(documents2.DirectoryID); documents2.EditTime = DateTimeNew.Now; documents2.EditUserID = RoadFlow.Platform.Users.CurrentUserID; documents2.EditUserName = RoadFlow.Platform.Users.CurrentUserName; documents2.Files = files; documents2.ReadUsers = readUsers; documents2.Source = (text.IsNullOrEmpty() ? " " : text); documents2.Title = str3.Trim1(); if (flag) { documents.Add(documents2); RoadFlow.Platform.Log.Add("添加了文档", documents2.Serialize(), RoadFlow.Platform.Log.Types.文档中心); } else { documents.Update(documents2); RoadFlow.Platform.Log.Add("修改了文档", documents2.Serialize(), RoadFlow.Platform.Log.Types.文档中心, oldXML, documents2.Serialize()); } List <RoadFlow.Data.Model.Users> obj = documents2.ReadUsers.IsNullOrEmpty() ? documentDirectory.GetReadUsers(documents2.DirectoryID) : new RoadFlow.Platform.Organize().GetAllUsers(documents2.ReadUsers); documentsReadUsers.Delete(documents2.ID); bool isUse = RoadFlow.Platform.WeiXin.Config.IsUse; Message message = new Message(); StringBuilder stringBuilder = new StringBuilder(); foreach (RoadFlow.Data.Model.Users item in obj) { RoadFlow.Data.Model.DocumentsReadUsers documentsReadUsers2 = new RoadFlow.Data.Model.DocumentsReadUsers(); documentsReadUsers2.DocumentID = documents2.ID; documentsReadUsers2.IsRead = 0; documentsReadUsers2.UserID = item.ID; documentsReadUsers.Add(documentsReadUsers2); if (isUse) { stringBuilder.Append(item.Account); stringBuilder.Append('|'); } } string empty = string.Empty; empty = ((!flag) ? ("'DocRead" + base.Request.Url.Query + "'") : ("'List" + base.Request.Url.Query + "'")); if (isUse) { message.SendText(documents2.Title, stringBuilder.ToString().TrimEnd('|'), "", "", 0, new Agents().GetAgentIDByCode("weixinagents_documents"), true); } base.ViewBag.script = "alert('保存成功!');window.location=" + empty + ";"; } if (documents2 == null) { documents2 = new RoadFlow.Data.Model.Documents(); } return(View(documents2)); }
public int Add(RoadFlow.Data.Model.Documents model) { string sql = "INSERT INTO Documents\r\n\t\t\t\t(ID,DirectoryID,DirectoryName,Title,Source,Contents,Files,WriteTime,WriteUserID,WriteUserName,EditTime,EditUserID,EditUserName,ReadUsers,ReadCount) \r\n\t\t\t\tVALUES(@ID,@DirectoryID,@DirectoryName,@Title,@Source,@Contents,@Files,@WriteTime,@WriteUserID,@WriteUserName,@EditTime,@EditUserID,@EditUserName,@ReadUsers,@ReadCount)"; SqlParameter[] parameter = new SqlParameter[15] { new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID }, new SqlParameter("@DirectoryID", SqlDbType.UniqueIdentifier, -1) { Value = model.DirectoryID }, new SqlParameter("@DirectoryName", SqlDbType.NVarChar, 400) { Value = model.DirectoryName }, new SqlParameter("@Title", SqlDbType.NVarChar, 600) { Value = model.Title }, new SqlParameter("@Source", SqlDbType.NVarChar, 100) { Value = model.Source }, new SqlParameter("@Contents", SqlDbType.VarChar, -1) { Value = model.Contents }, (model.Files == null) ? new SqlParameter("@Files", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@Files", SqlDbType.VarChar, -1) { Value = model.Files }, new SqlParameter("@WriteTime", SqlDbType.DateTime, 8) { Value = model.WriteTime }, new SqlParameter("@WriteUserID", SqlDbType.UniqueIdentifier, -1) { Value = model.WriteUserID }, new SqlParameter("@WriteUserName", SqlDbType.NVarChar, 100) { Value = model.WriteUserName }, (!model.EditTime.HasValue) ? new SqlParameter("@EditTime", SqlDbType.DateTime, 8) { Value = DBNull.Value } : new SqlParameter("@EditTime", SqlDbType.DateTime, 8) { Value = model.EditTime }, (!model.EditUserID.HasValue) ? new SqlParameter("@EditUserID", SqlDbType.UniqueIdentifier, -1) { Value = DBNull.Value } : new SqlParameter("@EditUserID", SqlDbType.UniqueIdentifier, -1) { Value = model.EditUserID }, (model.EditUserName == null) ? new SqlParameter("@EditUserName", SqlDbType.NVarChar, 100) { Value = DBNull.Value } : new SqlParameter("@EditUserName", SqlDbType.NVarChar, 100) { Value = model.EditUserName }, (model.ReadUsers == null) ? new SqlParameter("@ReadUsers", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@ReadUsers", SqlDbType.VarChar, -1) { Value = model.ReadUsers }, new SqlParameter("@ReadCount", SqlDbType.Int, -1) { Value = model.ReadCount } }; return(dbHelper.Execute(sql, parameter)); }
public int Update(RoadFlow.Data.Model.Documents model) { string sql = "UPDATE Documents SET \r\n\t\t\t\tDirectoryID=@DirectoryID,DirectoryName=@DirectoryName,Title=@Title,Source=@Source,Contents=@Contents,Files=@Files,WriteTime=@WriteTime,WriteUserID=@WriteUserID,WriteUserName=@WriteUserName,EditTime=@EditTime,EditUserID=@EditUserID,EditUserName=@EditUserName,ReadUsers=@ReadUsers,ReadCount=@ReadCount\r\n\t\t\t\tWHERE ID=@ID"; SqlParameter[] parameter = new SqlParameter[15] { new SqlParameter("@DirectoryID", SqlDbType.UniqueIdentifier, -1) { Value = model.DirectoryID }, new SqlParameter("@DirectoryName", SqlDbType.NVarChar, 400) { Value = model.DirectoryName }, new SqlParameter("@Title", SqlDbType.NVarChar, 600) { Value = model.Title }, new SqlParameter("@Source", SqlDbType.NVarChar, 100) { Value = model.Source }, new SqlParameter("@Contents", SqlDbType.VarChar, -1) { Value = model.Contents }, (model.Files == null) ? new SqlParameter("@Files", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@Files", SqlDbType.VarChar, -1) { Value = model.Files }, new SqlParameter("@WriteTime", SqlDbType.DateTime, 8) { Value = model.WriteTime }, new SqlParameter("@WriteUserID", SqlDbType.UniqueIdentifier, -1) { Value = model.WriteUserID }, new SqlParameter("@WriteUserName", SqlDbType.NVarChar, 100) { Value = model.WriteUserName }, (!model.EditTime.HasValue) ? new SqlParameter("@EditTime", SqlDbType.DateTime, 8) { Value = DBNull.Value } : new SqlParameter("@EditTime", SqlDbType.DateTime, 8) { Value = model.EditTime }, (!model.EditUserID.HasValue) ? new SqlParameter("@EditUserID", SqlDbType.UniqueIdentifier, -1) { Value = DBNull.Value } : new SqlParameter("@EditUserID", SqlDbType.UniqueIdentifier, -1) { Value = model.EditUserID }, (model.EditUserName == null) ? new SqlParameter("@EditUserName", SqlDbType.NVarChar, 100) { Value = DBNull.Value } : new SqlParameter("@EditUserName", SqlDbType.NVarChar, 100) { Value = model.EditUserName }, (model.ReadUsers == null) ? new SqlParameter("@ReadUsers", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@ReadUsers", SqlDbType.VarChar, -1) { Value = model.ReadUsers }, new SqlParameter("@ReadCount", SqlDbType.Int, -1) { Value = model.ReadCount }, new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID } }; return(dbHelper.Execute(sql, parameter)); }
public int Update(RoadFlow.Data.Model.Documents model) { return(dataDocuments.Update(model)); }
public int Add(RoadFlow.Data.Model.Documents model) { return(dataDocuments.Add(model)); }
public int Update(RoadFlow.Data.Model.Documents 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_0043: Unknown result type (might be due to invalid IL or missing references) //IL_0048: Unknown result type (might be due to invalid IL or missing references) //IL_0054: Expected O, but got Unknown //IL_0055: Expected O, but got Unknown //IL_0062: Unknown result type (might be due to invalid IL or missing references) //IL_0067: Unknown result type (might be due to invalid IL or missing references) //IL_0073: Expected O, but got Unknown //IL_0074: Expected O, but got Unknown //IL_0082: Unknown result type (might be due to invalid IL or missing references) //IL_0087: Unknown result type (might be due to invalid IL or missing references) //IL_0093: Expected O, but got Unknown //IL_0094: Expected O, but got Unknown //IL_00a1: Unknown result type (might be due to invalid IL or missing references) //IL_00a6: Unknown result type (might be due to invalid IL or missing references) //IL_00b2: Expected O, but got Unknown //IL_00b3: Expected O, but got Unknown //IL_00c8: Unknown result type (might be due to invalid IL or missing references) //IL_00cd: Unknown result type (might be due to invalid IL or missing references) //IL_00d9: 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_00f6: Expected O, but got Unknown //IL_00f7: Expected O, but got Unknown //IL_0101: Unknown result type (might be due to invalid IL or missing references) //IL_0106: Unknown result type (might be due to invalid IL or missing references) //IL_0117: Expected O, but got Unknown //IL_0118: Expected O, but got Unknown //IL_0126: Unknown result type (might be due to invalid IL or missing references) //IL_012b: Unknown result type (might be due to invalid IL or missing references) //IL_013c: Expected O, but got Unknown //IL_013d: Expected O, but got Unknown //IL_014b: Unknown result type (might be due to invalid IL or missing references) //IL_0150: Unknown result type (might be due to invalid IL or missing references) //IL_015c: Expected O, but got Unknown //IL_015d: Expected O, but got Unknown //IL_0178: Unknown result type (might be due to invalid IL or missing references) //IL_017d: Unknown result type (might be due to invalid IL or missing references) //IL_018e: Expected O, but got Unknown //IL_0198: Unknown result type (might be due to invalid IL or missing references) //IL_019d: Unknown result type (might be due to invalid IL or missing references) //IL_01a8: Expected O, but got Unknown //IL_01a9: Expected O, but got Unknown //IL_01c8: Unknown result type (might be due to invalid IL or missing references) //IL_01cd: Unknown result type (might be due to invalid IL or missing references) //IL_01de: Expected O, but got Unknown //IL_01ec: Unknown result type (might be due to invalid IL or missing references) //IL_01f1: Unknown result type (might be due to invalid IL or missing references) //IL_01fc: Expected O, but got Unknown //IL_01fd: Expected O, but got Unknown //IL_0214: Unknown result type (might be due to invalid IL or missing references) //IL_0219: Unknown result type (might be due to invalid IL or missing references) //IL_0225: Expected O, but got Unknown //IL_0233: Unknown result type (might be due to invalid IL or missing references) //IL_0238: Unknown result type (might be due to invalid IL or missing references) //IL_0243: Expected O, but got Unknown //IL_0244: Expected O, but got Unknown //IL_025a: Unknown result type (might be due to invalid IL or missing references) //IL_025f: Unknown result type (might be due to invalid IL or missing references) //IL_026b: Expected O, but got Unknown //IL_0278: Unknown result type (might be due to invalid IL or missing references) //IL_027d: Unknown result type (might be due to invalid IL or missing references) //IL_0288: Expected O, but got Unknown //IL_0289: 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_02aa: Expected O, but got Unknown //IL_02ab: 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_02d0: Expected O, but got Unknown //IL_02d1: Expected O, but got Unknown string sql = "UPDATE documents SET \r\n\t\t\t\tDirectoryID=@DirectoryID,DirectoryName=@DirectoryName,Title=@Title,Source=@Source,Contents=@Contents,Files=@Files,WriteTime=@WriteTime,WriteUserID=@WriteUserID,WriteUserName=@WriteUserName,EditTime=@EditTime,EditUserID=@EditUserID,EditUserName=@EditUserName,ReadUsers=@ReadUsers,ReadCount=@ReadCount\r\n\t\t\t\tWHERE ID=@ID"; MySqlParameter[] obj = new MySqlParameter[15]; MySqlParameter val = new MySqlParameter("@DirectoryID", 253, 36); ((DbParameter)val).Value = model.DirectoryID; obj[0] = val; MySqlParameter val2 = new MySqlParameter("@DirectoryName", 253, 200); ((DbParameter)val2).Value = model.DirectoryName; obj[1] = val2; MySqlParameter val3 = new MySqlParameter("@Title", 752, -1); ((DbParameter)val3).Value = model.Title; obj[2] = val3; MySqlParameter val4 = new MySqlParameter("@Source", 253, 50); ((DbParameter)val4).Value = model.Source; obj[3] = val4; MySqlParameter val5 = new MySqlParameter("@Contents", 751, -1); ((DbParameter)val5).Value = model.Contents; obj[4] = val5; _003F val6; if (model.Files != null) { val6 = new MySqlParameter("@Files", 751, -1); ((DbParameter)val6).Value = model.Files; } else { val6 = new MySqlParameter("@Files", 751, -1); ((DbParameter)val6).Value = DBNull.Value; } obj[5] = val6; MySqlParameter val7 = new MySqlParameter("@WriteTime", 12, -1); ((DbParameter)val7).Value = model.WriteTime; obj[6] = val7; MySqlParameter val8 = new MySqlParameter("@WriteUserID", 253, 36); ((DbParameter)val8).Value = model.WriteUserID; obj[7] = val8; MySqlParameter val9 = new MySqlParameter("@WriteUserName", 253, 50); ((DbParameter)val9).Value = model.WriteUserName; obj[8] = val9; _003F val10; if (model.EditTime.HasValue) { val10 = new MySqlParameter("@EditTime", 12, -1); ((DbParameter)val10).Value = model.EditTime; } else { val10 = new MySqlParameter("@EditTime", 12, -1); ((DbParameter)val10).Value = DBNull.Value; } obj[9] = val10; _003F val11; if (model.EditUserID.HasValue) { val11 = new MySqlParameter("@EditUserID", 253, 36); ((DbParameter)val11).Value = model.EditUserID; } else { val11 = new MySqlParameter("@EditUserID", 253, 36); ((DbParameter)val11).Value = DBNull.Value; } obj[10] = val11; _003F val12; if (model.EditUserName != null) { val12 = new MySqlParameter("@EditUserName", 253, 50); ((DbParameter)val12).Value = model.EditUserName; } else { val12 = new MySqlParameter("@EditUserName", 253, 50); ((DbParameter)val12).Value = DBNull.Value; } obj[11] = val12; _003F val13; if (model.ReadUsers != null) { val13 = new MySqlParameter("@ReadUsers", 751, -1); ((DbParameter)val13).Value = model.ReadUsers; } else { val13 = new MySqlParameter("@ReadUsers", 751, -1); ((DbParameter)val13).Value = DBNull.Value; } obj[12] = val13; MySqlParameter val14 = new MySqlParameter("@ReadCount", 3, 11); ((DbParameter)val14).Value = model.ReadCount; 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.Documents 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_0040: Unknown result type (might be due to invalid IL or missing references) //IL_0045: Unknown result type (might be due to invalid IL or missing references) //IL_0056: Expected O, but got Unknown //IL_0057: Expected O, but got Unknown //IL_0068: Unknown result type (might be due to invalid IL or missing references) //IL_006d: Unknown result type (might be due to invalid IL or missing references) //IL_0079: Expected O, but got Unknown //IL_007a: Expected O, but got Unknown //IL_0087: Unknown result type (might be due to invalid IL or missing references) //IL_008c: Unknown result type (might be due to invalid IL or missing references) //IL_0098: Expected O, but got Unknown //IL_0099: Expected O, but got Unknown //IL_00a7: Unknown result type (might be due to invalid IL or missing references) //IL_00ac: Unknown result type (might be due to invalid IL or missing references) //IL_00b8: Expected O, but got Unknown //IL_00b9: Expected O, but got Unknown //IL_00c6: Unknown result type (might be due to invalid IL or missing references) //IL_00cb: Unknown result type (might be due to invalid IL or missing references) //IL_00d7: Expected O, but got Unknown //IL_00d8: Expected O, but got Unknown //IL_00ed: Unknown result type (might be due to invalid IL or missing references) //IL_00f2: Unknown result type (might be due to invalid IL or missing references) //IL_00fe: 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_011b: Expected O, but got Unknown //IL_011c: Expected O, but got Unknown //IL_0126: Unknown result type (might be due to invalid IL or missing references) //IL_012b: Unknown result type (might be due to invalid IL or missing references) //IL_013c: Expected O, but got Unknown //IL_013d: Expected O, but got Unknown //IL_014b: Unknown result type (might be due to invalid IL or missing references) //IL_0150: Unknown result type (might be due to invalid IL or missing references) //IL_0161: Expected O, but got Unknown //IL_0162: 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_0183: Expected O, but got Unknown //IL_019e: Unknown result type (might be due to invalid IL or missing references) //IL_01a3: Unknown result type (might be due to invalid IL or missing references) //IL_01b4: Expected O, but got Unknown //IL_01be: Unknown result type (might be due to invalid IL or missing references) //IL_01c3: Unknown result type (might be due to invalid IL or missing references) //IL_01ce: Expected O, but got Unknown //IL_01cf: Expected O, but got Unknown //IL_01ee: Unknown result type (might be due to invalid IL or missing references) //IL_01f3: Unknown result type (might be due to invalid IL or missing references) //IL_0204: Expected O, but got Unknown //IL_0212: Unknown result type (might be due to invalid IL or missing references) //IL_0217: Unknown result type (might be due to invalid IL or missing references) //IL_0222: Expected O, but got Unknown //IL_0223: Expected O, but got Unknown //IL_023a: Unknown result type (might be due to invalid IL or missing references) //IL_023f: Unknown result type (might be due to invalid IL or missing references) //IL_024b: Expected O, but got Unknown //IL_0259: Unknown result type (might be due to invalid IL or missing references) //IL_025e: Unknown result type (might be due to invalid IL or missing references) //IL_0269: Expected O, but got Unknown //IL_026a: Expected O, but got Unknown //IL_0280: Unknown result type (might be due to invalid IL or missing references) //IL_0285: Unknown result type (might be due to invalid IL or missing references) //IL_0291: Expected O, but got Unknown //IL_029e: Unknown result type (might be due to invalid IL or missing references) //IL_02a3: Unknown result type (might be due to invalid IL or missing references) //IL_02ae: Expected O, but got Unknown //IL_02af: 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_02d0: Expected O, but got Unknown //IL_02d1: Expected O, but got Unknown string sql = "INSERT INTO documents\r\n\t\t\t\t(ID,DirectoryID,DirectoryName,Title,Source,Contents,Files,WriteTime,WriteUserID,WriteUserName,EditTime,EditUserID,EditUserName,ReadUsers,ReadCount) \r\n\t\t\t\tVALUES(@ID,@DirectoryID,@DirectoryName,@Title,@Source,@Contents,@Files,@WriteTime,@WriteUserID,@WriteUserName,@EditTime,@EditUserID,@EditUserName,@ReadUsers,@ReadCount)"; MySqlParameter[] obj = new MySqlParameter[15]; MySqlParameter val = new MySqlParameter("@ID", 253, 36); ((DbParameter)val).Value = model.ID; obj[0] = val; MySqlParameter val2 = new MySqlParameter("@DirectoryID", 253, 36); ((DbParameter)val2).Value = model.DirectoryID; obj[1] = val2; MySqlParameter val3 = new MySqlParameter("@DirectoryName", 253, 200); ((DbParameter)val3).Value = model.DirectoryName; obj[2] = val3; MySqlParameter val4 = new MySqlParameter("@Title", 752, -1); ((DbParameter)val4).Value = model.Title; obj[3] = val4; MySqlParameter val5 = new MySqlParameter("@Source", 253, 50); ((DbParameter)val5).Value = model.Source; obj[4] = val5; MySqlParameter val6 = new MySqlParameter("@Contents", 751, -1); ((DbParameter)val6).Value = model.Contents; obj[5] = val6; _003F val7; if (model.Files != null) { val7 = new MySqlParameter("@Files", 751, -1); ((DbParameter)val7).Value = model.Files; } else { val7 = new MySqlParameter("@Files", 751, -1); ((DbParameter)val7).Value = DBNull.Value; } obj[6] = val7; MySqlParameter val8 = new MySqlParameter("@WriteTime", 12, -1); ((DbParameter)val8).Value = model.WriteTime; obj[7] = val8; MySqlParameter val9 = new MySqlParameter("@WriteUserID", 253, 36); ((DbParameter)val9).Value = model.WriteUserID; obj[8] = val9; MySqlParameter val10 = new MySqlParameter("@WriteUserName", 253, 50); ((DbParameter)val10).Value = model.WriteUserName; obj[9] = val10; _003F val11; if (model.EditTime.HasValue) { val11 = new MySqlParameter("@EditTime", 12, -1); ((DbParameter)val11).Value = model.EditTime; } else { val11 = new MySqlParameter("@EditTime", 12, -1); ((DbParameter)val11).Value = DBNull.Value; } obj[10] = val11; _003F val12; if (model.EditUserID.HasValue) { val12 = new MySqlParameter("@EditUserID", 253, 36); ((DbParameter)val12).Value = model.EditUserID; } else { val12 = new MySqlParameter("@EditUserID", 253, 36); ((DbParameter)val12).Value = DBNull.Value; } obj[11] = val12; _003F val13; if (model.EditUserName != null) { val13 = new MySqlParameter("@EditUserName", 253, 50); ((DbParameter)val13).Value = model.EditUserName; } else { val13 = new MySqlParameter("@EditUserName", 253, 50); ((DbParameter)val13).Value = DBNull.Value; } obj[12] = val13; _003F val14; if (model.ReadUsers != null) { val14 = new MySqlParameter("@ReadUsers", 751, -1); ((DbParameter)val14).Value = model.ReadUsers; } else { val14 = new MySqlParameter("@ReadUsers", 751, -1); ((DbParameter)val14).Value = DBNull.Value; } obj[13] = val14; MySqlParameter val15 = new MySqlParameter("@ReadCount", 3, 11); ((DbParameter)val15).Value = model.ReadCount; obj[14] = val15; MySqlParameter[] parameter = (MySqlParameter[])obj; return(dbHelper.Execute(sql, parameter)); }