/// <summary>
/// 对象实体绑定数据
/// </summary>
public SOSOshop.Model.MemberReceAddress ReaderBind(IDataReader dataReader)
{
SOSOshop.Model.MemberReceAddress model = new SOSOshop.Model.MemberReceAddress();
object ojb;
ojb = dataReader["id"];
if (ojb != null && ojb != DBNull.Value)
{
model.ID = (int)ojb;
}
ojb = dataReader["uid"];
if (ojb != null && ojb != DBNull.Value)
{
model.UID = (int)ojb;
}
model.Name = dataReader["username"].ToString();
model.Mobile = dataReader["mobile"].ToString();
model.Phone = dataReader["phone"].ToString();
model.Province = dataReader["province"].ToString();
model.City = dataReader["city"].ToString();
model.Borough = dataReader["borough"].ToString();
model.Address = dataReader["address"].ToString();
model.Zip = dataReader["zip"].ToString();
model.Email = dataReader["email"].ToString();
model.ConstructionSigns = dataReader["constructionsigns"].ToString();
model.Consignestime = dataReader["consignestime"].ToString();
ojb = dataReader["stat"];
if (ojb != null && ojb != DBNull.Value)
{
model.Stat = (bool)ojb;
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(SOSOshop.Model.MemberReceAddress model, int uid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update memberreceaddress set ");
strSql.Append("username=@username,");
strSql.Append("mobile=@mobile,");
strSql.Append("phone=@phone,");
strSql.Append("province=@province,");
strSql.Append("city=@city,");
strSql.Append("borough=@borough,");
strSql.Append("address=@address,");
strSql.Append("zip=@zip,");
strSql.Append("email=@email,");
strSql.Append("constructionsigns=@constructionsigns,");
strSql.Append("consignestime=@consignestime,");
strSql.Append("stat=@stat");
strSql.Append(" where id=@id and uid=@uid");
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "id", DbType.Int32, model.ID);
db.AddInParameter(dbCommand, "uid", DbType.Int32, model.UID);
db.AddInParameter(dbCommand, "username", DbType.AnsiString, model.Name);
db.AddInParameter(dbCommand, "mobile", DbType.AnsiString, model.Mobile);
db.AddInParameter(dbCommand, "phone", DbType.AnsiString, model.Phone);
db.AddInParameter(dbCommand, "province", DbType.AnsiString, model.Province);
db.AddInParameter(dbCommand, "city", DbType.AnsiString, model.City);
db.AddInParameter(dbCommand, "borough", DbType.AnsiString, model.Borough);
db.AddInParameter(dbCommand, "address", DbType.AnsiString, model.Address);
db.AddInParameter(dbCommand, "zip", DbType.AnsiString, model.Zip);
db.AddInParameter(dbCommand, "email", DbType.AnsiString, model.Email);
db.AddInParameter(dbCommand, "constructionsigns", DbType.AnsiString, model.ConstructionSigns);
db.AddInParameter(dbCommand, "consignestime", DbType.AnsiString, model.Consignestime);
db.AddInParameter(dbCommand, "stat", DbType.Boolean, model.Stat);
int rows = db.ExecuteNonQuery(dbCommand);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SOSOshop.Model.MemberReceAddress GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,uid,username,mobile,phone,province,city,borough,address,zip,email,constructionsigns,consignestime,stat from memberreceaddress ");
strSql.Append(" where id=@id ");
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "id", DbType.Int32, id);
SOSOshop.Model.MemberReceAddress model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SOSOshop.Model.MemberReceAddress DataRowToModel(DataRow row)
{
SOSOshop.Model.MemberReceAddress model = new SOSOshop.Model.MemberReceAddress();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.ID = int.Parse(row["id"].ToString());
}
if (row["uid"] != null && row["uid"].ToString() != "")
{
model.UID = int.Parse(row["uid"].ToString());
}
if (row["username"] != null)
{
model.Name = row["username"].ToString();
}
if (row["mobile"] != null)
{
model.Mobile = row["mobile"].ToString();
}
if (row["phone"] != null)
{
model.Phone = row["phone"].ToString();
}
if (row["province"] != null)
{
model.Province = row["province"].ToString();
}
if (row["city"] != null)
{
model.City = row["city"].ToString();
}
if (row["borough"] != null)
{
model.Borough = row["borough"].ToString();
}
if (row["address"] != null)
{
model.Address = row["address"].ToString();
}
if (row["zip"] != null)
{
model.Zip = row["zip"].ToString();
}
if (row["email"] != null)
{
model.Email = row["email"].ToString();
}
if (row["constructionsigns"] != null)
{
model.ConstructionSigns = row["constructionsigns"].ToString();
}
if (row["consignestime"] != null)
{
model.Consignestime = row["consignestime"].ToString();
}
if (row["stat"] != null && row["stat"].ToString() != "")
{
if ((row["stat"].ToString() == "1") || (row["stat"].ToString().ToLower() == "true"))
{
model.Stat = true;
}
else
{
model.Stat = false;
}
}
}
return(model);
}
