public List <Model.AMS_CommandList> GetCommandListByCondition(int schoolId, Model.Enum.CommandType commandType, Model.Enum.CommandHandleResult handleResult)
{
StringBuilder strWhere = new StringBuilder();
if (schoolId != -1)
{
strWhere.AppendFormat(" SchoolId={0} ", schoolId);
}
if (commandType != Model.Enum.CommandType.None)
{
if (string.IsNullOrEmpty(strWhere.ToString()))
{
strWhere.AppendFormat(" Command={0}", (int)commandType);
}
else
{
strWhere.AppendFormat(" and Command={0}", (int)commandType);
}
}
if (handleResult != Model.Enum.CommandHandleResult.None)
{
if (string.IsNullOrEmpty(strWhere.ToString()))
{
strWhere.AppendFormat(" FinishFlag={0}", (int)handleResult);
}
else
{
strWhere.AppendFormat(" and FinishFlag={0}", (int)handleResult);
}
}
List <Model.AMS_CommandList> listModel = new List <Model.AMS_CommandList>();
DataSet ds = ComDal.GetList(strWhere.ToString());
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
listModel.Add(DataRowToAMS_CammandListModel(ds.Tables[0].Rows[i]));
}
return(listModel);
}
/// <summary>
/// 根据参数值获取命令列表
/// </summary>
/// <param name="schoolId">学校Id</param>
/// <param name="commandType">命令类型</param>
/// <param name="handleResult">学校Id</param>
/// <returns></returns>
public static List <Model.AMS_CommandList> GetCommandListByCondition(int schoolId, Model.Enum.CommandType commandType, Model.Enum.CommandHandleResult handleResult)
{
AMS.IBllService.IAdvertManageBllService bllService = AMS.ServiceConnectChannel.AdvertManageBllServiceChannel.CreateServiceChannel();
bool error = false;
try
{
return(bllService.GetCommandListByCondition(schoolId, commandType, handleResult));
}
catch (Exception ex)
{
error = true;
SeatManage.SeatManageComm.WriteLog.Write(string.Format("根据学校编号获取设备列表遇到错误，异常来自：{0}；信息：{1}", ex.Source, ex.Message));
throw ex;
}
finally
{
ICommunicationObject ICommObjectService = bllService as ICommunicationObject;
try
{
if (ICommObjectService.State == CommunicationState.Faulted)
{
ICommObjectService.Abort();
}
else
{
ICommObjectService.Close();
}
}
catch
{
ICommObjectService.Abort();
}
}
}
/// <summary>
/// 根据条件获取相关记录
/// </summary>
/// <param name="schoolId"></param>
/// <param name="commandType"></param>
/// <param name="handleResult"></param>
/// <returns></returns>
public static List <AdvertManage.Model.AMS_CommandListModel> GetCommandListByCondition(int schoolId, Model.Enum.CommandType commandType, Model.Enum.CommandHandleResult handleResult)
{
IWCFService.IAdvertManageService advertService = WcfAccessProxy.AMS_ServiceProxy.CreateChannelAdvertManageService();
bool error = false;
try
{
return(advertService.GetCommandListByCondition(schoolId, commandType, handleResult));
}
catch (Exception ex)
{
error = true;
SeatManage.SeatManageComm.WriteLog.Write(string.Format("添加下发命令失败 ，异常来自：{0}；信息：{1}", ex.Source, ex.Message));
throw ex;
}
finally
{
ICommunicationObject ICommObjectService = advertService as ICommunicationObject;
try
{
if (ICommObjectService.State == CommunicationState.Faulted)
{
ICommObjectService.Abort();
}
else
{
ICommObjectService.Close();
}
}
catch
{
ICommObjectService.Abort();
}
}
}
/// <summary>
/// 根据条件获取命令
/// </summary>
/// <param name="schoolId"></param>
/// <param name="commandType"></param>
/// <param name="handleResult"></param>
/// <returns></returns>
public List <AdvertManage.Model.AMS_CommandListModel> GetCommandListByCondition(int schoolId, Model.Enum.CommandType commandType, Model.Enum.CommandHandleResult handleResult)
{
StringBuilder strWhere = new StringBuilder();
if (schoolId != -1)
{
strWhere.Append(" SchoolId=@SchoolId ");
}
if (commandType != Model.Enum.CommandType.None)
{
if (string.IsNullOrEmpty(strWhere.ToString()))
{
strWhere.Append(" Command=@Command");
}
else
{
strWhere.Append(" and Command=@Command");
}
}
if (handleResult != Model.Enum.CommandHandleResult.None)
{
if (string.IsNullOrEmpty(strWhere.ToString()))
{
strWhere.Append(" FinishFlag=@FinishFlag");
}
else
{
strWhere.Append(" and FinishFlag=@FinishFlag");
}
}
SqlParameter[] parameters =
{
new SqlParameter("@SchoolId", schoolId),
new SqlParameter("@Command", commandType),
new SqlParameter("@FinishFlag", handleResult),
};
List <AdvertManage.Model.AMS_CommandListModel> listModel = new List <Model.AMS_CommandListModel>();
DataSet ds = commandDal.GetList(strWhere.ToString(), parameters);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
listModel.Add(DataRowToAMS_CammandListModel(ds.Tables[0].Rows[i]));
}
return(listModel);
}
