/// <summary>
/// 获取车型实体
/// </summary>
/// <param name="CarTypeId">车型编号</param>
/// <returns>返回实体</returns>
public MComCarType GetModel(string CarTypeId)
{
MComCarType model = null;
string sql = "SELECT [CarTypeId],[CompanyId],[CarTypeName],[SeatNum],[Desc],[OperatorId],[Operator],[TemplateId] FROM [tbl_ComCarType] Where [CarTypeId]=@CarTypeId";
DbCommand cmd = this._db.GetSqlStringCommand(sql);
this._db.AddInParameter(cmd, "CarTypeId", DbType.AnsiStringFixedLength, CarTypeId);
using (IDataReader dr = DbHelper.ExecuteReader(cmd, _db))
{
if (dr != null && dr.Read())
{
model = new MComCarType()
{
CarTypeId = dr["CarTypeId"].ToString(),
CarTypeName = !dr.IsDBNull(dr.GetOrdinal("CarTypeName")) ? dr.GetString(dr.GetOrdinal("CarTypeName")) : null,
CompanyId = dr["CompanyId"].ToString(),
Desc = !dr.IsDBNull(dr.GetOrdinal("Desc")) ? dr.GetString(dr.GetOrdinal("Desc")) : null,
Operator = !dr.IsDBNull(dr.GetOrdinal("Operator")) ? dr.GetString(dr.GetOrdinal("Operator")) : null,
OperatorId = dr["OperatorId"].ToString(),
SeatNum = dr.GetInt32(dr.GetOrdinal("SeatNum")),
TemplateId = dr["TemplateId"].ToString()
};
}
}
return(model);
}
/// <summary>
/// 获取系统车型
/// </summary>
/// <param name="companyId">公司编号</param>
/// <returns></returns>
public IList <EyouSoft.Model.ComStructure.MComCarType> GetList(string companyId)
{
IList <EyouSoft.Model.ComStructure.MComCarType> list = null;
string query = "Select * from tbl_ComCarType where CompanyId=@CompanyId and IsDelete='0' ";
DbCommand cmd = _db.GetSqlStringCommand(query);
this._db.AddInParameter(cmd, "CompanyId", DbType.AnsiStringFixedLength, companyId);
using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._db))
{
list = new List <EyouSoft.Model.ComStructure.MComCarType>();
while (dr.Read())
{
MComCarType item = new MComCarType()
{
CarTypeId = dr["CarTypeId"].ToString(),
CarTypeName = !dr.IsDBNull(dr.GetOrdinal("CarTypeName")) ? dr.GetString(dr.GetOrdinal("CarTypeName")) : null,
CompanyId = dr["CompanyId"].ToString(),
Desc = !dr.IsDBNull(dr.GetOrdinal("Desc")) ? dr.GetString(dr.GetOrdinal("Desc")) : null,
Operator = !dr.IsDBNull(dr.GetOrdinal("Operator")) ? dr.GetString(dr.GetOrdinal("Operator")) : null,
OperatorId = dr["OperatorId"].ToString(),
SeatNum = dr.GetInt32(dr.GetOrdinal("SeatNum")),
TemplateId = dr["TemplateId"].ToString()
};
list.Add(item);
}
}
return(list);
}
/// <summary>
/// 修改车型
/// </summary>
/// <param name="model">车型实体</param>
/// <returns>0:失败 1:成功 2:计划有使用</returns>
public int UpdateComCarType(MComCarType model)
{
DbCommand cmd = this._db.GetStoredProcCommand("proc_ComCarType_Update");
this._db.AddInParameter(cmd, "CarTypeId", DbType.AnsiStringFixedLength, model.CarTypeId);
this._db.AddInParameter(cmd, "CarTypeName", DbType.String, model.CarTypeName);
this._db.AddInParameter(cmd, "SeatNum", DbType.Int32, model.SeatNum);
this._db.AddInParameter(cmd, "Desc", DbType.String, model.Desc);
this._db.AddInParameter(cmd, "TemplateId", DbType.AnsiStringFixedLength, model.TemplateId);
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>true:成功 false:失败</returns>
public bool AddComCarType(MComCarType model)
{
model.CarTypeId = Guid.NewGuid().ToString();
bool flg = dal.AddComCarType(model);
if (flg)
{
StringBuilder str = new StringBuilder();
str.AppendFormat("添加车型,车型编号:{0}", model.CarTypeId);
EyouSoft.BLL.SysStructure.BSysLogHandle.Insert(str.ToString());
}
return(flg);
}
/// <summary>
/// 修改车型
/// </summary>
/// <param name="model">车型实体</param>
/// <returns>0:失败 1:成功 2:计划有使用</returns>
public int UpdateComCarType(MComCarType model)
{
if (string.IsNullOrEmpty(model.CarTypeId))
{
throw new System.Exception("bll error:查询id为null或string.IsNullOrEmpty(id)==true。");
}
int flg = dal.UpdateComCarType(model);
if (flg == 1)
{
StringBuilder str = new StringBuilder();
str.AppendFormat("修改车型,车型编号:{0}", model.CarTypeId);
EyouSoft.BLL.SysStructure.BSysLogHandle.Insert(str.ToString());
}
return(flg);
}
/// <summary>
/// 分页获取车型
/// </summary>
/// <param name="pageIndex">当前页</param>
/// <param name="pageSize">每页显示记录数</param>
/// <param name="recordCount">总记录数</param>
/// <param name="companyId">公司编号</param>
/// <returns>车型集合</returns>
public IList <EyouSoft.Model.ComStructure.MComCarType> GetList(
int pageIndex,
int pageSize,
ref int recordCount,
string companyId)
{
IList <EyouSoft.Model.ComStructure.MComCarType> list = null;
string fileds = "CarTypeId,CompanyId,CarTypeName,SeatNum,[Desc],OperatorId,Operator,TemplateId";
string tableName = "tbl_ComCarType";
string sqlWhere = string.Format(" CompanyId='{0}' and IsDelete='0' ", companyId);
using (IDataReader dr = DbHelper.ExecuteReader(this._db,
pageSize,
pageIndex,
ref recordCount,
tableName,
"CarTypeId",
fileds,
sqlWhere,
" IssueTime desc "))
{
if (dr != null)
{
list = new List <EyouSoft.Model.ComStructure.MComCarType>();
while (dr.Read())
{
MComCarType item = new MComCarType()
{
CarTypeId = dr["CarTypeId"].ToString(),
CarTypeName = !dr.IsDBNull(dr.GetOrdinal("CarTypeName")) ? dr.GetString(dr.GetOrdinal("CarTypeName")) : null,
CompanyId = dr["CompanyId"].ToString(),
Desc = !dr.IsDBNull(dr.GetOrdinal("Desc")) ? dr.GetString(dr.GetOrdinal("Desc")) : null,
Operator = !dr.IsDBNull(dr.GetOrdinal("Operator")) ? dr.GetString(dr.GetOrdinal("Operator")) : null,
OperatorId = dr["OperatorId"].ToString(),
SeatNum = dr.GetInt32(dr.GetOrdinal("SeatNum")),
TemplateId = dr["TemplateId"].ToString()
};
list.Add(item);
}
}
}
return(list);
}
