/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MyTest.Model.Sys_LogModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Sys_Log set ");
strSql.Append("F_Date=@F_Date,");
strSql.Append("F_Account=@F_Account,");
strSql.Append("F_NickName=@F_NickName,");
strSql.Append("F_Type=@F_Type,");
strSql.Append("F_IPAddress=@F_IPAddress,");
strSql.Append("F_IPAddressName=@F_IPAddressName,");
strSql.Append("F_ModuleId=@F_ModuleId,");
strSql.Append("F_ModuleName=@F_ModuleName,");
strSql.Append("F_Result=@F_Result,");
strSql.Append("F_Description=@F_Description,");
strSql.Append("F_CreatorTime=@F_CreatorTime,");
strSql.Append("F_CreatorUserId=@F_CreatorUserId");
strSql.Append(" where F_Id=@F_Id ");
SqlParameter[] parameters =
{
new SqlParameter("@F_Date", SqlDbType.DateTime),
new SqlParameter("@F_Account", SqlDbType.VarChar, 50),
new SqlParameter("@F_NickName", SqlDbType.VarChar, 50),
new SqlParameter("@F_Type", SqlDbType.VarChar, 50),
new SqlParameter("@F_IPAddress", SqlDbType.VarChar, 50),
new SqlParameter("@F_IPAddressName", SqlDbType.VarChar, 50),
new SqlParameter("@F_ModuleId", SqlDbType.VarChar, 50),
new SqlParameter("@F_ModuleName", SqlDbType.VarChar, 50),
new SqlParameter("@F_Result", SqlDbType.Bit, 1),
new SqlParameter("@F_Description", SqlDbType.VarChar, 500),
new SqlParameter("@F_CreatorTime", SqlDbType.DateTime),
new SqlParameter("@F_CreatorUserId", SqlDbType.VarChar, 50),
new SqlParameter("@F_Id", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.F_Date;
parameters[1].Value = model.F_Account;
parameters[2].Value = model.F_NickName;
parameters[3].Value = model.F_Type;
parameters[4].Value = model.F_IPAddress;
parameters[5].Value = model.F_IPAddressName;
parameters[6].Value = model.F_ModuleId;
parameters[7].Value = model.F_ModuleName;
parameters[8].Value = model.F_Result;
parameters[9].Value = model.F_Description;
parameters[10].Value = model.F_CreatorTime;
parameters[11].Value = model.F_CreatorUserId;
parameters[12].Value = model.F_Id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MyTest.Model.Sys_LogModel GetModel(string F_Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 F_Id,F_Date,F_Account,F_NickName,F_Type,F_IPAddress,F_IPAddressName,F_ModuleId,F_ModuleName,F_Result,F_Description,F_CreatorTime,F_CreatorUserId from Sys_Log ");
strSql.Append(" where F_Id=@F_Id ");
SqlParameter[] parameters =
{
new SqlParameter("@F_Id", SqlDbType.VarChar, 50)
};
parameters[0].Value = F_Id;
MyTest.Model.Sys_LogModel model = new MyTest.Model.Sys_LogModel();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MyTest.Model.Sys_LogModel DataRowToModel(DataRow row)
{
MyTest.Model.Sys_LogModel model = new MyTest.Model.Sys_LogModel();
if (row != null)
{
if (row["F_Id"] != null)
{
model.F_Id = row["F_Id"].ToString();
}
if (row["F_Date"] != null && row["F_Date"].ToString() != "")
{
model.F_Date = DateTime.Parse(row["F_Date"].ToString());
}
if (row["F_Account"] != null)
{
model.F_Account = row["F_Account"].ToString();
}
if (row["F_NickName"] != null)
{
model.F_NickName = row["F_NickName"].ToString();
}
if (row["F_Type"] != null)
{
model.F_Type = row["F_Type"].ToString();
}
if (row["F_IPAddress"] != null)
{
model.F_IPAddress = row["F_IPAddress"].ToString();
}
if (row["F_IPAddressName"] != null)
{
model.F_IPAddressName = row["F_IPAddressName"].ToString();
}
if (row["F_ModuleId"] != null)
{
model.F_ModuleId = row["F_ModuleId"].ToString();
}
if (row["F_ModuleName"] != null)
{
model.F_ModuleName = row["F_ModuleName"].ToString();
}
if (row["F_Result"] != null && row["F_Result"].ToString() != "")
{
if ((row["F_Result"].ToString() == "1") || (row["F_Result"].ToString().ToLower() == "true"))
{
model.F_Result = true;
}
else
{
model.F_Result = false;
}
}
if (row["F_Description"] != null)
{
model.F_Description = row["F_Description"].ToString();
}
if (row["F_CreatorTime"] != null && row["F_CreatorTime"].ToString() != "")
{
model.F_CreatorTime = DateTime.Parse(row["F_CreatorTime"].ToString());
}
if (row["F_CreatorUserId"] != null)
{
model.F_CreatorUserId = row["F_CreatorUserId"].ToString();
}
}
return(model);
}
