/// <summary>
/// 删除Path_Info
/// </summary>
/// <param name="id">线路Id</param>
/// <returns>此次操作影响的行数</returns>
public int DeletePathInfo(int id)
{
if (pathInfodal == null)
{
pathInfodal = new PathInfoDal();
}
int result = pathInfodal.DeletePathInfo(id);
return result;
}
/// <summary>
/// 增加Path_Info
/// </summary>
/// <param name="strCondition">查询条件</param>
/// <returns>返回的记录表信息</returns>
public DataTable SelectPathInfo(string strCondition)
{
if (pathInfodal == null)
{
pathInfodal = new PathInfoDal();
}
DataTable dt = pathInfodal.SelectPathInfo(strCondition);
return dt;
}
/// <summary>
/// 修改Path_Info
/// </summary>
/// <param name="pathInfo">线路信息类对象</param>
/// <returns>此次操作影响的行数</returns>
public int UpdatePathInfo(PathInfoModel pathInfo,out string strMessage)
{
if (pathInfodal == null)
{
pathInfodal = new PathInfoDal();
}
int result = pathInfodal.UpdatePathInfo(pathInfo,out strMessage);
return result;
}
public DataTable GetEmpInfo(string deptID)
{
if (pathInfodal == null)
{
pathInfodal = new PathInfoDal();
}
DataSet ds = pathInfodal.GetEmpInfo(deptID);
DataTable dt;
if (ds == null || ds.Tables.Count < 0)
{
dt = new DataTable();
}
else
{
dt = ds.Tables[0];
}
return dt;
}
/// <summary>
/// 查询巡检路径
/// </summary>
/// <param name="strPathNo">路线编号</param>
public DataTable SelectPathEmpRelation(string strPathNo)
{
if (pathInfodal == null)
{
pathInfodal = new PathInfoDal();
}
DataTable dt = new DataTable();
DataSet ds = pathInfodal.GetPathEmpRelationTable(strPathNo);
if (ds!=null && ds.Tables.Count>0)
{
dt = ds.Tables[0];
}
return dt;
}
/// <summary>
/// 添加巡检路径
/// </summary>
/// <param name="pathDetail"></param>
/// <returns></returns>
public int InsertPathDetail(PathDetailModel pathDetail)
{
if (pathInfodal == null)
{
pathInfodal = new PathInfoDal();
}
int result = pathInfodal.InsertPathDetail(pathDetail);
return result;
}
public void DeletePathDetail(string pathNo, int stationAddress, int stationHeadAddress)
{
if (pathInfodal == null)
{
pathInfodal = new PathInfoDal();
}
pathInfodal.DeletePathDetail(pathNo, stationAddress, stationHeadAddress);
}
public void DeletePathDetail(int id, string pathNo)
{
if (pathInfodal == null)
{
pathInfodal = new PathInfoDal();
}
pathInfodal.DeletePathDetail(id, pathNo);
}
/// <summary>
/// 查询巡检路径
/// </summary>
/// <param name="strWhere"></param>
public DataTable SelectPathDetail(string strWhere)
{
if (pathInfodal == null)
{
pathInfodal = new PathInfoDal();
}
DataTable dt = pathInfodal.SelectPathDetailInfo(strWhere);
return dt;
}