/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(abc.Model.Model.SysLog model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SysLog set ");
strSql.Append("SysFrom=SQL2012SysFrom,");
strSql.Append("Module=SQL2012Module,");
strSql.Append("Activity=SQL2012Activity,");
strSql.Append("Level=SQL2012Level,");
strSql.Append("Content=SQL2012Content,");
strSql.Append("CurrLoginIp=SQL2012CurrLoginIp,");
strSql.Append("CurrLoginTime=SQL2012CurrLoginTime");
strSql.Append(" where LogId=SQL2012LogId");
SqlParameter[] parameters =
{
new SqlParameter("SQL2012SysFrom", SqlDbType.Int, 4),
new SqlParameter("SQL2012Module", SqlDbType.VarChar, 255),
new SqlParameter("SQL2012Activity", SqlDbType.VarChar, 255),
new SqlParameter("SQL2012Level", SqlDbType.Int, 4),
new SqlParameter("SQL2012Content", SqlDbType.VarChar, 255),
new SqlParameter("SQL2012CurrLoginIp", SqlDbType.VarChar, 255),
new SqlParameter("SQL2012CurrLoginTime", SqlDbType.DateTime),
new SqlParameter("SQL2012LogId", SqlDbType.Int, 4),
new SqlParameter("SQL2012MemberId", SqlDbType.Int, 4)
};
parameters[0].Value = model.SysFrom;
parameters[1].Value = model.Module;
parameters[2].Value = model.Activity;
parameters[3].Value = model.Level;
parameters[4].Value = model.Content;
parameters[5].Value = model.CurrLoginIp;
parameters[6].Value = model.CurrLoginTime;
parameters[7].Value = model.LogId;
parameters[8].Value = model.MemberId;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public abc.Model.Model.SysLog DataRowToModel(DataRow row)
{
abc.Model.Model.SysLog model = new abc.Model.Model.SysLog();
if (row != null)
{
if (row["LogId"] != null && row["LogId"].ToString() != "")
{
model.LogId = int.Parse(row["LogId"].ToString());
}
if (row["MemberId"] != null && row["MemberId"].ToString() != "")
{
model.MemberId = int.Parse(row["MemberId"].ToString());
}
if (row["SysFrom"] != null && row["SysFrom"].ToString() != "")
{
model.SysFrom = int.Parse(row["SysFrom"].ToString());
}
if (row["Module"] != null)
{
model.Module = row["Module"].ToString();
}
if (row["Activity"] != null)
{
model.Activity = row["Activity"].ToString();
}
if (row["Level"] != null && row["Level"].ToString() != "")
{
model.Level = int.Parse(row["Level"].ToString());
}
if (row["Content"] != null)
{
model.Content = row["Content"].ToString();
}
if (row["CurrLoginIp"] != null)
{
model.CurrLoginIp = row["CurrLoginIp"].ToString();
}
if (row["CurrLoginTime"] != null && row["CurrLoginTime"].ToString() != "")
{
model.CurrLoginTime = DateTime.Parse(row["CurrLoginTime"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(abc.Model.Model.SysLog model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SysLog(");
strSql.Append("MemberId,SysFrom,Module,Activity,Level,Content,CurrLoginIp,CurrLoginTime)");
strSql.Append(" values (");
strSql.Append("SQL2012MemberId,SQL2012SysFrom,SQL2012Module,SQL2012Activity,SQL2012Level,SQL2012Content,SQL2012CurrLoginIp,SQL2012CurrLoginTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("SQL2012MemberId", SqlDbType.Int, 4),
new SqlParameter("SQL2012SysFrom", SqlDbType.Int, 4),
new SqlParameter("SQL2012Module", SqlDbType.VarChar, 255),
new SqlParameter("SQL2012Activity", SqlDbType.VarChar, 255),
new SqlParameter("SQL2012Level", SqlDbType.Int, 4),
new SqlParameter("SQL2012Content", SqlDbType.VarChar, 255),
new SqlParameter("SQL2012CurrLoginIp", SqlDbType.VarChar, 255),
new SqlParameter("SQL2012CurrLoginTime", SqlDbType.DateTime)
};
parameters[0].Value = model.MemberId;
parameters[1].Value = model.SysFrom;
parameters[2].Value = model.Module;
parameters[3].Value = model.Activity;
parameters[4].Value = model.Level;
parameters[5].Value = model.Content;
parameters[6].Value = model.CurrLoginIp;
parameters[7].Value = model.CurrLoginTime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public abc.Model.Model.SysLog GetModel(int LogId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 LogId,MemberId,SysFrom,Module,Activity,Level,Content,CurrLoginIp,CurrLoginTime from SysLog ");
strSql.Append(" where LogId=SQL2012LogId");
SqlParameter[] parameters =
{
new SqlParameter("SQL2012LogId", SqlDbType.Int, 4)
};
parameters[0].Value = LogId;
abc.Model.Model.SysLog model = new abc.Model.Model.SysLog();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
