/// <summary>
/// 获取上车地点实体
/// </summary>
/// <param name="CarLocationId">上车地点编号</param>
/// <returns>上车地点实体</returns>
public MComCarLocation GetModel(string CarLocationId)
{
MComCarLocation model = null;
string sql = "SELECT [CarLocationId],[CompanyId],[Location],[OffPrice],[OnPrice],[Desc],[Status],[OperatorId],[Operator],[IsDelete] FROM [tbl_ComCarLocation] Where CarLocationId=@CarLocationId";
DbCommand cmd = _db.GetSqlStringCommand(sql);
this._db.AddInParameter(cmd, "CarLocationId", DbType.AnsiStringFixedLength, CarLocationId);
using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._db))
{
if (dr.Read())
{
model = new MComCarLocation()
{
CarLocationId = dr["CarLocationId"].ToString(),
CompanyId = dr["CompanyId"].ToString(),
Desc = !dr.IsDBNull(dr.GetOrdinal("Desc")) ? dr.GetString(dr.GetOrdinal("Desc")) : null,
Location = !dr.IsDBNull(dr.GetOrdinal("Location")) ? dr.GetString(dr.GetOrdinal("Location")) : null,
OffPrice = dr.GetDecimal(dr.GetOrdinal("OffPrice")),
OnPrice = dr.GetDecimal(dr.GetOrdinal("OnPrice")),
Operator = dr.GetString(dr.GetOrdinal("Operator")),
OperatorId = dr.GetString(dr.GetOrdinal("OperatorId")),
Status = dr.GetString(dr.GetOrdinal("Status")) == "1" ? true : false
};
}
}
return(model);
}
/// <summary>
/// 获取上车地点列表
/// </summary>
/// <param name="pageIndex">当前页</param>
/// <param name="pageSize">当前页记录数</param>
/// <param name="recordCount">总记录数</param>
/// <param name="companyId">公司编号</param>
///<param name="status">启用or 禁用</param>
///<param name="location">上车地点</param>
/// <returns>结果集</returns>
public IList <EyouSoft.Model.ComStructure.MComCarLocation> GetList(int pageIndex, int pageSize, ref int recordCount, string companyId, bool?status, string location)
{
IList <EyouSoft.Model.ComStructure.MComCarLocation> list = null;
string fileds = "[CarLocationId],[CompanyId],[Location],[OffPrice],[OnPrice],[Desc],[Status],[OperatorId],[Operator]";
StringBuilder query = new StringBuilder();
query.AppendFormat("CompanyId='{0}' and IsDelete='0' ", companyId);
if (status.HasValue)
{
query.AppendFormat(" and Status='{0}' ", status.Value == true ? 1 : 0);
}
if (!string.IsNullOrEmpty(location))
{
query.AppendFormat(" and Location like '%{0}%' ", location);
}
using (IDataReader dr = DbHelper.ExecuteReader(this._db, pageSize,
pageIndex,
ref recordCount,
"tbl_ComCarLocation",
"CarLocationId",
fileds,
query.ToString(),
"Status Desc"))
{
if (dr != null)
{
list = new List <EyouSoft.Model.ComStructure.MComCarLocation>();
while (dr.Read())
{
MComCarLocation item = new MComCarLocation()
{
CarLocationId = dr["CarLocationId"].ToString(),
CompanyId = dr["CompanyId"].ToString(),
Desc = !dr.IsDBNull(dr.GetOrdinal("Desc")) ? dr.GetString(dr.GetOrdinal("Desc")) : null,
Location = !dr.IsDBNull(dr.GetOrdinal("Location")) ? dr.GetString(dr.GetOrdinal("Location")) : null,
OffPrice = dr.GetDecimal(dr.GetOrdinal("OffPrice")),
OnPrice = dr.GetDecimal(dr.GetOrdinal("OnPrice")),
Status = dr.GetString(dr.GetOrdinal("Status")) == "1" ? true : false,
Operator = !dr.IsDBNull(dr.GetOrdinal("Operator")) ? dr.GetString(dr.GetOrdinal("Operator")) : null,
OperatorId = dr["OperatorId"].ToString()
};
list.Add(item);
}
}
}
return(list);
}
/// <summary>
/// 修改上车地点
/// </summary>
/// <param name="model">上车地点实体</param>
/// <returns>1:成功，0：失败,2:该上车地点已被计划使用</returns>
public int UpdateCarLocation(MComCarLocation model)
{
DbCommand cmd = this._db.GetStoredProcCommand("proc_ComCarLocation_Update");
this._db.AddInParameter(cmd, "CarLocationId", DbType.AnsiStringFixedLength, model.CarLocationId);
this._db.AddInParameter(cmd, "Location", DbType.String, model.Location);
this._db.AddInParameter(cmd, "OffPrice", DbType.Currency, model.OffPrice);
this._db.AddInParameter(cmd, "OnPrice", DbType.Currency, model.OnPrice);
this._db.AddInParameter(cmd, "Desc", DbType.String, model.Desc);
this._db.AddInParameter(cmd, "Status", DbType.AnsiStringFixedLength, model.Status == true ? 1 : 0);
this._db.AddOutParameter(cmd, "Result", DbType.Int32, 4);
DbHelper.RunProcedureWithResult(cmd, this._db);
return(Convert.ToInt32(this._db.GetParameterValue(cmd, "Result")));
}
/// <summary>
/// 添加上车地点
/// </summary>
/// <param name="model">上车地点实体</param>
/// <returns></returns>
public bool AddCarLocation(MComCarLocation model)
{
DbCommand cmd = this._db.GetStoredProcCommand("proc_ComCarLocation_Add");
this._db.AddInParameter(cmd, "CarLocationId", DbType.AnsiStringFixedLength, model.CarLocationId);
this._db.AddInParameter(cmd, "CompanyId", DbType.AnsiStringFixedLength, model.CompanyId);
this._db.AddInParameter(cmd, "Location", DbType.String, model.Location);
this._db.AddInParameter(cmd, "OffPrice", DbType.Decimal, model.OffPrice);
this._db.AddInParameter(cmd, "OnPrice", DbType.Decimal, model.OnPrice);
this._db.AddInParameter(cmd, "Desc", DbType.String, model.Desc);
this._db.AddInParameter(cmd, "Status", DbType.AnsiStringFixedLength, model.Status == true ? 1 : 0);
this._db.AddInParameter(cmd, "OperatorId", DbType.StringFixedLength, model.OperatorId);
this._db.AddInParameter(cmd, "Operator", DbType.String, model.Operator);
this._db.AddOutParameter(cmd, "Result", DbType.Int32, 4);
DbHelper.RunProcedureWithResult(cmd, this._db);
return(Convert.ToInt32(this._db.GetParameterValue(cmd, "Result")) == 1 ? true : false);
}
