public List <Model.View_CommandList> GetCommandList(string schoolId, AMS.Model.Enum.CommandType commandType, AMS.Model.Enum.CommandHandleResult handleResult) { try { List <Model.View_CommandList> modellist = new List <Model.View_CommandList>(); StringBuilder str = new StringBuilder(); //拼接学校编号。如果学校编号为-1,则标识查询所有的。 if (schoolId != "-1") { str.Append(" SchoolNum='" + schoolId + "'"); } //拼接命令类型,如果条件为空,则不加and if (string.IsNullOrEmpty(str.ToString())) { if (commandType != Model.Enum.CommandType.None) { str.AppendFormat(" Command={0} ", (int)commandType); } } else { if (commandType != Model.Enum.CommandType.None) { str.AppendFormat(" and Command={0}", (int)commandType); } } //拼接“处理结果” 参数 if (string.IsNullOrEmpty(str.ToString())) { if (handleResult != Model.Enum.CommandHandleResult.None)//不为None时,查询指定类型。 { str.AppendFormat(" FinishFlag={0}", (int)handleResult); } else {//参数值为None时,去掉已经成功的 str.AppendFormat(" FinishFlag<>{0}", (int)Model.Enum.CommandHandleResult.Success); } } else { if (handleResult != Model.Enum.CommandHandleResult.None)//不为None时,查询指定类型。 { str.AppendFormat(" and FinishFlag={0}", (int)handleResult); } else {//参数值为None时,去掉已经成功的 str.AppendFormat(" and FinishFlag<>{0}", (int)Model.Enum.CommandHandleResult.Success); } } DataSet ds = dal_CommandListView.GetList(str.ToString()); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { modellist.Add(DataRowToAMS_CommandListModel(ds.Tables[0].Rows[i])); } return(modellist); } catch (Exception ex) { throw ex; } }
/// <summary> /// 获取命令明细列表 /// </summary> /// <param name="schoolId"></param> /// <param name="commandType"></param> /// <param name="handleResult"></param> /// <returns></returns> public List <Model.AMS_CommandDetail> GetCommandDetailList(string schoolId, AMS.Model.Enum.CommandType commandType, AMS.Model.Enum.CommandHandleResult handleResult) { StringBuilder str = new StringBuilder(); List <AMS.Model.AMS_CommandDetail> commandDetailList = new List <Model.AMS_CommandDetail>(); List <Model.View_CommandList> commandList = GetCommandList(schoolId, commandType, handleResult); foreach (AMS.Model.View_CommandList cmdModel in commandList) { AMS.Model.AMS_CommandDetail cmd = new Model.AMS_CommandDetail(); switch (cmdModel.Command) { case Model.Enum.CommandType.Caputre: cmd.ContentDescribe = "获取截图"; cmd.ContentName = "获取截图"; break; case Model.Enum.CommandType.HardAd: Model.AMS_HardAd hardAd = Dal_HardAd.GetModelByNum(cmdModel.CommandId.Value); cmd.ContentName = hardAd.Name; cmd.ContentDescribe = hardAd.Describe; cmd.ContentNumber = hardAd.Number; cmd.ContentID = hardAd.ID; break; case Model.Enum.CommandType.Playlist: if (dal_Playlist.GetList(string.Format(" id={0}", cmdModel.CommandId.Value)).Tables[0].Rows.Count > 0) { Model.AMS_PlayList playList = DataRowToAMS_PlayListModel(dal_PlaylistView.GetList(string.Format(" id={0}", cmdModel.CommandId.Value)).Tables[0].Rows[0]); cmd.ContentName = playList.PlayListName; cmd.ContentDescribe = playList.Describe; cmd.ContentNumber = playList.Number; cmd.ContentID = playList.Id; } break; case Model.Enum.CommandType.PrintTemplate: if (dal_PrintTemplateView.GetList(string.Format(" id={0}", cmdModel.CommandId.Value)).Tables[0].Rows.Count > 0) { Model.AMS_PrintTemplate printTemplate = DataRowToAMS_PrintTemplateModel(dal_PrintTemplateView.GetList(string.Format(" id={0}", cmdModel.CommandId.Value)).Tables[0].Rows[0]); cmd.ContentName = printTemplate.Name; cmd.ContentNumber = printTemplate.Number; cmd.ContentDescribe = printTemplate.Describe; cmd.ContentID = printTemplate.Id; } break; case Model.Enum.CommandType.ProgramUpgrade: if (dal_ProgramUpgrade.GetList(string.Format(" id={0}", cmdModel.CommandId.Value)).Tables[0].Rows.Count > 0) { Model.ProgramUpgrade program = DataRowToAMS_ProgramUpgradeListModel(dal_ProgramUpgrade.GetList(string.Format(" id={0}", cmdModel.CommandId.Value)).Tables[0].Rows[0]); cmd.ContentName = ((AMS.Model.Enum.SeatManageSubsystem)program.Application).ToString(); cmd.ContentDescribe = program.Remark; cmd.ContentID = program.Id; } break; case Model.Enum.CommandType.SlipCustomer: if (dal_SlipCustomer.GetList(string.Format(" id={0}", cmdModel.CommandId.Value)).Tables[0].Rows.Count > 0) { Model.AMS_SlipCustomer slipcustomer = DataRowToAMS_SlipCustomerModel(dal_SlipCustomerView.GetList(string.Format(" id={0}", cmdModel.CommandId.Value)).Tables[0].Rows[0]); cmd.ContentName = slipcustomer.SlipName; cmd.ContentNumber = slipcustomer.Number; cmd.ContentDescribe = slipcustomer.Describe; cmd.ContentID = slipcustomer.Id; } break; case Model.Enum.CommandType.TitleAd: if (Dal_TitleAd.GetList(string.Format(" id={0}", cmdModel.CommandId.Value)).Tables[0].Rows.Count > 0) { Model.AMS_TitleAd titleAd = DataRowToAMS_TitleAd(Dal_TitleAd.GetList(string.Format(" id={0}", cmdModel.CommandId.Value)).Tables[0].Rows[0]); cmd.ContentName = titleAd.Name; cmd.ContentNumber = titleAd.Num; cmd.ContentID = titleAd.Id; } break; case Model.Enum.CommandType.RollTitles: if (dal.GetModel(string.Format(" id={0}", cmdModel.CommandId.Value)).Tables[0].Rows.Count > 0) { Model.AMS_RollTitles titleAd = DataRowToAMS_RollTitles(dal.GetModel(string.Format(" id={0}", cmdModel.CommandId.Value)).Tables[0].Rows[0]); cmd.ContentName = titleAd.Name; cmd.ContentNumber = titleAd.Num; cmd.ContentID = titleAd.ID; } break; } cmd.Command = cmdModel.Command; cmd.FinishFlag = cmdModel.FinishFlag; cmd.FinishTime = cmdModel.FinishTime; cmd.ID = cmdModel.ID; cmd.OperatorBranchName = cmdModel.OperatorBranchName; cmd.OperatorLoginId = cmdModel.OperatorLoginId; cmd.OperatorPwd = cmdModel.OperatorPwd; cmd.OperatorRemark = cmdModel.OperatorRemark; cmd.OperatorName = cmdModel.OperatorName; cmd.ReleaseTime = cmdModel.ReleaseTime; cmd.SchoolAddress = cmdModel.SchoolAddress; cmd.SchoolCardInfo = cmdModel.SchoolCardInfo; cmd.SchoolConnectionString = cmdModel.SchoolConnectionString; cmd.SchoolDescribe = cmdModel.SchoolDTUip; cmd.SchoolInterfaceInfo = cmdModel.SchoolInterfaceInfo; cmd.SchoolLinkMan = cmdModel.SchoolLinkMan; cmd.SchoolName = cmdModel.SchoolName; cmd.SchoolNum = cmdModel.SchoolNum; cmd.SchoolProvince = cmdModel.SchoolProvince; commandDetailList.Add(cmd); } return(commandDetailList); }