/// <summary>对象实体绑定数据
///
/// </summary>
/// <param name="dataReader">IDataReader对象</param>
/// <returns>返回实体对象</returns>
public Nikita.Assist.CodeMaker.Model.Bse_User ReaderBind(IDataReader dataReader)
{
Nikita.Assist.CodeMaker.Model.Bse_User model = new Nikita.Assist.CodeMaker.Model.Bse_User();
object ojb;
ojb = dataReader["User_Id"];
if (ojb != null && ojb != DBNull.Value)
{
model.User_Id = int.Parse(ojb.ToString());
}
model.UserName = dataReader["UserName"].ToString();
model.Password = dataReader["Password"].ToString();
model.TrueName = dataReader["TrueName"].ToString();
model.Company = dataReader["Company"].ToString();
ojb = dataReader["CreateDate"];
if (ojb != null && ojb != DBNull.Value)
{
model.CreateDate = DateTime.Parse(ojb.ToString());
}
ojb = dataReader["State"];
if (ojb != null && ojb != DBNull.Value)
{
model.State = int.Parse(ojb.ToString());
}
return(model);
}
/// <summary>得到一个对象实体
///
/// </summary>
/// <param name="User_Id">主键</param>
/// <returns>返回对象实体</returns>
public Nikita.Assist.CodeMaker.Model.Bse_User GetModel(int User_Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from Bse_User ");
strSql.Append(" where User_Id=@User_Id ");
DataAccess4DBHelper.IDbHelper h = GlobalHelpDemoForm.GetDataAccessHelper();
h.CreateCommand(strSql.ToString());
h.AddParameter("@User_Id", User_Id);
Nikita.Assist.CodeMaker.Model.Bse_User model = null;
using (IDataReader dataReader = h.ExecuteReader())
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
h.CloseConn();
}
return(model);
}
/// <summary>根据条件得到一个对象实体
///
/// </summary>
/// <param name="strCond">条件</param>
/// <returns>返回对象实体</returns>
public Nikita.Assist.CodeMaker.Model.Bse_User GetModelByCond(string strCond)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from Bse_User ");
if (!string.IsNullOrEmpty(strCond))
{
strSql.Append(" where " + strCond);
}
DataAccess4DBHelper.IDbHelper h = GlobalHelpDemoForm.GetDataAccessHelper();
h.CreateCommand(strSql.ToString());
Nikita.Assist.CodeMaker.Model.Bse_User model = null;
using (IDataReader dataReader = h.ExecuteReader())
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
h.CloseConn();
}
return(model);
}
/// <summary>增加一条数据
///
/// </summary>
/// <param name="model">实体对象</param>
/// <returns>返回新增实体ID</returns>
public int Add(Nikita.Assist.CodeMaker.Model.Bse_User model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Bse_User(");
strSql.Append("UserName, Password, TrueName, Company, CreateDate, State )");
strSql.Append(" values (");
strSql.Append("@UserName, @Password, @TrueName, @Company, @CreateDate, @State )");
strSql.Append(";select @@IDENTITY");
DataAccess4DBHelper.IDbHelper h = GlobalHelpDemoForm.GetDataAccessHelper();
h.CreateCommand(strSql.ToString());
if (model.UserName == null)
{
h.AddParameter("@UserName", DBNull.Value);
}
else
{
h.AddParameter("@UserName", model.UserName);
}
if (model.Password == null)
{
h.AddParameter("@Password", DBNull.Value);
}
else
{
h.AddParameter("@Password", model.Password);
}
if (model.TrueName == null)
{
h.AddParameter("@TrueName", DBNull.Value);
}
else
{
h.AddParameter("@TrueName", model.TrueName);
}
if (model.Company == null)
{
h.AddParameter("@Company", DBNull.Value);
}
else
{
h.AddParameter("@Company", model.Company);
}
if (model.CreateDate == null)
{
h.AddParameter("@CreateDate", DBNull.Value);
}
else
{
h.AddParameter("@CreateDate", model.CreateDate);
}
if (model.State == null)
{
h.AddParameter("@State", DBNull.Value);
}
else
{
h.AddParameter("@State", model.State);
}
int intResult;
string strObj = h.ExecuteScalar();
if (!int.TryParse(strObj, out intResult))
{
return(0);
}
return(intResult);
}
/// <summary>更新一条数据
///
/// </summary>
/// <param name="model">实体对象</param>
/// <returns>返回受影响的行数</returns>
public bool Update(Nikita.Assist.CodeMaker.Model.Bse_User model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Bse_User set ");
strSql.Append("UserName=@UserName, Password=@Password, TrueName=@TrueName, Company=@Company, CreateDate=@CreateDate, State=@State ");
strSql.Append(" where User_Id=@User_Id ");
DataAccess4DBHelper.IDbHelper h = GlobalHelpDemoForm.GetDataAccessHelper();
h.CreateCommand(strSql.ToString());
if (model.User_Id == null)
{
h.AddParameter("@User_Id", DBNull.Value);
}
else
{
h.AddParameter("@User_Id", model.User_Id);
}
if (model.UserName == null)
{
h.AddParameter("@UserName", DBNull.Value);
}
else
{
h.AddParameter("@UserName", model.UserName);
}
if (model.Password == null)
{
h.AddParameter("@Password", DBNull.Value);
}
else
{
h.AddParameter("@Password", model.Password);
}
if (model.TrueName == null)
{
h.AddParameter("@TrueName", DBNull.Value);
}
else
{
h.AddParameter("@TrueName", model.TrueName);
}
if (model.Company == null)
{
h.AddParameter("@Company", DBNull.Value);
}
else
{
h.AddParameter("@Company", model.Company);
}
if (model.CreateDate == null)
{
h.AddParameter("@CreateDate", DBNull.Value);
}
else
{
h.AddParameter("@CreateDate", model.CreateDate);
}
if (model.State == null)
{
h.AddParameter("@State", DBNull.Value);
}
else
{
h.AddParameter("@State", model.State);
}
return(h.ExecuteNonQuery());
}