public bool SendToWeiXin(RoadFlow.Data.Model.ShortMessage msg, string userAccounts)
{
if (msg == null)
{
return(false);
}
Message message = new Message();
string[] imageUrlFromHtml = Tools.GetImageUrlFromHTML(msg.Contents);
int agentIdByCode = new Agents().GetAgentIDByCode("weixinagents_infocenter");
if (imageUrlFromHtml.Length != 0)
{
string str = RoadFlow.Platform.WeiXin.Config.WebUrl + imageUrlFromHtml[0];
message.SendNews(new List <Tuple <string, string, string, string> >()
{
new Tuple <string, string, string, string>(msg.Title, msg.Contents.RemoveHTML().CutString(100, "..."), RoadFlow.Platform.WeiXin.Config.WebUrl + RoadFlow.Utility.Config.BaseUrl + "/Platform/Info/ShortMessage/Show.aspx?id=" + msg.ID.ToString(), str)
}, userAccounts, "", "", agentIdByCode, false);
}
else
{
message.SendText(msg.Contents.RemoveHTML().CutString(100, "...") + "\n点击链接阅读全文：" + RoadFlow.Platform.WeiXin.Config.WebUrl + RoadFlow.Utility.Config.BaseUrl + "Platform/Info/ShortMessage/Show.aspx?id=" + msg.ID.ToString(), userAccounts, "", "", 0, agentIdByCode, false);
}
return(true);
}
public string Delete()
{
string str1 = this.Request.Form["ids"] ?? "";
RoadFlow.Platform.ShortMessage shortMessage1 = new RoadFlow.Platform.ShortMessage();
if (str1.IsNullOrEmpty())
{
return("没有选择要删除的消息!");
}
string str2 = str1;
char[] chArray = new char[1] {
','
};
foreach (string str3 in str2.Split(chArray))
{
if (str3.IsGuid())
{
RoadFlow.Data.Model.ShortMessage shortMessage2 = shortMessage1.Get(str3.ToGuid());
if (shortMessage2 != null)
{
shortMessage1.Delete(shortMessage2.ID);
RoadFlow.Platform.Log.Add("删除了站内消息", shortMessage2.Serialize(), RoadFlow.Platform.Log.Types.信息管理, "", "", (RoadFlow.Data.Model.Users)null);
}
}
}
return("操作成功!");
}
public static Guid Send(Guid userID, string userName, string title, string contents, int msgType = 0, string linkUrl = "", string linkID = "", string msgID = "")
{
if (userID.IsEmptyGuid() || title.IsNullOrEmpty() || contents.IsNullOrEmpty())
{
return(Guid.Empty);
}
if (userName.IsNullOrEmpty())
{
userName = new Users().GetName(userID);
}
RoadFlow.Data.Model.ShortMessage model = new RoadFlow.Data.Model.ShortMessage();
model.Contents = contents;
model.ID = msgID.IsGuid() ? msgID.ToGuid() : Guid.NewGuid();
model.LinkID = linkID;
model.LinkUrl = linkUrl;
model.ReceiveUserID = userID;
model.ReceiveUserName = userName;
model.SendTime = DateTimeNew.Now;
model.SendUserID = Users.CurrentUserID;
model.SendUserName = Users.CurrentUserName;
model.Status = 0;
model.Title = title;
model.Type = msgType;
new ShortMessage().Add(model);
string empty = string.Empty;
string contents1;
if (!linkUrl.IsNullOrEmpty())
{
contents1 = "<a class=\"blue1\" href=\"" + linkUrl + "\">" + model.Contents + "</a>";
}
else
{
contents1 = model.Contents;
}
ShortMessage.SiganalR(userID, model.ID.ToString(), title, contents1);
return(model.ID);
}
private List <RoadFlow.Data.Model.ShortMessage> DataReaderToList(SqlDataReader dataReader)
{
List <RoadFlow.Data.Model.ShortMessage> shortMessageList = new List <RoadFlow.Data.Model.ShortMessage>();
while (dataReader.Read())
{
RoadFlow.Data.Model.ShortMessage shortMessage = new RoadFlow.Data.Model.ShortMessage();
shortMessage.ID = dataReader.GetGuid(0);
shortMessage.Title = dataReader.GetString(1);
if (!dataReader.IsDBNull(2))
{
shortMessage.Contents = dataReader.GetString(2);
}
shortMessage.SendUserID = dataReader.GetGuid(3);
shortMessage.SendUserName = dataReader.GetString(4);
shortMessage.ReceiveUserID = dataReader.GetGuid(5);
shortMessage.ReceiveUserName = dataReader.GetString(6);
shortMessage.SendTime = dataReader.GetDateTime(7);
if (!dataReader.IsDBNull(8))
{
shortMessage.LinkUrl = dataReader.GetString(8);
}
if (!dataReader.IsDBNull(9))
{
shortMessage.LinkID = dataReader.GetString(9);
}
shortMessage.Type = dataReader.GetInt32(10);
if (!dataReader.IsDBNull(11))
{
shortMessage.Files = dataReader.GetString(11);
}
shortMessage.Status = dataReader.FieldCount <= 11 ? 0 : dataReader.GetInt32(12);
shortMessageList.Add(shortMessage);
}
return(shortMessageList);
}
public ActionResult Send(FormCollection collection)
{
if (collection != null)
{
string str1 = this.Request.Form["Title1"];
string str2 = this.Request.Form["Contents"];
string str3 = this.Request.Form["ReceiveUserID"];
string str4 = this.Request.Form["Files"];
string str5 = this.Request.Form["sendtoseixin"];
if (str1.IsNullOrEmpty() || str2.IsNullOrEmpty() || str3.IsNullOrEmpty())
{
// ISSUE: reference to a compiler-generated field
if (ShortMessageController.\u003C\u003Eo__6.\u003C\u003Ep__0 == null)
{
// ISSUE: reference to a compiler-generated field
ShortMessageController.\u003C\u003Eo__6.\u003C\u003Ep__0 = CallSite <Func <CallSite, object, string, object> > .Create(Binder.SetMember(CSharpBinderFlags.None, "script", typeof(ShortMessageController), (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 = ShortMessageController.\u003C\u003Eo__6.\u003C\u003Ep__0.Target((CallSite)ShortMessageController.\u003C\u003Eo__6.\u003C\u003Ep__0, this.ViewBag, "alert('数据验证错误!')");
return((ActionResult)this.View());
}
List <RoadFlow.Data.Model.Users> allUsers = new RoadFlow.Platform.Organize().GetAllUsers(str3);
StringBuilder stringBuilder1 = new StringBuilder();
StringBuilder stringBuilder2 = new StringBuilder();
RoadFlow.Data.Model.ShortMessage msg = (RoadFlow.Data.Model.ShortMessage)null;
RoadFlow.Platform.ShortMessage shortMessage = new RoadFlow.Platform.ShortMessage();
foreach (RoadFlow.Data.Model.Users users in allUsers)
{
RoadFlow.Data.Model.ShortMessage model = new RoadFlow.Data.Model.ShortMessage();
model.Contents = str2;
model.ID = Guid.NewGuid();
model.ReceiveUserID = users.ID;
model.ReceiveUserName = users.Name;
model.SendTime = DateTimeNew.Now;
model.SendUserID = RoadFlow.Platform.Users.CurrentUserID;
model.SendUserName = RoadFlow.Platform.Users.CurrentUserName;
model.Status = 0;
model.Title = str1;
model.Type = 0;
model.Files = str4;
shortMessage.Add(model);
RoadFlow.Platform.ShortMessage.SiganalR(users.ID, model.ID.ToString(), str1, str2.RemoveHTML());
stringBuilder1.Append(users.Name);
stringBuilder1.Append(",");
stringBuilder2.Append(users.Account);
stringBuilder2.Append('|');
if (msg == null)
{
msg = model;
}
}
if ("1" == str5 && msg != null && stringBuilder2.Length > 0)
{
shortMessage.SendToWeiXin(msg, stringBuilder2.ToString().TrimEnd('|'));
}
// ISSUE: reference to a compiler-generated field
if (ShortMessageController.\u003C\u003Eo__6.\u003C\u003Ep__1 == null)
{
// ISSUE: reference to a compiler-generated field
ShortMessageController.\u003C\u003Eo__6.\u003C\u003Ep__1 = CallSite <Func <CallSite, object, string, object> > .Create(Binder.SetMember(CSharpBinderFlags.None, "script", typeof(ShortMessageController), (IEnumerable <CSharpArgumentInfo>) new CSharpArgumentInfo[2]
{
CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, (string)null),
CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.UseCompileTimeType, (string)null)
}));
}
// ISSUE: reference to a compiler-generated field
// ISSUE: reference to a compiler-generated field
object obj1 = ShortMessageController.\u003C\u003Eo__6.\u003C\u003Ep__1.Target((CallSite)ShortMessageController.\u003C\u003Eo__6.\u003C\u003Ep__1, this.ViewBag, string.Format("alert('成功将消息发送给了：{0}!');window.location=window.location;", (object)stringBuilder1.ToString()));
}
return((ActionResult)this.View());
}
public int Add(RoadFlow.Data.Model.ShortMessage model)
{
string sql = "INSERT INTO ShortMessage\r\n\t\t\t\t(ID,Title,Contents,SendUserID,SendUserName,ReceiveUserID,ReceiveUserName,SendTime,LinkUrl,LinkID,Type,Files) \r\n\t\t\t\tVALUES(@ID,@Title,@Contents,@SendUserID,@SendUserName,@ReceiveUserID,@ReceiveUserName,@SendTime,@LinkUrl,@LinkID,@Type,@Files)";
SqlParameter[] sqlParameterArray = new SqlParameter[12];
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("@Title", SqlDbType.NVarChar, 1000);
sqlParameter2.Value = (object)model.Title;
sqlParameterArray[index2] = sqlParameter2;
int index3 = 2;
SqlParameter sqlParameter3;
if (model.Contents != null)
{
SqlParameter sqlParameter4 = new SqlParameter("@Contents", SqlDbType.NVarChar, -1);
sqlParameter4.Value = (object)model.Contents;
sqlParameter3 = sqlParameter4;
}
else
{
sqlParameter3 = new SqlParameter("@Contents", SqlDbType.NVarChar, -1);
sqlParameter3.Value = (object)DBNull.Value;
}
sqlParameterArray[index3] = sqlParameter3;
int index4 = 3;
SqlParameter sqlParameter5 = new SqlParameter("@SendUserID", SqlDbType.UniqueIdentifier, -1);
sqlParameter5.Value = (object)model.SendUserID;
sqlParameterArray[index4] = sqlParameter5;
int index5 = 4;
SqlParameter sqlParameter6 = new SqlParameter("@SendUserName", SqlDbType.NVarChar, 1000);
sqlParameter6.Value = (object)model.SendUserName;
sqlParameterArray[index5] = sqlParameter6;
int index6 = 5;
SqlParameter sqlParameter7 = new SqlParameter("@ReceiveUserID", SqlDbType.UniqueIdentifier, -1);
sqlParameter7.Value = (object)model.ReceiveUserID;
sqlParameterArray[index6] = sqlParameter7;
int index7 = 6;
SqlParameter sqlParameter8 = new SqlParameter("@ReceiveUserName", SqlDbType.NVarChar, 1000);
sqlParameter8.Value = (object)model.ReceiveUserName;
sqlParameterArray[index7] = sqlParameter8;
int index8 = 7;
SqlParameter sqlParameter9 = new SqlParameter("@SendTime", SqlDbType.DateTime, 8);
sqlParameter9.Value = (object)model.SendTime;
sqlParameterArray[index8] = sqlParameter9;
int index9 = 8;
SqlParameter sqlParameter10;
if (model.LinkUrl != null)
{
SqlParameter sqlParameter4 = new SqlParameter("@LinkUrl", SqlDbType.VarChar, -1);
sqlParameter4.Value = (object)model.LinkUrl;
sqlParameter10 = sqlParameter4;
}
else
{
sqlParameter10 = new SqlParameter("@LinkUrl", SqlDbType.VarChar, -1);
sqlParameter10.Value = (object)DBNull.Value;
}
sqlParameterArray[index9] = sqlParameter10;
int index10 = 9;
SqlParameter sqlParameter11;
if (model.LinkID != null)
{
SqlParameter sqlParameter4 = new SqlParameter("@LinkID", SqlDbType.VarChar, 50);
sqlParameter4.Value = (object)model.LinkID;
sqlParameter11 = sqlParameter4;
}
else
{
sqlParameter11 = new SqlParameter("@LinkID", SqlDbType.VarChar, 50);
sqlParameter11.Value = (object)DBNull.Value;
}
sqlParameterArray[index10] = sqlParameter11;
int index11 = 10;
SqlParameter sqlParameter12 = new SqlParameter("@Type", SqlDbType.Int, -1);
sqlParameter12.Value = (object)model.Type;
sqlParameterArray[index11] = sqlParameter12;
int index12 = 11;
SqlParameter sqlParameter13;
if (model.Files != null)
{
SqlParameter sqlParameter4 = new SqlParameter("@Files", SqlDbType.VarChar, -1);
sqlParameter4.Value = (object)model.Files;
sqlParameter13 = sqlParameter4;
}
else
{
sqlParameter13 = new SqlParameter("@Files", SqlDbType.VarChar, -1);
sqlParameter13.Value = (object)DBNull.Value;
}
sqlParameterArray[index12] = sqlParameter13;
SqlParameter[] parameter = sqlParameterArray;
return(this.dbHelper.Execute(sql, parameter, false));
}
public int Add(RoadFlow.Data.Model.ShortMessage model)
{
string sql = "INSERT INTO ShortMessage\r\n\t\t\t\t(ID,Title,Contents,SendUserID,SendUserName,ReceiveUserID,ReceiveUserName,SendTime,LinkUrl,LinkID,Type,Files) \r\n\t\t\t\tVALUES(:ID,:Title,:Contents,:SendUserID,:SendUserName,:ReceiveUserID,:ReceiveUserName,:SendTime,:LinkUrl,:LinkID,:Type,:Files)";
OracleParameter[] oracleParameterArray = new OracleParameter[12];
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(":Title", OracleDbType.NVarchar2);
oracleParameter2.Value = (object)model.Title;
oracleParameterArray[index2] = oracleParameter2;
int index3 = 2;
OracleParameter oracleParameter3;
if (model.Contents != null)
{
OracleParameter oracleParameter4 = new OracleParameter(":Contents", OracleDbType.NVarchar2);
oracleParameter4.Value = (object)model.Contents;
oracleParameter3 = oracleParameter4;
}
else
{
oracleParameter3 = new OracleParameter(":Contents", OracleDbType.NVarchar2);
oracleParameter3.Value = (object)DBNull.Value;
}
oracleParameterArray[index3] = oracleParameter3;
int index4 = 3;
OracleParameter oracleParameter5 = new OracleParameter(":SendUserID", OracleDbType.Varchar2);
oracleParameter5.Value = (object)model.SendUserID;
oracleParameterArray[index4] = oracleParameter5;
int index5 = 4;
OracleParameter oracleParameter6 = new OracleParameter(":SendUserName", OracleDbType.NVarchar2);
oracleParameter6.Value = (object)model.SendUserName;
oracleParameterArray[index5] = oracleParameter6;
int index6 = 5;
OracleParameter oracleParameter7 = new OracleParameter(":ReceiveUserID", OracleDbType.Varchar2);
oracleParameter7.Value = (object)model.ReceiveUserID;
oracleParameterArray[index6] = oracleParameter7;
int index7 = 6;
OracleParameter oracleParameter8 = new OracleParameter(":ReceiveUserName", OracleDbType.NVarchar2);
oracleParameter8.Value = (object)model.ReceiveUserName;
oracleParameterArray[index7] = oracleParameter8;
int index8 = 7;
OracleParameter oracleParameter9 = new OracleParameter(":SendTime", OracleDbType.Date);
oracleParameter9.Value = (object)model.SendTime;
oracleParameterArray[index8] = oracleParameter9;
int index9 = 8;
OracleParameter oracleParameter10;
if (model.LinkUrl != null)
{
OracleParameter oracleParameter4 = new OracleParameter(":LinkUrl", OracleDbType.Varchar2);
oracleParameter4.Value = (object)model.LinkUrl;
oracleParameter10 = oracleParameter4;
}
else
{
oracleParameter10 = new OracleParameter(":LinkUrl", OracleDbType.Varchar2);
oracleParameter10.Value = (object)DBNull.Value;
}
oracleParameterArray[index9] = oracleParameter10;
int index10 = 9;
OracleParameter oracleParameter11;
if (model.LinkID != null)
{
OracleParameter oracleParameter4 = new OracleParameter(":LinkID", OracleDbType.Varchar2);
oracleParameter4.Value = (object)model.LinkID;
oracleParameter11 = oracleParameter4;
}
else
{
oracleParameter11 = new OracleParameter(":LinkID", OracleDbType.Varchar2);
oracleParameter11.Value = (object)DBNull.Value;
}
oracleParameterArray[index10] = oracleParameter11;
int index11 = 10;
OracleParameter oracleParameter12 = new OracleParameter(":Type", OracleDbType.Int32);
oracleParameter12.Value = (object)model.Type;
oracleParameterArray[index11] = oracleParameter12;
int index12 = 11;
OracleParameter oracleParameter13 = new OracleParameter(":Files", OracleDbType.Varchar2);
oracleParameter13.Value = (object)model.Files;
oracleParameterArray[index12] = oracleParameter13;
OracleParameter[] parameter = oracleParameterArray;
return(this.dbHelper.Execute(sql, parameter));
}
public ActionResult Index()
{
RoadFlow.Data.Model.Users currentUser = MyController.CurrentUser;
// ISSUE: reference to a compiler-generated field
if (HomeController.\u003C\u003Eo__0.\u003C\u003Ep__0 == null)
{
// ISSUE: reference to a compiler-generated field
HomeController.\u003C\u003Eo__0.\u003C\u003Ep__0 = CallSite <Func <CallSite, object, string, object> > .Create(Binder.SetMember(CSharpBinderFlags.None, "UserName", typeof(HomeController), (IEnumerable <CSharpArgumentInfo>) new CSharpArgumentInfo[2]
{
CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, (string)null),
CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.UseCompileTimeType, (string)null)
}));
}
// ISSUE: reference to a compiler-generated field
// ISSUE: reference to a compiler-generated field
object obj1 = HomeController.\u003C\u003Eo__0.\u003C\u003Ep__0.Target((CallSite)HomeController.\u003C\u003Eo__0.\u003C\u003Ep__0, this.ViewBag, currentUser == null ? "" : currentUser.Name);
// ISSUE: reference to a compiler-generated field
if (HomeController.\u003C\u003Eo__0.\u003C\u003Ep__1 == null)
{
// ISSUE: reference to a compiler-generated field
HomeController.\u003C\u003Eo__0.\u003C\u003Ep__1 = CallSite <Func <CallSite, object, string, object> > .Create(Binder.SetMember(CSharpBinderFlags.None, "DateTime", typeof(HomeController), (IEnumerable <CSharpArgumentInfo>) new CSharpArgumentInfo[2]
{
CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, (string)null),
CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.UseCompileTimeType, (string)null)
}));
}
// ISSUE: reference to a compiler-generated field
// ISSUE: reference to a compiler-generated field
object obj2 = HomeController.\u003C\u003Eo__0.\u003C\u003Ep__1.Target((CallSite)HomeController.\u003C\u003Eo__0.\u003C\u003Ep__1, this.ViewBag, MyController.CurrentDateTime.ToDateWeekString());
List <RoadFlow.Data.Model.ShortMessage> allNoReadByUserId = new RoadFlow.Platform.ShortMessage().GetAllNoReadByUserID(currentUser.ID);
if (allNoReadByUserId.Count > 0)
{
JsonData jsonData = new JsonData();
string empty = string.Empty;
RoadFlow.Data.Model.ShortMessage shortMessage = allNoReadByUserId.OrderByDescending <RoadFlow.Data.Model.ShortMessage, DateTime>((Func <RoadFlow.Data.Model.ShortMessage, DateTime>)(p => p.SendTime)).FirstOrDefault <RoadFlow.Data.Model.ShortMessage>();
string str;
if (!shortMessage.LinkUrl.IsNullOrEmpty())
{
str = "<a class=\"blue1\" href=\"" + shortMessage.LinkUrl + "\">" + shortMessage.Contents.RemoveHTML() + "</a>";
}
else
{
str = shortMessage.Contents.RemoveHTML();
}
jsonData["title"] = (JsonData)shortMessage.Title;
jsonData["contents"] = (JsonData)str;
jsonData["count"] = (JsonData)allNoReadByUserId.Count;
// ISSUE: reference to a compiler-generated field
if (HomeController.\u003C\u003Eo__0.\u003C\u003Ep__2 == null)
{
// ISSUE: reference to a compiler-generated field
HomeController.\u003C\u003Eo__0.\u003C\u003Ep__2 = CallSite <Func <CallSite, object, string, object> > .Create(Binder.SetMember(CSharpBinderFlags.None, "NoReadMsgJson", typeof(HomeController), (IEnumerable <CSharpArgumentInfo>) new CSharpArgumentInfo[2]
{
CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, (string)null),
CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.UseCompileTimeType, (string)null)
}));
}
// ISSUE: reference to a compiler-generated field
// ISSUE: reference to a compiler-generated field
object obj3 = HomeController.\u003C\u003Eo__0.\u003C\u003Ep__2.Target((CallSite)HomeController.\u003C\u003Eo__0.\u003C\u003Ep__2, this.ViewBag, jsonData.ToJson(true));
}
string str1 = this.Url.Content("~/Content/UserHeads/default.jpg");
if (!currentUser.HeadImg.IsNullOrEmpty() && File.Exists(this.Server.MapPath(this.Url.Content("~" + currentUser.HeadImg))))
{
str1 = this.Url.Content("~" + currentUser.HeadImg);
}
// ISSUE: reference to a compiler-generated field
if (HomeController.\u003C\u003Eo__0.\u003C\u003Ep__3 == null)
{
// ISSUE: reference to a compiler-generated field
HomeController.\u003C\u003Eo__0.\u003C\u003Ep__3 = CallSite <Func <CallSite, object, string, object> > .Create(Binder.SetMember(CSharpBinderFlags.None, "HeadImg", typeof(HomeController), (IEnumerable <CSharpArgumentInfo>) new CSharpArgumentInfo[2]
{
CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, (string)null),
CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.UseCompileTimeType, (string)null)
}));
}
// ISSUE: reference to a compiler-generated field
// ISSUE: reference to a compiler-generated field
object obj4 = HomeController.\u003C\u003Eo__0.\u003C\u003Ep__3.Target((CallSite)HomeController.\u003C\u003Eo__0.\u003C\u003Ep__3, this.ViewBag, str1);
return((ActionResult)this.View());
}
public int Add(RoadFlow.Data.Model.ShortMessage model)
{
string sql = "INSERT INTO shortmessage\r\n\t\t\t\t(ID,Title,Contents,SendUserID,SendUserName,ReceiveUserID,ReceiveUserName,SendTime,LinkUrl,LinkID,Type,Files) \r\n\t\t\t\tVALUES(@ID,@Title,@Contents,@SendUserID,@SendUserName,@ReceiveUserID,@ReceiveUserName,@SendTime,@LinkUrl,@LinkID,@Type,@Files)";
MySqlParameter[] mySqlParameterArray = new MySqlParameter[12];
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("@Title", MySqlDbType.Text, -1);
mySqlParameter2.Value = (object)model.Title;
mySqlParameterArray[index2] = mySqlParameter2;
int index3 = 2;
MySqlParameter mySqlParameter3;
if (model.Contents != null)
{
MySqlParameter mySqlParameter4 = new MySqlParameter("@Contents", MySqlDbType.VarChar, 4000);
mySqlParameter4.Value = (object)model.Contents;
mySqlParameter3 = mySqlParameter4;
}
else
{
mySqlParameter3 = new MySqlParameter("@Contents", MySqlDbType.VarChar, 4000);
mySqlParameter3.Value = (object)DBNull.Value;
}
mySqlParameterArray[index3] = mySqlParameter3;
int index4 = 3;
MySqlParameter mySqlParameter5 = new MySqlParameter("@SendUserID", MySqlDbType.VarChar, 36);
mySqlParameter5.Value = (object)model.SendUserID;
mySqlParameterArray[index4] = mySqlParameter5;
int index5 = 4;
MySqlParameter mySqlParameter6 = new MySqlParameter("@SendUserName", MySqlDbType.Text, -1);
mySqlParameter6.Value = (object)model.SendUserName;
mySqlParameterArray[index5] = mySqlParameter6;
int index6 = 5;
MySqlParameter mySqlParameter7 = new MySqlParameter("@ReceiveUserID", MySqlDbType.VarChar, 36);
mySqlParameter7.Value = (object)model.ReceiveUserID;
mySqlParameterArray[index6] = mySqlParameter7;
int index7 = 6;
MySqlParameter mySqlParameter8 = new MySqlParameter("@ReceiveUserName", MySqlDbType.Text, -1);
mySqlParameter8.Value = (object)model.ReceiveUserName;
mySqlParameterArray[index7] = mySqlParameter8;
int index8 = 7;
MySqlParameter mySqlParameter9 = new MySqlParameter("@SendTime", MySqlDbType.DateTime, -1);
mySqlParameter9.Value = (object)model.SendTime;
mySqlParameterArray[index8] = mySqlParameter9;
int index9 = 8;
MySqlParameter mySqlParameter10;
if (model.LinkUrl != null)
{
MySqlParameter mySqlParameter4 = new MySqlParameter("@LinkUrl", MySqlDbType.VarChar, 2000);
mySqlParameter4.Value = (object)model.LinkUrl;
mySqlParameter10 = mySqlParameter4;
}
else
{
mySqlParameter10 = new MySqlParameter("@LinkUrl", MySqlDbType.VarChar, 2000);
mySqlParameter10.Value = (object)DBNull.Value;
}
mySqlParameterArray[index9] = mySqlParameter10;
int index10 = 9;
MySqlParameter mySqlParameter11;
if (model.LinkID != null)
{
MySqlParameter mySqlParameter4 = new MySqlParameter("@LinkID", MySqlDbType.VarChar, 50);
mySqlParameter4.Value = (object)model.LinkID;
mySqlParameter11 = mySqlParameter4;
}
else
{
mySqlParameter11 = new MySqlParameter("@LinkID", MySqlDbType.VarChar, 50);
mySqlParameter11.Value = (object)DBNull.Value;
}
mySqlParameterArray[index10] = mySqlParameter11;
int index11 = 10;
MySqlParameter mySqlParameter12 = new MySqlParameter("@Type", MySqlDbType.Int32, 11);
mySqlParameter12.Value = (object)model.Type;
mySqlParameterArray[index11] = mySqlParameter12;
int index12 = 11;
MySqlParameter mySqlParameter13 = new MySqlParameter("@Files", MySqlDbType.Text, -1);
mySqlParameter13.Value = (object)model.Files;
mySqlParameterArray[index12] = mySqlParameter13;
MySqlParameter[] parameter = mySqlParameterArray;
return(this.dbHelper.Execute(sql, parameter, false));
}
public int Update(RoadFlow.Data.Model.ShortMessage model)
{
return(this.dataShortMessage.Update(model));
}
public int Add(RoadFlow.Data.Model.ShortMessage model)
{
return(this.dataShortMessage.Add(model));
}
