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