/// <summary>
/// row to model
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private AMS.Model.AMS_HardAd DataRowToAMS_HardAd(DataRow dr)
{
AMS.Model.AMS_HardAd model = new Model.AMS_HardAd();
model.ID = int.Parse(dr["ID"].ToString());
model.CustomerId = int.Parse(dr["CustomerId"].ToString());
model.Number = dr["Number"].ToString();
model.Name = dr["Name"].ToString();
model.EffectDate = Convert.ToDateTime(dr["EffectDate"].ToString());
model.EndDate = Convert.ToDateTime(dr["EndDate"].ToString());
model.AdImage = (byte[])(dr["AdImage"]);
model.Describe = dr["Describe"].ToString();
model.Operator = int.Parse(dr["Operator"].ToString());
return(model);
}
/// <summary>
/// 删除硬广
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public string DeleteHardAd(Model.AMS_HardAd model)
{
try
{
if (!Dal_HardAd.Delete(model.ID))
{
return("删除硬广失败！");
}
return("");
}
catch (Exception ex)
{
return(ex.Message);
}
}
/// <summary>
/// 修改硬广
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public string UpdateHardAd(Model.AMS_HardAd model)
{
try
{
Model.AMS_HardAd Admodel = Dal_HardAd.GetModel(model.Name);
if (Admodel != null && Admodel.ID != model.ID)
{
return("该硬广已存在！");
}
if (!Dal_HardAd.Update(model))
{
return("修改失败！");
}
return(null);
}
catch (Exception ex)
{
return(ex.Message);
}
}
/// <summary>
/// 添加硬广
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public string AddNewHardAd(Model.AMS_HardAd model)
{
try
{
Model.AMS_HardAd Admodel = Dal_HardAd.GetModel(model.Name);
if (Admodel != null)
{
return("该硬广已存在!");
}
if (Dal_HardAd.Add(model) == 0)
{
return("添加信息失败!");
}
return("");
}
catch (Exception ex)
{
return(ex.Message);
}
}
/// <summary>
/// 获取硬广,并且执行添加到学校数据库操作
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static bool GetHardAd(int id)
{
try
{
Model.AMS_HardAd hardAdModel = AMS.ServiceProxy.IHardAdService.GetHardAdModelByNum(id);
if (hardAdModel != null)
{
SeatManage.ClassModel.HardAdvertInfo seathardAdvert = SeatManage.Bll.AMS_HardAd.GetHardAdvertByNum(hardAdModel.Number);
if (seathardAdvert != null)
{
seathardAdvert.AdvertImage = hardAdModel.AdImage;
seathardAdvert.EffectDate = Convert.ToDateTime(hardAdModel.EffectDate);
seathardAdvert.EndDate = Convert.ToDateTime(hardAdModel.EndDate);
if (SeatManage.Bll.AMS_HardAd.UpdateHardAdvert(seathardAdvert) == SeatManage.EnumType.HandleResult.Successed)
{
return(true);
}
}
else
{
seathardAdvert = new SeatManage.ClassModel.HardAdvertInfo();
seathardAdvert.AdvertImage = hardAdModel.AdImage;
seathardAdvert.EffectDate = Convert.ToDateTime(hardAdModel.EffectDate);
seathardAdvert.EndDate = Convert.ToDateTime(hardAdModel.EndDate);
seathardAdvert.HardAdvertNo = hardAdModel.Number;
if (SeatManage.Bll.AMS_HardAd.AddHardAd(seathardAdvert) == SeatManage.EnumType.HandleResult.Successed)
{
return(true);
}
}
}
return(true);
}
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);
}