/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ECommerce.Admin.Model.RegisterUserInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update RegisterUserInfo set ");
strSql.Append("ProvinceId=@ProvinceId,");
strSql.Append("CityId=@CityId,");
strSql.Append("DistrictId=@DistrictId,");
strSql.Append("Address=@Address,");
strSql.Append("Phone=@Phone,");
strSql.Append("Addtime=@Addtime,");
strSql.Append("Name=@Name");
strSql.Append(" where RUID=@RUID ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "RUID", DbType.Int32, model.RUID);
db.AddInParameter(dbCommand, "ProvinceId", DbType.String, model.ProvinceId);
db.AddInParameter(dbCommand, "CityId", DbType.String, model.CityId);
db.AddInParameter(dbCommand, "DistrictId", DbType.AnsiString, model.DistrictId);
db.AddInParameter(dbCommand, "Address", DbType.String, model.Address);
db.AddInParameter(dbCommand, "Phone", DbType.AnsiString, model.Phone);
db.AddInParameter(dbCommand, "Addtime", DbType.DateTime, model.Addtime);
db.AddInParameter(dbCommand, "Name", DbType.String, model.Name);
int rows = db.ExecuteNonQuery(dbCommand);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ECommerce.Admin.Model.RegisterUserInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into RegisterUserInfo(");
strSql.Append("ProvinceId,CityId,DistrictId,Address,Phone,Addtime,Name)");
strSql.Append(" values (");
strSql.Append("@ProvinceId,@CityId,@DistrictId,@Address,@Phone,@Addtime,@Name)");
strSql.Append(";select @@IDENTITY");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "ProvinceId", DbType.String, model.ProvinceId);
db.AddInParameter(dbCommand, "CityId", DbType.String, model.CityId);
db.AddInParameter(dbCommand, "DistrictId", DbType.AnsiString, model.DistrictId);
db.AddInParameter(dbCommand, "Address", DbType.String, model.Address);
db.AddInParameter(dbCommand, "Phone", DbType.AnsiString, model.Phone);
db.AddInParameter(dbCommand, "Addtime", DbType.DateTime, model.Addtime);
db.AddInParameter(dbCommand, "Name", DbType.String, model.Name);
int result;
object obj = db.ExecuteScalar(dbCommand);
if (!int.TryParse(obj.ToString(), out result))
{
return(0);
}
return(result);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ECommerce.Admin.Model.RegisterUserInfo GetModel(int RUID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select RUID,ProvinceId,CityId,DistrictId,Address,Phone,Addtime,Name from RegisterUserInfo ");
strSql.Append(" where RUID=@RUID ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "RUID", DbType.Int32, RUID);
ECommerce.Admin.Model.RegisterUserInfo model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ECommerce.Admin.Model.RegisterUserInfo DataRowToModel(DataRow row)
{
ECommerce.Admin.Model.RegisterUserInfo model = new ECommerce.Admin.Model.RegisterUserInfo();
if (row != null)
{
if (row["RUID"] != null && row["RUID"].ToString() != "")
{
model.RUID = Convert.ToInt32(row["RUID"].ToString());
}
if (row["ProvinceId"] != null)
{
model.ProvinceId = row["ProvinceId"].ToString();
}
if (row["CityId"] != null)
{
model.CityId = row["CityId"].ToString();
}
if (row["DistrictId"] != null)
{
model.DistrictId = row["DistrictId"].ToString();
}
if (row["Address"] != null)
{
model.Address = row["Address"].ToString();
}
if (row["Phone"] != null)
{
model.Phone = row["Phone"].ToString();
}
if (row["Addtime"] != null && row["Addtime"].ToString() != "")
{
model.Addtime = Convert.ToDateTime(row["Addtime"].ToString());
}
if (row["Name"] != null)
{
model.Name = row["Name"].ToString();
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ECommerce.Admin.Model.RegisterUserInfo DataRowToModel(DataRow row)
{
ECommerce.Admin.Model.RegisterUserInfo model=new ECommerce.Admin.Model.RegisterUserInfo();
if (row != null)
{
if(row["RUID"]!=null && row["RUID"].ToString()!="")
{
model.RUID=Convert.ToInt32(row["RUID"].ToString());
}
if(row["ProvinceId"]!=null)
{
model.ProvinceId=row["ProvinceId"].ToString();
}
if(row["CityId"]!=null)
{
model.CityId=row["CityId"].ToString();
}
if(row["DistrictId"]!=null)
{
model.DistrictId=row["DistrictId"].ToString();
}
if(row["Address"]!=null)
{
model.Address=row["Address"].ToString();
}
if(row["Phone"]!=null)
{
model.Phone=row["Phone"].ToString();
}
if(row["Addtime"]!=null && row["Addtime"].ToString()!="")
{
model.Addtime=Convert.ToDateTime(row["Addtime"].ToString());
}
if(row["Name"]!=null)
{
model.Name=row["Name"].ToString();
}
}
return model;
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public ECommerce.Admin.Model.RegisterUserInfo ReaderBind(IDataReader dataReader)
{
ECommerce.Admin.Model.RegisterUserInfo model = new ECommerce.Admin.Model.RegisterUserInfo();
object ojb;
ojb = dataReader["RUID"];
if (ojb != null && ojb != DBNull.Value)
{
model.RUID = Convert.ToInt32(ojb);
}
model.ProvinceId = dataReader["ProvinceId"].ToString();
model.CityId = dataReader["CityId"].ToString();
model.DistrictId = dataReader["DistrictId"].ToString();
model.Address = dataReader["Address"].ToString();
model.Phone = dataReader["Phone"].ToString();
ojb = dataReader["Addtime"];
if (ojb != null && ojb != DBNull.Value)
{
model.Addtime = Convert.ToDateTime(ojb);
}
model.Name = dataReader["Name"].ToString();
return(model);
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public ECommerce.Admin.Model.RegisterUserInfo ReaderBind(IDataReader dataReader)
{
ECommerce.Admin.Model.RegisterUserInfo model=new ECommerce.Admin.Model.RegisterUserInfo();
object ojb;
ojb = dataReader["RUID"];
if(ojb != null && ojb != DBNull.Value)
{
model.RUID=Convert.ToInt32(ojb);
}
model.ProvinceId=dataReader["ProvinceId"].ToString();
model.CityId=dataReader["CityId"].ToString();
model.DistrictId=dataReader["DistrictId"].ToString();
model.Address=dataReader["Address"].ToString();
model.Phone=dataReader["Phone"].ToString();
ojb = dataReader["Addtime"];
if(ojb != null && ojb != DBNull.Value)
{
model.Addtime=Convert.ToDateTime(ojb);
}
model.Name=dataReader["Name"].ToString();
return model;
}
