/// <summary>
/// 获取车型模板
/// </summary>
/// <returns></returns>
public IList <EyouSoft.Model.SysStructure.MSysCarType> GetCarTypeList()
{
IList <EyouSoft.Model.SysStructure.MSysCarType> list = null;
DbCommand cmd = this._db.GetSqlStringCommand(_SQL_SELECT_GETCarTemplateList);
using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._db))
{
if (dr != null)
{
list = new List <EyouSoft.Model.SysStructure.MSysCarType>();
while (dr.Read())
{
EyouSoft.Model.SysStructure.MSysCarType CarType = new EyouSoft.Model.SysStructure.MSysCarType();
CarType.TemplateId = dr["TemplateId"].ToString();
CarType.Id = Utils.GetInt(dr["Id"].ToString());
CarType.SeatNum = dr.IsDBNull(dr.GetOrdinal("SeatNum")) ? 0 : dr.GetInt32(dr.GetOrdinal("SeatNum"));
CarType.IsDefault = dr.IsDBNull(dr.GetOrdinal("IsDefault")) ? false : dr.GetString(dr.GetOrdinal("IsDefault")) == "1" ? true : false;
CarType.FilePath = dr.IsDBNull(dr.GetOrdinal("FilePath")) ? string.Empty : dr.GetString(dr.GetOrdinal("FilePath"));
CarType.list = GetCarTypeSeatByXML(dr["SeatList"].ToString());
list.Add(CarType);
}
}
}
return(list);
}
/// <summary>
/// 添加车型模板
/// </summary>
/// <param name="model"></param>
/// <returns>1:成功，0：失败 </returns>
public int AddSysCarType(EyouSoft.Model.SysStructure.MSysCarType model)
{
DbCommand cmd = this._db.GetStoredProcCommand("proc_SysCarType_Add_Template");
this._db.AddInParameter(cmd, "TemplateId", DbType.AnsiStringFixedLength, model.TemplateId);
this._db.AddInParameter(cmd, "Id", DbType.Int32, model.Id);
this._db.AddInParameter(cmd, "IsDefault", DbType.Boolean, model.IsDefault == true ? 1 : 0);
this._db.AddInParameter(cmd, "FilePath", DbType.String, model.FilePath);
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="strID">模板编号</param>
public void Bindrpt_busBoxList(string strID)
{
EyouSoft.BLL.SysStructure.BSysCarType bll = new EyouSoft.BLL.SysStructure.BSysCarType();
EyouSoft.Model.SysStructure.MSysCarType model = bll.GetCarTypeById(strID);
if (model != null)
{
if (model.list != null && model.list.Count > 0)
{
rpt_busBoxList.DataSource = model.list;
rpt_busBoxList.DataBind();
}
else
{
ret_SeatHtml(model.SeatNum);
}
}
}
/// <summary>
/// 根据模板编号获取车型模板
/// </summary>
/// <param name="TemplateId"></param>
/// <returns></returns>
public EyouSoft.Model.SysStructure.MSysCarType GetCarTypeById(string TemplateId)
{
EyouSoft.Model.SysStructure.MSysCarType CarType = null;
DbCommand cmd = this._db.GetSqlStringCommand(SQL_SELECT_GetCarTypeTemplaterInfo);
this._db.AddInParameter(cmd, "TemplateId", DbType.AnsiStringFixedLength, TemplateId);
using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._db))
{
if (dr != null)
{
while (dr.Read())
{
CarType = new EyouSoft.Model.SysStructure.MSysCarType();
CarType.TemplateId = dr["TemplateId"].ToString();
CarType.SeatNum = dr.IsDBNull(dr.GetOrdinal("SeatNum")) ? 0 : dr.GetInt32(dr.GetOrdinal("SeatNum"));
CarType.IsDefault = dr.IsDBNull(dr.GetOrdinal("IsDefault")) ? false : dr.GetString(dr.GetOrdinal("IsDefault")) == "1" ? true : false;
CarType.FilePath = dr.IsDBNull(dr.GetOrdinal("FilePath")) ? string.Empty : dr.GetString(dr.GetOrdinal("FilePath"));
CarType.list = GetCarTypeSeatByXML(dr["SeatList"].ToString());
}
}
}
return(CarType);
}
/// <summary>
/// 添加车型模板
/// </summary>
/// <param name="model"></param>
/// <returns>1:成功，0：失败 </returns>
public bool AddSysCarType(EyouSoft.Model.SysStructure.MSysCarType model)
{
model.TemplateId = Guid.NewGuid().ToString();
return(dal.AddSysCarType(model) == 1 ? true : false);
}
