private string AddSql(SpareResourceTypeEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" insert into dbo.t_resource_type(");
strSql.Append("name,");
strSql.Append("directory,");
strSql.Append("insert_people,");
strSql.Append("insert_time");
strSql.Append(")values(");
strSql.Append("'" + model.Name + "',");
strSql.Append("'" + model.Directory + "',");
if (model.insert_user != null)
{
strSql.Append("'" + model.insert_user.Name + "',");
}
else
{
strSql.Append("NULL,");
}
strSql.Append("getdate()");
strSql.Append(")");
return(strSql.ToString());
}
private SpareResourceTypeEntity ReadBind(IDataReader dataReader)
{
SpareResourceTypeEntity model = new SpareResourceTypeEntity();
model.Id = CommonDBCheck.ToInt(dataReader["id"]);
model.Name = CommonDBCheck.ToString(dataReader["name"]);
model.Directory = CommonDBCheck.ToString(dataReader["directory"]);
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(SpareResourceTypeEntity model)
{
try
{
string strSql = AddSql(model);
ExecuteNonQuery(strSql.ToString());
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model"></param>
public void Update(SpareResourceTypeEntity model)
{
try
{
DBResourceType db = new DBResourceType();
db.Update(model);
}
catch (Exception e)
{
throw;
}
}
private string UpdateSql(SpareResourceTypeEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" UPDATE dbo.t_resource_type SET");
strSql.Append(" name = '" + model.Name + "',");
if (model.update_user != null)
{
strSql.Append(" update_people = '" + model.update_user.Name + "',");
}
strSql.Append(" update_time = getdate()");
strSql.Append(" where id = '" + model.Id + "'");
return(strSql.ToString());
}
/// <summary>
/// 通过ID取得数据信息
/// </summary>
/// <param name="id"></param>
public SpareResourceTypeEntity GetInfo(int id)
{
SpareResourceTypeEntity model = new SpareResourceTypeEntity();
try
{
string strSql = GetInfoSql(id);
using (IDataReader dataReader = ExecuteReader(strSql))
{
if (dataReader.Read())
{
model = ReadBind(dataReader);
}
}
return(model);
}
catch (Exception e)
{
throw e;
}
}
