public int Update(RoadFlow.Data.Model.WeiXinMessage model) { return(this.dataWeiXinMessage.Update(model)); }
public void Receive(string xml) { XElement root = XDocument.Parse(xml).Root; string str1 = root.Element((XName)"ToUserName").Value; string str2 = root.Element((XName)"FromUserName").Value; string str3 = root.Element((XName)"CreateTime").Value; string str4 = root.Element((XName)"MsgType").Value; string str5 = root.Element((XName)"MsgId").Value; string str6 = root.Element((XName)"AgentID").Value; RoadFlow.Platform.WeiXinMessage weiXinMessage = new RoadFlow.Platform.WeiXinMessage(); RoadFlow.Data.Model.WeiXinMessage model = new RoadFlow.Data.Model.WeiXinMessage() { ID = Guid.NewGuid(), AddTime = DateTimeNew.Now, AgentID = str6.ToInt(), CreateTime = str3.ToInt() }; model.CreateTime1 = Tools.JavaLongToDateTime(model.CreateTime); model.MsgType = str4; model.MsgId = str5.ToLong(); model.ToUserName = str1; model.FromUserName = str2; switch (str4) { case "image": model.PicUrl = root.Element((XName)"PicUrl").Value; model.MediaId = root.Element((XName)"MediaId").Value; break; case "link": model.Title = root.Element((XName)"Title").Value; model.Description = root.Element((XName)"Description").Value; model.PicUrl = root.Element((XName)"PicUrl").Value; break; case "location": model.Location_X = root.Element((XName)"Location_X").Value; model.Location_Y = root.Element((XName)"Location_Y").Value; model.Scale = root.Element((XName)"Scale").Value; model.Label = root.Element((XName)"Label").Value; break; case "shortvideo": model.ThumbMediaId = root.Element((XName)"ThumbMediaId").Value; model.MediaId = root.Element((XName)"MediaId").Value; break; case "text": model.Contents = root.Element((XName)"Content").Value; break; case "video": model.ThumbMediaId = root.Element((XName)"ThumbMediaId").Value; model.MediaId = root.Element((XName)"MediaId").Value; break; case "voice": model.Format = root.Element((XName)"Format").Value; model.MediaId = root.Element((XName)"MediaId").Value; break; } weiXinMessage.Add(model); }
public int Add(RoadFlow.Data.Model.WeiXinMessage model) { return(this.dataWeiXinMessage.Add(model)); }
private List <RoadFlow.Data.Model.WeiXinMessage> DataReaderToList(SqlDataReader dataReader) { List <RoadFlow.Data.Model.WeiXinMessage> weiXinMessageList = new List <RoadFlow.Data.Model.WeiXinMessage>(); while (dataReader.Read()) { RoadFlow.Data.Model.WeiXinMessage weiXinMessage = new RoadFlow.Data.Model.WeiXinMessage(); weiXinMessage.ID = dataReader.GetGuid(0); weiXinMessage.ToUserName = dataReader.GetString(1); weiXinMessage.CreateTime = dataReader.GetInt32(3); weiXinMessage.CreateTime1 = dataReader.GetDateTime(4); weiXinMessage.MsgType = dataReader.GetString(5); weiXinMessage.MsgId = dataReader.GetInt64(6); weiXinMessage.AgentID = dataReader.GetInt32(7); if (!dataReader.IsDBNull(8)) { weiXinMessage.Contents = dataReader.GetString(8); } if (!dataReader.IsDBNull(9)) { weiXinMessage.PicUrl = dataReader.GetString(9); } if (!dataReader.IsDBNull(10)) { weiXinMessage.MediaId = dataReader.GetString(10); } if (!dataReader.IsDBNull(11)) { weiXinMessage.Format = dataReader.GetString(11); } if (!dataReader.IsDBNull(12)) { weiXinMessage.ThumbMediaId = dataReader.GetString(12); } if (!dataReader.IsDBNull(13)) { weiXinMessage.Location_X = dataReader.GetString(13); } if (!dataReader.IsDBNull(14)) { weiXinMessage.Location_Y = dataReader.GetString(14); } if (!dataReader.IsDBNull(15)) { weiXinMessage.Scale = dataReader.GetString(15); } if (!dataReader.IsDBNull(16)) { weiXinMessage.Label = dataReader.GetString(16); } if (!dataReader.IsDBNull(17)) { weiXinMessage.Title = dataReader.GetString(17); } if (!dataReader.IsDBNull(18)) { weiXinMessage.Description = dataReader.GetString(18); } weiXinMessage.AddTime = dataReader.GetDateTime(19); weiXinMessageList.Add(weiXinMessage); } return(weiXinMessageList); }
public int Update(RoadFlow.Data.Model.WeiXinMessage model) { string sql = "UPDATE WeiXinMessage SET \r\n\t\t\t\tToUserName=@ToUserName,FromUserName=@FromUserName,CreateTime=@CreateTime,CreateTime1=@CreateTime1,MsgType=@MsgType,MsgId=@MsgId,AgentID=@AgentID,Contents=@Contents,PicUrl=@PicUrl,MediaId=@MediaId,Format=@Format,ThumbMediaId=@ThumbMediaId,Location_X=@Location_X,Location_Y=@Location_Y,Scale=@Scale,Label=@Label,Title=@Title,Description=@Description,AddTime=@AddTime\r\n\t\t\t\tWHERE ID=@ID"; SqlParameter[] sqlParameterArray = new SqlParameter[20]; int index1 = 0; SqlParameter sqlParameter1 = new SqlParameter("@ToUserName", SqlDbType.VarChar, 200); sqlParameter1.Value = (object)model.ToUserName; sqlParameterArray[index1] = sqlParameter1; int index2 = 1; SqlParameter sqlParameter2 = new SqlParameter("@FromUserName", SqlDbType.VarChar, 200); sqlParameter2.Value = (object)model.FromUserName; sqlParameterArray[index2] = sqlParameter2; int index3 = 2; SqlParameter sqlParameter3 = new SqlParameter("@CreateTime", SqlDbType.Int, -1); sqlParameter3.Value = (object)model.CreateTime; sqlParameterArray[index3] = sqlParameter3; int index4 = 3; SqlParameter sqlParameter4 = new SqlParameter("@CreateTime1", SqlDbType.DateTime, 8); sqlParameter4.Value = (object)model.CreateTime1; sqlParameterArray[index4] = sqlParameter4; int index5 = 4; SqlParameter sqlParameter5 = new SqlParameter("@MsgType", SqlDbType.VarChar, 50); sqlParameter5.Value = (object)model.MsgType; sqlParameterArray[index5] = sqlParameter5; int index6 = 5; SqlParameter sqlParameter6 = new SqlParameter("@MsgId", SqlDbType.BigInt, -1); sqlParameter6.Value = (object)model.MsgId; sqlParameterArray[index6] = sqlParameter6; int index7 = 6; SqlParameter sqlParameter7 = new SqlParameter("@AgentID", SqlDbType.Int, -1); sqlParameter7.Value = (object)model.AgentID; sqlParameterArray[index7] = sqlParameter7; int index8 = 7; SqlParameter sqlParameter8; if (model.Contents != null) { SqlParameter sqlParameter9 = new SqlParameter("@Contents", SqlDbType.NVarChar, -1); sqlParameter9.Value = (object)model.Contents; sqlParameter8 = sqlParameter9; } else { sqlParameter8 = new SqlParameter("@Contents", SqlDbType.NVarChar, -1); sqlParameter8.Value = (object)DBNull.Value; } sqlParameterArray[index8] = sqlParameter8; int index9 = 8; SqlParameter sqlParameter10; if (model.PicUrl != null) { SqlParameter sqlParameter9 = new SqlParameter("@PicUrl", SqlDbType.VarChar, 500); sqlParameter9.Value = (object)model.PicUrl; sqlParameter10 = sqlParameter9; } else { sqlParameter10 = new SqlParameter("@PicUrl", SqlDbType.VarChar, 500); sqlParameter10.Value = (object)DBNull.Value; } sqlParameterArray[index9] = sqlParameter10; int index10 = 9; SqlParameter sqlParameter11; if (model.MediaId != null) { SqlParameter sqlParameter9 = new SqlParameter("@MediaId", SqlDbType.VarChar, 500); sqlParameter9.Value = (object)model.MediaId; sqlParameter11 = sqlParameter9; } else { sqlParameter11 = new SqlParameter("@MediaId", SqlDbType.VarChar, 500); sqlParameter11.Value = (object)DBNull.Value; } sqlParameterArray[index10] = sqlParameter11; int index11 = 10; SqlParameter sqlParameter12; if (model.Format != null) { SqlParameter sqlParameter9 = new SqlParameter("@Format", SqlDbType.VarChar, 50); sqlParameter9.Value = (object)model.Format; sqlParameter12 = sqlParameter9; } else { sqlParameter12 = new SqlParameter("@Format", SqlDbType.VarChar, 50); sqlParameter12.Value = (object)DBNull.Value; } sqlParameterArray[index11] = sqlParameter12; int index12 = 11; SqlParameter sqlParameter13; if (model.ThumbMediaId != null) { SqlParameter sqlParameter9 = new SqlParameter("@ThumbMediaId", SqlDbType.VarChar, 50); sqlParameter9.Value = (object)model.ThumbMediaId; sqlParameter13 = sqlParameter9; } else { sqlParameter13 = new SqlParameter("@ThumbMediaId", SqlDbType.VarChar, 50); sqlParameter13.Value = (object)DBNull.Value; } sqlParameterArray[index12] = sqlParameter13; int index13 = 12; SqlParameter sqlParameter14; if (model.Location_X != null) { SqlParameter sqlParameter9 = new SqlParameter("@Location_X", SqlDbType.VarChar, 50); sqlParameter9.Value = (object)model.Location_X; sqlParameter14 = sqlParameter9; } else { sqlParameter14 = new SqlParameter("@Location_X", SqlDbType.VarChar, 50); sqlParameter14.Value = (object)DBNull.Value; } sqlParameterArray[index13] = sqlParameter14; int index14 = 13; SqlParameter sqlParameter15; if (model.Location_Y != null) { SqlParameter sqlParameter9 = new SqlParameter("@Location_Y", SqlDbType.VarChar, 50); sqlParameter9.Value = (object)model.Location_Y; sqlParameter15 = sqlParameter9; } else { sqlParameter15 = new SqlParameter("@Location_Y", SqlDbType.VarChar, 50); sqlParameter15.Value = (object)DBNull.Value; } sqlParameterArray[index14] = sqlParameter15; int index15 = 14; SqlParameter sqlParameter16; if (model.Scale != null) { SqlParameter sqlParameter9 = new SqlParameter("@Scale", SqlDbType.VarChar, 50); sqlParameter9.Value = (object)model.Scale; sqlParameter16 = sqlParameter9; } else { sqlParameter16 = new SqlParameter("@Scale", SqlDbType.VarChar, 50); sqlParameter16.Value = (object)DBNull.Value; } sqlParameterArray[index15] = sqlParameter16; int index16 = 15; SqlParameter sqlParameter17; if (model.Label != null) { SqlParameter sqlParameter9 = new SqlParameter("@Label", SqlDbType.NVarChar, 1000); sqlParameter9.Value = (object)model.Label; sqlParameter17 = sqlParameter9; } else { sqlParameter17 = new SqlParameter("@Label", SqlDbType.NVarChar, 1000); sqlParameter17.Value = (object)DBNull.Value; } sqlParameterArray[index16] = sqlParameter17; int index17 = 16; SqlParameter sqlParameter18; if (model.Title != null) { SqlParameter sqlParameter9 = new SqlParameter("@Title", SqlDbType.NVarChar, 1000); sqlParameter9.Value = (object)model.Title; sqlParameter18 = sqlParameter9; } else { sqlParameter18 = new SqlParameter("@Title", SqlDbType.NVarChar, 1000); sqlParameter18.Value = (object)DBNull.Value; } sqlParameterArray[index17] = sqlParameter18; int index18 = 17; SqlParameter sqlParameter19; if (model.Description != null) { SqlParameter sqlParameter9 = new SqlParameter("@Description", SqlDbType.NVarChar, 2000); sqlParameter9.Value = (object)model.Description; sqlParameter19 = sqlParameter9; } else { sqlParameter19 = new SqlParameter("@Description", SqlDbType.NVarChar, 2000); sqlParameter19.Value = (object)DBNull.Value; } sqlParameterArray[index18] = sqlParameter19; int index19 = 18; SqlParameter sqlParameter20 = new SqlParameter("@AddTime", SqlDbType.DateTime, 8); sqlParameter20.Value = (object)model.AddTime; sqlParameterArray[index19] = sqlParameter20; int index20 = 19; SqlParameter sqlParameter21 = new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1); sqlParameter21.Value = (object)model.ID; sqlParameterArray[index20] = sqlParameter21; SqlParameter[] parameter = sqlParameterArray; return(this.dbHelper.Execute(sql, parameter, false)); }
public int Update(RoadFlow.Data.Model.WeiXinMessage model) { string sql = "UPDATE WeiXinMessage SET \r\n\t\t\t\tToUserName=:ToUserName,FromUserName=:FromUserName,CreateTime=:CreateTime,CreateTime1=:CreateTime1,MsgType=:MsgType,MsgId=:MsgId,AgentID=:AgentID,Contents=:Contents,PicUrl=:PicUrl,MediaId=:MediaId,Format=:Format,ThumbMediaId=:ThumbMediaId,Location_X=:Location_X,Location_Y=:Location_Y,Scale=:Scale,Label=:Label,Title=:Title,Description=:Description,AddTime=:AddTime\r\n\t\t\t\tWHERE ID=:ID"; OracleParameter[] oracleParameterArray = new OracleParameter[20]; int index1 = 0; OracleParameter oracleParameter1 = new OracleParameter(":ToUserName", OracleDbType.Varchar2, 200); oracleParameter1.Value = (object)model.ToUserName; oracleParameterArray[index1] = oracleParameter1; int index2 = 1; OracleParameter oracleParameter2 = new OracleParameter(":FromUserName", OracleDbType.Varchar2, 200); oracleParameter2.Value = (object)model.FromUserName; oracleParameterArray[index2] = oracleParameter2; int index3 = 2; OracleParameter oracleParameter3 = new OracleParameter(":CreateTime", OracleDbType.Int32, -1); oracleParameter3.Value = (object)model.CreateTime; oracleParameterArray[index3] = oracleParameter3; int index4 = 3; OracleParameter oracleParameter4 = new OracleParameter(":CreateTime1", OracleDbType.Date, 8); oracleParameter4.Value = (object)model.CreateTime1; oracleParameterArray[index4] = oracleParameter4; int index5 = 4; OracleParameter oracleParameter5 = new OracleParameter(":MsgType", OracleDbType.Varchar2, 50); oracleParameter5.Value = (object)model.MsgType; oracleParameterArray[index5] = oracleParameter5; int index6 = 5; OracleParameter oracleParameter6 = new OracleParameter(":MsgId", OracleDbType.Int64, -1); oracleParameter6.Value = (object)model.MsgId; oracleParameterArray[index6] = oracleParameter6; int index7 = 6; OracleParameter oracleParameter7 = new OracleParameter(":AgentID", OracleDbType.Int32, -1); oracleParameter7.Value = (object)model.AgentID; oracleParameterArray[index7] = oracleParameter7; int index8 = 7; OracleParameter oracleParameter8; if (model.Contents != null) { OracleParameter oracleParameter9 = new OracleParameter(":Contents", OracleDbType.NVarchar2, -1); oracleParameter9.Value = (object)model.Contents; oracleParameter8 = oracleParameter9; } else { oracleParameter8 = new OracleParameter(":Contents", OracleDbType.NVarchar2, -1); oracleParameter8.Value = (object)DBNull.Value; } oracleParameterArray[index8] = oracleParameter8; int index9 = 8; OracleParameter oracleParameter10; if (model.PicUrl != null) { OracleParameter oracleParameter9 = new OracleParameter(":PicUrl", OracleDbType.Varchar2, 500); oracleParameter9.Value = (object)model.PicUrl; oracleParameter10 = oracleParameter9; } else { oracleParameter10 = new OracleParameter(":PicUrl", OracleDbType.Varchar2, 500); oracleParameter10.Value = (object)DBNull.Value; } oracleParameterArray[index9] = oracleParameter10; int index10 = 9; OracleParameter oracleParameter11; if (model.MediaId != null) { OracleParameter oracleParameter9 = new OracleParameter(":MediaId", OracleDbType.Varchar2, 500); oracleParameter9.Value = (object)model.MediaId; oracleParameter11 = oracleParameter9; } else { oracleParameter11 = new OracleParameter(":MediaId", OracleDbType.Varchar2, 500); oracleParameter11.Value = (object)DBNull.Value; } oracleParameterArray[index10] = oracleParameter11; int index11 = 10; OracleParameter oracleParameter12; if (model.Format != null) { OracleParameter oracleParameter9 = new OracleParameter(":Format", OracleDbType.Varchar2, 50); oracleParameter9.Value = (object)model.Format; oracleParameter12 = oracleParameter9; } else { oracleParameter12 = new OracleParameter(":Format", OracleDbType.Varchar2, 50); oracleParameter12.Value = (object)DBNull.Value; } oracleParameterArray[index11] = oracleParameter12; int index12 = 11; OracleParameter oracleParameter13; if (model.ThumbMediaId != null) { OracleParameter oracleParameter9 = new OracleParameter(":ThumbMediaId", OracleDbType.Varchar2, 50); oracleParameter9.Value = (object)model.ThumbMediaId; oracleParameter13 = oracleParameter9; } else { oracleParameter13 = new OracleParameter(":ThumbMediaId", OracleDbType.Varchar2, 50); oracleParameter13.Value = (object)DBNull.Value; } oracleParameterArray[index12] = oracleParameter13; int index13 = 12; OracleParameter oracleParameter14; if (model.Location_X != null) { OracleParameter oracleParameter9 = new OracleParameter(":Location_X", OracleDbType.Varchar2, 50); oracleParameter9.Value = (object)model.Location_X; oracleParameter14 = oracleParameter9; } else { oracleParameter14 = new OracleParameter(":Location_X", OracleDbType.Varchar2, 50); oracleParameter14.Value = (object)DBNull.Value; } oracleParameterArray[index13] = oracleParameter14; int index14 = 13; OracleParameter oracleParameter15; if (model.Location_Y != null) { OracleParameter oracleParameter9 = new OracleParameter(":Location_Y", OracleDbType.Varchar2, 50); oracleParameter9.Value = (object)model.Location_Y; oracleParameter15 = oracleParameter9; } else { oracleParameter15 = new OracleParameter(":Location_Y", OracleDbType.Varchar2, 50); oracleParameter15.Value = (object)DBNull.Value; } oracleParameterArray[index14] = oracleParameter15; int index15 = 14; OracleParameter oracleParameter16; if (model.Scale != null) { OracleParameter oracleParameter9 = new OracleParameter(":Scale", OracleDbType.Varchar2, 50); oracleParameter9.Value = (object)model.Scale; oracleParameter16 = oracleParameter9; } else { oracleParameter16 = new OracleParameter(":Scale", OracleDbType.Varchar2, 50); oracleParameter16.Value = (object)DBNull.Value; } oracleParameterArray[index15] = oracleParameter16; int index16 = 15; OracleParameter oracleParameter17; if (model.Label != null) { OracleParameter oracleParameter9 = new OracleParameter(":Label", OracleDbType.NVarchar2, 1000); oracleParameter9.Value = (object)model.Label; oracleParameter17 = oracleParameter9; } else { oracleParameter17 = new OracleParameter(":Label", OracleDbType.NVarchar2, 1000); oracleParameter17.Value = (object)DBNull.Value; } oracleParameterArray[index16] = oracleParameter17; int index17 = 16; OracleParameter oracleParameter18; if (model.Title != null) { OracleParameter oracleParameter9 = new OracleParameter(":Title", OracleDbType.NVarchar2, 1000); oracleParameter9.Value = (object)model.Title; oracleParameter18 = oracleParameter9; } else { oracleParameter18 = new OracleParameter(":Title", OracleDbType.NVarchar2, 1000); oracleParameter18.Value = (object)DBNull.Value; } oracleParameterArray[index17] = oracleParameter18; int index18 = 17; OracleParameter oracleParameter19; if (model.Description != null) { OracleParameter oracleParameter9 = new OracleParameter(":Description", OracleDbType.NVarchar2, 2000); oracleParameter9.Value = (object)model.Description; oracleParameter19 = oracleParameter9; } else { oracleParameter19 = new OracleParameter(":Description", OracleDbType.NVarchar2, 2000); oracleParameter19.Value = (object)DBNull.Value; } oracleParameterArray[index18] = oracleParameter19; int index19 = 18; OracleParameter oracleParameter20 = new OracleParameter(":AddTime", OracleDbType.Date, 8); oracleParameter20.Value = (object)model.AddTime; oracleParameterArray[index19] = oracleParameter20; int index20 = 19; OracleParameter oracleParameter21 = new OracleParameter(":ID", OracleDbType.Varchar2, -1); oracleParameter21.Value = (object)model.ID; oracleParameterArray[index20] = oracleParameter21; OracleParameter[] parameter = oracleParameterArray; return(this.dbHelper.Execute(sql, parameter)); }
public int Add(RoadFlow.Data.Model.WeiXinMessage model) { string sql = "INSERT INTO WeiXinMessage\r\n\t\t\t\t(ID,ToUserName,FromUserName,CreateTime,CreateTime1,MsgType,MsgId,AgentID,Contents,PicUrl,MediaId,Format,ThumbMediaId,Location_X,Location_Y,Scale,Label,Title,Description,AddTime) \r\n\t\t\t\tVALUES(@ID,@ToUserName,@FromUserName,@CreateTime,@CreateTime1,@MsgType,@MsgId,@AgentID,@Contents,@PicUrl,@MediaId,@Format,@ThumbMediaId,@Location_X,@Location_Y,@Scale,@Label,@Title,@Description,@AddTime)"; MySqlParameter[] mySqlParameterArray = new MySqlParameter[20]; 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("@ToUserName", MySqlDbType.VarChar, 200); mySqlParameter2.Value = (object)model.ToUserName; mySqlParameterArray[index2] = mySqlParameter2; int index3 = 2; MySqlParameter mySqlParameter3 = new MySqlParameter("@FromUserName", MySqlDbType.VarChar, 200); mySqlParameter3.Value = (object)model.FromUserName; mySqlParameterArray[index3] = mySqlParameter3; int index4 = 3; MySqlParameter mySqlParameter4 = new MySqlParameter("@CreateTime", MySqlDbType.Int32, -1); mySqlParameter4.Value = (object)model.CreateTime; mySqlParameterArray[index4] = mySqlParameter4; int index5 = 4; MySqlParameter mySqlParameter5 = new MySqlParameter("@CreateTime1", MySqlDbType.DateTime, 8); mySqlParameter5.Value = (object)model.CreateTime1; mySqlParameterArray[index5] = mySqlParameter5; int index6 = 5; MySqlParameter mySqlParameter6 = new MySqlParameter("@MsgType", MySqlDbType.VarChar, 50); mySqlParameter6.Value = (object)model.MsgType; mySqlParameterArray[index6] = mySqlParameter6; int index7 = 6; MySqlParameter mySqlParameter7 = new MySqlParameter("@MsgId", MySqlDbType.Int64, -1); mySqlParameter7.Value = (object)model.MsgId; mySqlParameterArray[index7] = mySqlParameter7; int index8 = 7; MySqlParameter mySqlParameter8 = new MySqlParameter("@AgentID", MySqlDbType.Int32, -1); mySqlParameter8.Value = (object)model.AgentID; mySqlParameterArray[index8] = mySqlParameter8; int index9 = 8; MySqlParameter mySqlParameter9; if (model.Contents != null) { MySqlParameter mySqlParameter10 = new MySqlParameter("@Contents", MySqlDbType.VarChar, -1); mySqlParameter10.Value = (object)model.Contents; mySqlParameter9 = mySqlParameter10; } else { mySqlParameter9 = new MySqlParameter("@Contents", MySqlDbType.VarChar, -1); mySqlParameter9.Value = (object)DBNull.Value; } mySqlParameterArray[index9] = mySqlParameter9; int index10 = 9; MySqlParameter mySqlParameter11; if (model.PicUrl != null) { MySqlParameter mySqlParameter10 = new MySqlParameter("@PicUrl", MySqlDbType.VarChar, 500); mySqlParameter10.Value = (object)model.PicUrl; mySqlParameter11 = mySqlParameter10; } else { mySqlParameter11 = new MySqlParameter("@PicUrl", MySqlDbType.VarChar, 500); mySqlParameter11.Value = (object)DBNull.Value; } mySqlParameterArray[index10] = mySqlParameter11; int index11 = 10; MySqlParameter mySqlParameter12; if (model.MediaId != null) { MySqlParameter mySqlParameter10 = new MySqlParameter("@MediaId", MySqlDbType.VarChar, 500); mySqlParameter10.Value = (object)model.MediaId; mySqlParameter12 = mySqlParameter10; } else { mySqlParameter12 = new MySqlParameter("@MediaId", MySqlDbType.VarChar, 500); mySqlParameter12.Value = (object)DBNull.Value; } mySqlParameterArray[index11] = mySqlParameter12; int index12 = 11; MySqlParameter mySqlParameter13; if (model.Format != null) { MySqlParameter mySqlParameter10 = new MySqlParameter("@Format", MySqlDbType.VarChar, 50); mySqlParameter10.Value = (object)model.Format; mySqlParameter13 = mySqlParameter10; } else { mySqlParameter13 = new MySqlParameter("@Format", MySqlDbType.VarChar, 50); mySqlParameter13.Value = (object)DBNull.Value; } mySqlParameterArray[index12] = mySqlParameter13; int index13 = 12; MySqlParameter mySqlParameter14; if (model.ThumbMediaId != null) { MySqlParameter mySqlParameter10 = new MySqlParameter("@ThumbMediaId", MySqlDbType.VarChar, 50); mySqlParameter10.Value = (object)model.ThumbMediaId; mySqlParameter14 = mySqlParameter10; } else { mySqlParameter14 = new MySqlParameter("@ThumbMediaId", MySqlDbType.VarChar, 50); mySqlParameter14.Value = (object)DBNull.Value; } mySqlParameterArray[index13] = mySqlParameter14; int index14 = 13; MySqlParameter mySqlParameter15; if (model.Location_X != null) { MySqlParameter mySqlParameter10 = new MySqlParameter("@Location_X", MySqlDbType.VarChar, 50); mySqlParameter10.Value = (object)model.Location_X; mySqlParameter15 = mySqlParameter10; } else { mySqlParameter15 = new MySqlParameter("@Location_X", MySqlDbType.VarChar, 50); mySqlParameter15.Value = (object)DBNull.Value; } mySqlParameterArray[index14] = mySqlParameter15; int index15 = 14; MySqlParameter mySqlParameter16; if (model.Location_Y != null) { MySqlParameter mySqlParameter10 = new MySqlParameter("@Location_Y", MySqlDbType.VarChar, 50); mySqlParameter10.Value = (object)model.Location_Y; mySqlParameter16 = mySqlParameter10; } else { mySqlParameter16 = new MySqlParameter("@Location_Y", MySqlDbType.VarChar, 50); mySqlParameter16.Value = (object)DBNull.Value; } mySqlParameterArray[index15] = mySqlParameter16; int index16 = 15; MySqlParameter mySqlParameter17; if (model.Scale != null) { MySqlParameter mySqlParameter10 = new MySqlParameter("@Scale", MySqlDbType.VarChar, 50); mySqlParameter10.Value = (object)model.Scale; mySqlParameter17 = mySqlParameter10; } else { mySqlParameter17 = new MySqlParameter("@Scale", MySqlDbType.VarChar, 50); mySqlParameter17.Value = (object)DBNull.Value; } mySqlParameterArray[index16] = mySqlParameter17; int index17 = 16; MySqlParameter mySqlParameter18; if (model.Label != null) { MySqlParameter mySqlParameter10 = new MySqlParameter("@Label", MySqlDbType.VarChar, 1000); mySqlParameter10.Value = (object)model.Label; mySqlParameter18 = mySqlParameter10; } else { mySqlParameter18 = new MySqlParameter("@Label", MySqlDbType.VarChar, 1000); mySqlParameter18.Value = (object)DBNull.Value; } mySqlParameterArray[index17] = mySqlParameter18; int index18 = 17; MySqlParameter mySqlParameter19; if (model.Title != null) { MySqlParameter mySqlParameter10 = new MySqlParameter("@Title", MySqlDbType.VarChar, 1000); mySqlParameter10.Value = (object)model.Title; mySqlParameter19 = mySqlParameter10; } else { mySqlParameter19 = new MySqlParameter("@Title", MySqlDbType.VarChar, 1000); mySqlParameter19.Value = (object)DBNull.Value; } mySqlParameterArray[index18] = mySqlParameter19; int index19 = 18; MySqlParameter mySqlParameter20; if (model.Description != null) { MySqlParameter mySqlParameter10 = new MySqlParameter("@Description", MySqlDbType.VarChar, 2000); mySqlParameter10.Value = (object)model.Description; mySqlParameter20 = mySqlParameter10; } else { mySqlParameter20 = new MySqlParameter("@Description", MySqlDbType.VarChar, 2000); mySqlParameter20.Value = (object)DBNull.Value; } mySqlParameterArray[index19] = mySqlParameter20; int index20 = 19; MySqlParameter mySqlParameter21 = new MySqlParameter("@AddTime", MySqlDbType.DateTime, 8); mySqlParameter21.Value = (object)model.AddTime; mySqlParameterArray[index20] = mySqlParameter21; MySqlParameter[] parameter = mySqlParameterArray; return(this.dbHelper.Execute(sql, parameter, false)); }