protected void Page_Load(object sender, EventArgs e)
{
string id = Request.QueryString["id"];
if (id.IsGuid())
{
log = new RoadFlow.Platform.Log().Get(id.ToGuid());
if (log != null)
{
this.Title1.Text = log.Title;
this.Type.Text = log.Type;
this.WriteTime.Text = log.WriteTime.ToDateTimeStringS();
this.UserName.Text = log.UserName;
this.IPAddress.Text = log.IPAddress;
this.URL.Text = log.URL;
this.Others.Text = log.Others;
this.Contents.Text = log.Contents.HtmlEncode();
this.OldXml.Text = log.OldXml.HtmlEncode();
this.NewXml.Text = log.NewXml.HtmlEncode();
if (log.Contents.IsNullOrEmpty())
{
this.contentstr.Visible = false;
}
if (log.OldXml.IsNullOrEmpty())
{
this.oldxmlstr.Visible = false;
}
if (log.NewXml.IsNullOrEmpty())
{
this.newxmlstr.Visible = false;
}
}
}
}
public static void Add(string title, string contents, Log.Types type = Log.Types.其它分类, string oldXML = "", string newXML = "", RoadFlow.Data.Model.Users user = null)
{
RoadFlow.Data.Model.Log model = new RoadFlow.Data.Model.Log();
model.Contents = contents;
model.ID = Guid.NewGuid();
model.Title = title;
model.OldXml = oldXML.IsNullOrEmpty() ? (string)null : oldXML;
model.NewXml = newXML.IsNullOrEmpty() ? (string)null : newXML;
model.Type = type.ToString();
try
{
if (user == null)
{
user = Users.CurrentUser;
}
if (user != null)
{
model.UserID = new Guid?(user.ID);
model.UserName = user.Name;
}
model.IPAddress = Tools.GetIPAddress();
model.Others = string.Format("操作系统：{0} 浏览器：{1}", (object)Tools.GetOSName(), (object)Tools.GetBrowse());
model.URL = HttpContext.Current.Request.Url.ToString();
}
catch
{
}
model.WriteTime = DateTimeNew.Now;
Log.Add(model);
}
/// <summary>
/// 将DataRedar转换为List
/// </summary>
private List <RoadFlow.Data.Model.Log> DataReaderToList(SqlDataReader dataReader)
{
List <RoadFlow.Data.Model.Log> List = new List <RoadFlow.Data.Model.Log>();
RoadFlow.Data.Model.Log model = null;
while (dataReader.Read())
{
model = new RoadFlow.Data.Model.Log();
model.ID = dataReader.GetGuid(0);
model.Title = dataReader.GetString(1);
model.Type = dataReader.GetString(2);
model.WriteTime = dataReader.GetDateTime(3);
if (!dataReader.IsDBNull(4))
{
model.UserID = dataReader.GetGuid(4);
}
if (!dataReader.IsDBNull(5))
{
model.UserName = dataReader.GetString(5);
}
if (!dataReader.IsDBNull(6))
{
model.IPAddress = dataReader.GetString(6);
}
if (!dataReader.IsDBNull(7))
{
model.URL = dataReader.GetString(7);
}
if (!dataReader.IsDBNull(8))
{
model.Contents = dataReader.GetString(8);
}
if (!dataReader.IsDBNull(9))
{
model.Others = dataReader.GetString(9);
}
if (!dataReader.IsDBNull(10))
{
model.OldXml = dataReader.GetString(10);
}
if (!dataReader.IsDBNull(11))
{
model.NewXml = dataReader.GetString(11);
}
List.Add(model);
}
return(List);
}
private List <RoadFlow.Data.Model.Log> DataReaderToList(MySqlDataReader dataReader)
{
List <RoadFlow.Data.Model.Log> logList = new List <RoadFlow.Data.Model.Log>();
while (dataReader.Read())
{
RoadFlow.Data.Model.Log log = new RoadFlow.Data.Model.Log();
log.ID = dataReader.GetString(0).ToGuid();
log.Title = dataReader.GetString(1);
log.Type = dataReader.GetString(2);
log.WriteTime = dataReader.GetDateTime(3);
if (!dataReader.IsDBNull(4))
{
log.UserID = new Guid?(dataReader.GetString(4).ToGuid());
}
if (!dataReader.IsDBNull(5))
{
log.UserName = dataReader.GetString(5);
}
if (!dataReader.IsDBNull(6))
{
log.IPAddress = dataReader.GetString(6);
}
if (!dataReader.IsDBNull(7))
{
log.URL = dataReader.GetString(7);
}
if (!dataReader.IsDBNull(8))
{
log.Contents = dataReader.GetString(8);
}
if (!dataReader.IsDBNull(9))
{
log.Others = dataReader.GetString(9);
}
if (!dataReader.IsDBNull(10))
{
log.OldXml = dataReader.GetString(10);
}
if (!dataReader.IsDBNull(11))
{
log.NewXml = dataReader.GetString(11);
}
logList.Add(log);
}
return(logList);
}
/// <summary>
/// 记录日志
/// </summary>
/// <param name="err"></param>
public static void Add(string title, string contents, Types type = Types.其它分类, string oldXML = "", string newXML = "", RoadFlow.Data.Model.Users user = null)
{
if (user == null)
{
user = Platform.Users.CurrentUser;
}
RoadFlow.Data.Model.Log log = new RoadFlow.Data.Model.Log();
log.Contents = contents;
log.ID = Guid.NewGuid();
log.IPAddress = RoadFlow.Utility.Tools.GetIPAddress();
log.Others = string.Format("操作系统：{0} 浏览器：{1}", RoadFlow.Utility.Tools.GetOSName(), RoadFlow.Utility.Tools.GetBrowse());
log.Title = title;
log.OldXml = oldXML.IsNullOrEmpty() ? null : oldXML;
log.NewXml = newXML.IsNullOrEmpty() ? null : newXML;
log.Type = type.ToString();
log.URL = System.Web.HttpContext.Current.Request.Url.ToString();
if (user != null)
{
log.UserID = user.ID;
log.UserName = user.Name;
}
log.WriteTime = RoadFlow.Utility.DateTimeNew.Now;
Add(log);
}
public int Add(RoadFlow.Data.Model.Log model)
{
string sql = "INSERT INTO log\r\n\t\t\t\t(ID,Title,Type,WriteTime,UserID,UserName,IPAddress,URL,Contents,Others,OldXml,NewXml) \r\n\t\t\t\tVALUES(@ID,@Title,@Type,@WriteTime,@UserID,@UserName,@IPAddress,@URL,@Contents,@Others,@OldXml,@NewXml)";
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.LongText, -1);
mySqlParameter2.Value = (object)model.Title;
mySqlParameterArray[index2] = mySqlParameter2;
int index3 = 2;
MySqlParameter mySqlParameter3 = new MySqlParameter("@Type", MySqlDbType.VarChar, 50);
mySqlParameter3.Value = (object)model.Type;
mySqlParameterArray[index3] = mySqlParameter3;
int index4 = 3;
MySqlParameter mySqlParameter4 = new MySqlParameter("@WriteTime", MySqlDbType.DateTime, -1);
mySqlParameter4.Value = (object)model.WriteTime;
mySqlParameterArray[index4] = mySqlParameter4;
int index5 = 4;
MySqlParameter mySqlParameter5;
if (model.UserID.HasValue)
{
MySqlParameter mySqlParameter6 = new MySqlParameter("@UserID", MySqlDbType.VarChar, 36);
mySqlParameter6.Value = (object)model.UserID;
mySqlParameter5 = mySqlParameter6;
}
else
{
mySqlParameter5 = new MySqlParameter("@UserID", MySqlDbType.VarChar, 36);
mySqlParameter5.Value = (object)DBNull.Value;
}
mySqlParameterArray[index5] = mySqlParameter5;
int index6 = 5;
MySqlParameter mySqlParameter7;
if (model.UserName != null)
{
MySqlParameter mySqlParameter6 = new MySqlParameter("@UserName", MySqlDbType.VarChar, 50);
mySqlParameter6.Value = (object)model.UserName;
mySqlParameter7 = mySqlParameter6;
}
else
{
mySqlParameter7 = new MySqlParameter("@UserName", MySqlDbType.VarChar, 50);
mySqlParameter7.Value = (object)DBNull.Value;
}
mySqlParameterArray[index6] = mySqlParameter7;
int index7 = 6;
MySqlParameter mySqlParameter8;
if (model.IPAddress != null)
{
MySqlParameter mySqlParameter6 = new MySqlParameter("@IPAddress", MySqlDbType.VarChar, 50);
mySqlParameter6.Value = (object)model.IPAddress;
mySqlParameter8 = mySqlParameter6;
}
else
{
mySqlParameter8 = new MySqlParameter("@IPAddress", MySqlDbType.VarChar, 50);
mySqlParameter8.Value = (object)DBNull.Value;
}
mySqlParameterArray[index7] = mySqlParameter8;
int index8 = 7;
MySqlParameter mySqlParameter9;
if (model.URL != null)
{
MySqlParameter mySqlParameter6 = new MySqlParameter("@URL", MySqlDbType.LongText, -1);
mySqlParameter6.Value = (object)model.URL;
mySqlParameter9 = mySqlParameter6;
}
else
{
mySqlParameter9 = new MySqlParameter("@URL", MySqlDbType.LongText, -1);
mySqlParameter9.Value = (object)DBNull.Value;
}
mySqlParameterArray[index8] = mySqlParameter9;
int index9 = 8;
MySqlParameter mySqlParameter10;
if (model.Contents != null)
{
MySqlParameter mySqlParameter6 = new MySqlParameter("@Contents", MySqlDbType.LongText, -1);
mySqlParameter6.Value = (object)model.Contents;
mySqlParameter10 = mySqlParameter6;
}
else
{
mySqlParameter10 = new MySqlParameter("@Contents", MySqlDbType.LongText, -1);
mySqlParameter10.Value = (object)DBNull.Value;
}
mySqlParameterArray[index9] = mySqlParameter10;
int index10 = 9;
MySqlParameter mySqlParameter11;
if (model.Others != null)
{
MySqlParameter mySqlParameter6 = new MySqlParameter("@Others", MySqlDbType.LongText, -1);
mySqlParameter6.Value = (object)model.Others;
mySqlParameter11 = mySqlParameter6;
}
else
{
mySqlParameter11 = new MySqlParameter("@Others", MySqlDbType.LongText, -1);
mySqlParameter11.Value = (object)DBNull.Value;
}
mySqlParameterArray[index10] = mySqlParameter11;
int index11 = 10;
MySqlParameter mySqlParameter12;
if (model.OldXml != null)
{
MySqlParameter mySqlParameter6 = new MySqlParameter("@OldXml", MySqlDbType.LongText, -1);
mySqlParameter6.Value = (object)model.OldXml;
mySqlParameter12 = mySqlParameter6;
}
else
{
mySqlParameter12 = new MySqlParameter("@OldXml", MySqlDbType.LongText, -1);
mySqlParameter12.Value = (object)DBNull.Value;
}
mySqlParameterArray[index11] = mySqlParameter12;
int index12 = 11;
MySqlParameter mySqlParameter13;
if (model.NewXml != null)
{
MySqlParameter mySqlParameter6 = new MySqlParameter("@NewXml", MySqlDbType.LongText, -1);
mySqlParameter6.Value = (object)model.NewXml;
mySqlParameter13 = mySqlParameter6;
}
else
{
mySqlParameter13 = new MySqlParameter("@NewXml", MySqlDbType.LongText, -1);
mySqlParameter13.Value = (object)DBNull.Value;
}
mySqlParameterArray[index12] = mySqlParameter13;
MySqlParameter[] parameter = mySqlParameterArray;
return(this.dbHelper.Execute(sql, parameter, false));
}
public int Add(RoadFlow.Data.Model.Log model)
{
string sql = "INSERT INTO Log\r\n\t\t\t\t(ID,Title,Type,WriteTime,UserID,UserName,IPAddress,URL,Contents,Others,OldXml,NewXml) \r\n\t\t\t\tVALUES(:ID,:Title,:Type,:WriteTime,:UserID,:UserName,:IPAddress,:URL,:Contents,:Others,:OldXml,:NewXml)";
OracleParameter[] oracleParameterArray = new OracleParameter[12];
int index1 = 0;
OracleParameter oracleParameter1 = new OracleParameter(":ID", OracleDbType.Varchar2, 40);
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 = new OracleParameter(":Type", OracleDbType.NVarchar2, 100);
oracleParameter3.Value = (object)model.Type;
oracleParameterArray[index3] = oracleParameter3;
int index4 = 3;
OracleParameter oracleParameter4 = new OracleParameter(":WriteTime", OracleDbType.Date, 8);
oracleParameter4.Value = (object)model.WriteTime;
oracleParameterArray[index4] = oracleParameter4;
int index5 = 4;
OracleParameter oracleParameter5;
if (model.UserID.HasValue)
{
OracleParameter oracleParameter6 = new OracleParameter(":UserID", OracleDbType.Varchar2, 40);
oracleParameter6.Value = (object)model.UserID;
oracleParameter5 = oracleParameter6;
}
else
{
oracleParameter5 = new OracleParameter(":UserID", OracleDbType.Varchar2, 40);
oracleParameter5.Value = (object)DBNull.Value;
}
oracleParameterArray[index5] = oracleParameter5;
int index6 = 5;
OracleParameter oracleParameter7;
if (model.UserName != null)
{
OracleParameter oracleParameter6 = new OracleParameter(":UserName", OracleDbType.NVarchar2, 100);
oracleParameter6.Value = (object)model.UserName;
oracleParameter7 = oracleParameter6;
}
else
{
oracleParameter7 = new OracleParameter(":UserName", OracleDbType.NVarchar2, 100);
oracleParameter7.Value = (object)DBNull.Value;
}
oracleParameterArray[index6] = oracleParameter7;
int index7 = 6;
OracleParameter oracleParameter8;
if (model.IPAddress != null)
{
OracleParameter oracleParameter6 = new OracleParameter(":IPAddress", OracleDbType.Varchar2, 50);
oracleParameter6.Value = (object)model.IPAddress;
oracleParameter8 = oracleParameter6;
}
else
{
oracleParameter8 = new OracleParameter(":IPAddress", OracleDbType.Varchar2, 50);
oracleParameter8.Value = (object)DBNull.Value;
}
oracleParameterArray[index7] = oracleParameter8;
int index8 = 7;
OracleParameter oracleParameter9;
if (model.URL != null)
{
OracleParameter oracleParameter6 = new OracleParameter(":URL", OracleDbType.Clob);
oracleParameter6.Value = (object)model.URL;
oracleParameter9 = oracleParameter6;
}
else
{
oracleParameter9 = new OracleParameter(":URL", OracleDbType.Clob);
oracleParameter9.Value = (object)DBNull.Value;
}
oracleParameterArray[index8] = oracleParameter9;
int index9 = 8;
OracleParameter oracleParameter10;
if (model.Contents != null)
{
OracleParameter oracleParameter6 = new OracleParameter(":Contents", OracleDbType.Clob);
oracleParameter6.Value = (object)model.Contents;
oracleParameter10 = oracleParameter6;
}
else
{
oracleParameter10 = new OracleParameter(":Contents", OracleDbType.Clob);
oracleParameter10.Value = (object)DBNull.Value;
}
oracleParameterArray[index9] = oracleParameter10;
int index10 = 9;
OracleParameter oracleParameter11;
if (model.Others != null)
{
OracleParameter oracleParameter6 = new OracleParameter(":Others", OracleDbType.Clob);
oracleParameter6.Value = (object)model.Others;
oracleParameter11 = oracleParameter6;
}
else
{
oracleParameter11 = new OracleParameter(":Others", OracleDbType.Clob);
oracleParameter11.Value = (object)DBNull.Value;
}
oracleParameterArray[index10] = oracleParameter11;
int index11 = 10;
OracleParameter oracleParameter12;
if (model.OldXml != null)
{
OracleParameter oracleParameter6 = new OracleParameter(":OldXml", OracleDbType.Clob);
oracleParameter6.Value = (object)model.OldXml;
oracleParameter12 = oracleParameter6;
}
else
{
oracleParameter12 = new OracleParameter(":OldXml", OracleDbType.Clob);
oracleParameter12.Value = (object)DBNull.Value;
}
oracleParameterArray[index11] = oracleParameter12;
int index12 = 11;
OracleParameter oracleParameter13;
if (model.NewXml != null)
{
OracleParameter oracleParameter6 = new OracleParameter(":NewXml", OracleDbType.Clob);
oracleParameter6.Value = (object)model.NewXml;
oracleParameter13 = oracleParameter6;
}
else
{
oracleParameter13 = new OracleParameter(":NewXml", OracleDbType.Clob);
oracleParameter13.Value = (object)DBNull.Value;
}
oracleParameterArray[index12] = oracleParameter13;
OracleParameter[] parameter = oracleParameterArray;
return(this.dbHelper.Execute(sql, parameter));
}
/// <summary>
/// 添加记录
/// </summary>
/// <param name="model">RoadFlow.Data.Model.Log实体类</param>
/// <returns>操作所影响的行数</returns>
public int Add(RoadFlow.Data.Model.Log model)
{
string sql = @"INSERT INTO Log
(ID,Title,Type,WriteTime,UserID,UserName,IPAddress,URL,Contents,Others,OldXml,NewXml)
VALUES(@ID,@Title,@Type,@WriteTime,@UserID,@UserName,@IPAddress,@URL,@Contents,@Others,@OldXml,@NewXml)" ;
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.ID
},
new SqlParameter("@Title", SqlDbType.NVarChar, -1)
{
Value = model.Title
},
new SqlParameter("@Type", SqlDbType.NVarChar, 100)
{
Value = model.Type
},
new SqlParameter("@WriteTime", SqlDbType.DateTime, 8)
{
Value = model.WriteTime
},
model.UserID == null ? new SqlParameter("@UserID", SqlDbType.UniqueIdentifier, -1)
{
Value = DBNull.Value
} : new SqlParameter("@UserID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.UserID
},
model.UserName == null ? new SqlParameter("@UserName", SqlDbType.NVarChar, 100)
{
Value = DBNull.Value
} : new SqlParameter("@UserName", SqlDbType.NVarChar, 100)
{
Value = model.UserName
},
model.IPAddress == null ? new SqlParameter("@IPAddress", SqlDbType.VarChar, 50)
{
Value = DBNull.Value
} : new SqlParameter("@IPAddress", SqlDbType.VarChar, 50)
{
Value = model.IPAddress
},
model.URL == null ? new SqlParameter("@URL", SqlDbType.VarChar, -1)
{
Value = DBNull.Value
} : new SqlParameter("@URL", SqlDbType.VarChar, -1)
{
Value = model.URL
},
model.Contents == null ? new SqlParameter("@Contents", SqlDbType.VarChar, -1)
{
Value = DBNull.Value
} : new SqlParameter("@Contents", SqlDbType.VarChar, -1)
{
Value = model.Contents
},
model.Others == null ? new SqlParameter("@Others", SqlDbType.VarChar, -1)
{
Value = DBNull.Value
} : new SqlParameter("@Others", SqlDbType.VarChar, -1)
{
Value = model.Others
},
model.OldXml == null ? new SqlParameter("@OldXml", SqlDbType.VarChar, -1)
{
Value = DBNull.Value
} : new SqlParameter("@OldXml", SqlDbType.VarChar, -1)
{
Value = model.OldXml
},
model.NewXml == null ? new SqlParameter("@NewXml", SqlDbType.VarChar, -1)
{
Value = DBNull.Value
} : new SqlParameter("@NewXml", SqlDbType.VarChar, -1)
{
Value = model.NewXml
}
};
return(dbHelper.Execute(sql, parameters));
}
/// <summary>
/// 更新记录
/// </summary>
/// <param name="model">RoadFlow.Data.Model.Log实体类</param>
public int Update(RoadFlow.Data.Model.Log model)
{
string sql = @"UPDATE Log SET
Title=@Title,Type=@Type,WriteTime=@WriteTime,UserID=@UserID,UserName=@UserName,IPAddress=@IPAddress,URL=@URL,Contents=@Contents,Others=@Others,OldXml=@OldXml,NewXml=@NewXml
WHERE ID=@ID" ;
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@Title", SqlDbType.NVarChar, -1)
{
Value = model.Title
},
new SqlParameter("@Type", SqlDbType.NVarChar, 100)
{
Value = model.Type
},
new SqlParameter("@WriteTime", SqlDbType.DateTime, 8)
{
Value = model.WriteTime
},
model.UserID == null ? new SqlParameter("@UserID", SqlDbType.UniqueIdentifier, -1)
{
Value = DBNull.Value
} : new SqlParameter("@UserID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.UserID
},
model.UserName == null ? new SqlParameter("@UserName", SqlDbType.NVarChar, 100)
{
Value = DBNull.Value
} : new SqlParameter("@UserName", SqlDbType.NVarChar, 100)
{
Value = model.UserName
},
model.IPAddress == null ? new SqlParameter("@IPAddress", SqlDbType.VarChar, 50)
{
Value = DBNull.Value
} : new SqlParameter("@IPAddress", SqlDbType.VarChar, 50)
{
Value = model.IPAddress
},
model.URL == null ? new SqlParameter("@URL", SqlDbType.VarChar, -1)
{
Value = DBNull.Value
} : new SqlParameter("@URL", SqlDbType.VarChar, -1)
{
Value = model.URL
},
model.Contents == null ? new SqlParameter("@Contents", SqlDbType.VarChar, -1)
{
Value = DBNull.Value
} : new SqlParameter("@Contents", SqlDbType.VarChar, -1)
{
Value = model.Contents
},
model.Others == null ? new SqlParameter("@Others", SqlDbType.VarChar, -1)
{
Value = DBNull.Value
} : new SqlParameter("@Others", SqlDbType.VarChar, -1)
{
Value = model.Others
},
model.OldXml == null ? new SqlParameter("@OldXml", SqlDbType.VarChar, -1)
{
Value = DBNull.Value
} : new SqlParameter("@OldXml", SqlDbType.VarChar, -1)
{
Value = model.OldXml
},
model.NewXml == null ? new SqlParameter("@NewXml", SqlDbType.VarChar, -1)
{
Value = DBNull.Value
} : new SqlParameter("@NewXml", SqlDbType.VarChar, -1)
{
Value = model.NewXml
},
new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.ID
}
};
return(dbHelper.Execute(sql, parameters));
}
/// <summary>
/// 添加记录
/// </summary>
/// <param name="model">RoadFlow.Data.Model.Log实体类</param>
/// <returns>操作所影响的行数</returns>
public int Add(RoadFlow.Data.Model.Log model)
{
string sql = @"INSERT INTO Log
(ID,Title,Type,WriteTime,UserID,UserName,IPAddress,URL,Contents,Others,OldXml,NewXml)
VALUES(:ID,:Title,:Type,:WriteTime,:UserID,:UserName,:IPAddress,:URL,:Contents,:Others,:OldXml,:NewXml)" ;
OracleParameter[] parameters = new OracleParameter[] {
new OracleParameter(":ID", OracleDbType.Varchar2, 40)
{
Value = model.ID
},
new OracleParameter(":Title", OracleDbType.NVarchar2)
{
Value = model.Title
},
new OracleParameter(":Type", OracleDbType.NVarchar2, 100)
{
Value = model.Type
},
new OracleParameter(":WriteTime", OracleDbType.Date, 8)
{
Value = model.WriteTime
},
model.UserID == null ? new OracleParameter(":UserID", OracleDbType.Varchar2, 40)
{
Value = DBNull.Value
} : new OracleParameter(":UserID", OracleDbType.Varchar2, 40)
{
Value = model.UserID
},
model.UserName == null ? new OracleParameter(":UserName", OracleDbType.NVarchar2, 100)
{
Value = DBNull.Value
} : new OracleParameter(":UserName", OracleDbType.NVarchar2, 100)
{
Value = model.UserName
},
model.IPAddress == null ? new OracleParameter(":IPAddress", OracleDbType.Varchar2, 50)
{
Value = DBNull.Value
} : new OracleParameter(":IPAddress", OracleDbType.Varchar2, 50)
{
Value = model.IPAddress
},
model.URL == null ? new OracleParameter(":URL", OracleDbType.Clob)
{
Value = DBNull.Value
} : new OracleParameter(":URL", OracleDbType.Clob)
{
Value = model.URL
},
model.Contents == null ? new OracleParameter(":Contents", OracleDbType.Clob)
{
Value = DBNull.Value
} : new OracleParameter(":Contents", OracleDbType.Clob)
{
Value = model.Contents
},
model.Others == null ? new OracleParameter(":Others", OracleDbType.Clob)
{
Value = DBNull.Value
} : new OracleParameter(":Others", OracleDbType.Clob)
{
Value = model.Others
},
model.OldXml == null ? new OracleParameter(":OldXml", OracleDbType.Clob)
{
Value = DBNull.Value
} : new OracleParameter(":OldXml", OracleDbType.Clob)
{
Value = model.OldXml
},
model.NewXml == null ? new OracleParameter(":NewXml", OracleDbType.Clob)
{
Value = DBNull.Value
} : new OracleParameter(":NewXml", OracleDbType.Clob)
{
Value = model.NewXml
}
};
return(dbHelper.Execute(sql, parameters));
}
/// <summary>
/// 更新记录
/// </summary>
/// <param name="model">RoadFlow.Data.Model.Log实体类</param>
public int Update(RoadFlow.Data.Model.Log model)
{
string sql = @"UPDATE Log SET
Title=:Title,Type=:Type,WriteTime=:WriteTime,UserID=:UserID,UserName=:UserName,IPAddress=:IPAddress,URL=:URL,Contents=:Contents,Others=:Others,OldXml=:OldXml,NewXml=:NewXml
WHERE ID=:ID" ;
OracleParameter[] parameters = new OracleParameter[] {
new OracleParameter(":Title", OracleDbType.NVarchar2)
{
Value = model.Title
},
new OracleParameter(":Type", OracleDbType.NVarchar2, 100)
{
Value = model.Type
},
new OracleParameter(":WriteTime", OracleDbType.Date, 8)
{
Value = model.WriteTime
},
model.UserID == null ? new OracleParameter(":UserID", OracleDbType.Varchar2, 40)
{
Value = DBNull.Value
} : new OracleParameter(":UserID", OracleDbType.Varchar2, 40)
{
Value = model.UserID
},
model.UserName == null ? new OracleParameter(":UserName", OracleDbType.NVarchar2, 100)
{
Value = DBNull.Value
} : new OracleParameter(":UserName", OracleDbType.NVarchar2, 100)
{
Value = model.UserName
},
model.IPAddress == null ? new OracleParameter(":IPAddress", OracleDbType.Varchar2, 50)
{
Value = DBNull.Value
} : new OracleParameter(":IPAddress", OracleDbType.Varchar2, 50)
{
Value = model.IPAddress
},
model.URL == null ? new OracleParameter(":URL", OracleDbType.Clob)
{
Value = DBNull.Value
} : new OracleParameter(":URL", OracleDbType.Clob)
{
Value = model.URL
},
model.Contents == null ? new OracleParameter(":Contents", OracleDbType.Clob)
{
Value = DBNull.Value
} : new OracleParameter(":Contents", OracleDbType.Clob)
{
Value = model.Contents
},
model.Others == null ? new OracleParameter(":Others", OracleDbType.Clob)
{
Value = DBNull.Value
} : new OracleParameter(":Others", OracleDbType.Clob)
{
Value = model.Others
},
model.OldXml == null ? new OracleParameter(":OldXml", OracleDbType.Clob)
{
Value = DBNull.Value
} : new OracleParameter(":OldXml", OracleDbType.Clob)
{
Value = model.OldXml
},
model.NewXml == null ? new OracleParameter(":NewXml", OracleDbType.Clob)
{
Value = DBNull.Value
} : new OracleParameter(":NewXml", OracleDbType.Clob)
{
Value = model.NewXml
},
new OracleParameter(":ID", OracleDbType.Varchar2, 40)
{
Value = model.ID
}
};
return(dbHelper.Execute(sql, parameters));
}
public static void Add(RoadFlow.Data.Model.Log model)
{
new Log.dgWriteLog(Log.add).BeginInvoke(model, (AsyncCallback)null, (object)null);
}
private static void add(RoadFlow.Data.Model.Log model)
{
Log.dataLog1.Add(model);
}
public int Update(RoadFlow.Data.Model.Log model)
{
return(this.dataLog.Update(model));
}
public int Update(RoadFlow.Data.Model.Log model)
{
string sql = "UPDATE Log SET \r\n\t\t\t\tTitle=@Title,Type=@Type,WriteTime=@WriteTime,UserID=@UserID,UserName=@UserName,IPAddress=@IPAddress,URL=@URL,Contents=@Contents,Others=@Others,OldXml=@OldXml,NewXml=@NewXml\r\n\t\t\t\tWHERE ID=@ID";
SqlParameter[] sqlParameterArray = new SqlParameter[12];
int index1 = 0;
SqlParameter sqlParameter1 = new SqlParameter("@Title", SqlDbType.NVarChar, -1);
sqlParameter1.Value = (object)model.Title;
sqlParameterArray[index1] = sqlParameter1;
int index2 = 1;
SqlParameter sqlParameter2 = new SqlParameter("@Type", SqlDbType.NVarChar, 100);
sqlParameter2.Value = (object)model.Type;
sqlParameterArray[index2] = sqlParameter2;
int index3 = 2;
SqlParameter sqlParameter3 = new SqlParameter("@WriteTime", SqlDbType.DateTime, 8);
sqlParameter3.Value = (object)model.WriteTime;
sqlParameterArray[index3] = sqlParameter3;
int index4 = 3;
SqlParameter sqlParameter4;
if (model.UserID.HasValue)
{
SqlParameter sqlParameter5 = new SqlParameter("@UserID", SqlDbType.UniqueIdentifier, -1);
sqlParameter5.Value = (object)model.UserID;
sqlParameter4 = sqlParameter5;
}
else
{
sqlParameter4 = new SqlParameter("@UserID", SqlDbType.UniqueIdentifier, -1);
sqlParameter4.Value = (object)DBNull.Value;
}
sqlParameterArray[index4] = sqlParameter4;
int index5 = 4;
SqlParameter sqlParameter6;
if (model.UserName != null)
{
SqlParameter sqlParameter5 = new SqlParameter("@UserName", SqlDbType.NVarChar, 100);
sqlParameter5.Value = (object)model.UserName;
sqlParameter6 = sqlParameter5;
}
else
{
sqlParameter6 = new SqlParameter("@UserName", SqlDbType.NVarChar, 100);
sqlParameter6.Value = (object)DBNull.Value;
}
sqlParameterArray[index5] = sqlParameter6;
int index6 = 5;
SqlParameter sqlParameter7;
if (model.IPAddress != null)
{
SqlParameter sqlParameter5 = new SqlParameter("@IPAddress", SqlDbType.VarChar, 50);
sqlParameter5.Value = (object)model.IPAddress;
sqlParameter7 = sqlParameter5;
}
else
{
sqlParameter7 = new SqlParameter("@IPAddress", SqlDbType.VarChar, 50);
sqlParameter7.Value = (object)DBNull.Value;
}
sqlParameterArray[index6] = sqlParameter7;
int index7 = 6;
SqlParameter sqlParameter8;
if (model.URL != null)
{
SqlParameter sqlParameter5 = new SqlParameter("@URL", SqlDbType.VarChar, -1);
sqlParameter5.Value = (object)model.URL;
sqlParameter8 = sqlParameter5;
}
else
{
sqlParameter8 = new SqlParameter("@URL", SqlDbType.VarChar, -1);
sqlParameter8.Value = (object)DBNull.Value;
}
sqlParameterArray[index7] = sqlParameter8;
int index8 = 7;
SqlParameter sqlParameter9;
if (model.Contents != null)
{
SqlParameter sqlParameter5 = new SqlParameter("@Contents", SqlDbType.VarChar, -1);
sqlParameter5.Value = (object)model.Contents;
sqlParameter9 = sqlParameter5;
}
else
{
sqlParameter9 = new SqlParameter("@Contents", SqlDbType.VarChar, -1);
sqlParameter9.Value = (object)DBNull.Value;
}
sqlParameterArray[index8] = sqlParameter9;
int index9 = 8;
SqlParameter sqlParameter10;
if (model.Others != null)
{
SqlParameter sqlParameter5 = new SqlParameter("@Others", SqlDbType.VarChar, -1);
sqlParameter5.Value = (object)model.Others;
sqlParameter10 = sqlParameter5;
}
else
{
sqlParameter10 = new SqlParameter("@Others", SqlDbType.VarChar, -1);
sqlParameter10.Value = (object)DBNull.Value;
}
sqlParameterArray[index9] = sqlParameter10;
int index10 = 9;
SqlParameter sqlParameter11;
if (model.OldXml != null)
{
SqlParameter sqlParameter5 = new SqlParameter("@OldXml", SqlDbType.VarChar, -1);
sqlParameter5.Value = (object)model.OldXml;
sqlParameter11 = sqlParameter5;
}
else
{
sqlParameter11 = new SqlParameter("@OldXml", SqlDbType.VarChar, -1);
sqlParameter11.Value = (object)DBNull.Value;
}
sqlParameterArray[index10] = sqlParameter11;
int index11 = 10;
SqlParameter sqlParameter12;
if (model.NewXml != null)
{
SqlParameter sqlParameter5 = new SqlParameter("@NewXml", SqlDbType.VarChar, -1);
sqlParameter5.Value = (object)model.NewXml;
sqlParameter12 = sqlParameter5;
}
else
{
sqlParameter12 = new SqlParameter("@NewXml", SqlDbType.VarChar, -1);
sqlParameter12.Value = (object)DBNull.Value;
}
sqlParameterArray[index11] = sqlParameter12;
int index12 = 11;
SqlParameter sqlParameter13 = new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1);
sqlParameter13.Value = (object)model.ID;
sqlParameterArray[index12] = sqlParameter13;
SqlParameter[] parameter = sqlParameterArray;
return(this.dbHelper.Execute(sql, parameter, false));
}
/// <summary>
/// 新增
/// </summary>
public static void Add(RoadFlow.Data.Model.Log model)
{
dgWriteLog wl = new dgWriteLog(add);
wl.BeginInvoke(model, null, null);
}
