public string DeletePrintTemplate(Model.AMS_PrintTemplate model)
{
try
{
if (!dal_PrintTemplate.Delete(model.Id))
{
return("删除打印模板失败！");
}
return("");
}
catch (Exception ex)
{
return(ex.Message);
}
}
public AMS.Model.AMS_PrintTemplate GetPrintTemplateByNum(int Num)
{
try
{
Model.AMS_PrintTemplate modellist = new Model.AMS_PrintTemplate();
string sql = string.Format(" ID={0}", Num);
DataSet ds = dal_PrintTemplateView.GetList(null);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
modellist = DataRowToAMS_PrintTemplateModel(ds.Tables[0].Rows[i]);
}
return(modellist);
}
catch (Exception ex)
{
throw ex;
}
}
public string UpdatePrintTemplate(Model.AMS_PrintTemplate model)
{
try
{
AMS.Model.AMS_PrintTemplate sameModel = dal_PrintTemplate.GetModel(model.Number);
if (sameModel != null && sameModel.Id != model.Id)
{
return("模板编号重复！");
}
if (!dal_PrintTemplate.Update(model))
{
return("修改打印模板失败！");
}
return("");
}
catch (Exception ex)
{
return(ex.Message);
}
}
public string AddNewPrintTemplate(Model.AMS_PrintTemplate model)
{
try
{
AMS.Model.AMS_PrintTemplate sameModel = dal_PrintTemplate.GetModel(model.Number);
if (sameModel != null)
{
return("模板编号重复！");
}
if (dal_PrintTemplate.Add(model) == 0)
{
return("添加打印模板失败！");
}
return("");
}
catch (Exception ex)
{
return(ex.Message);
}
}
private AMS.Model.AMS_PrintTemplate DataRowToAMS_PrintTemplateModel(DataRow dr)
{
//CustomerName,Name,Number,Template,EffectDate,EndDate,Describe,CustomerNo,
//CustomerLinkWay,CustomerDescribe
//OperatorRemark,OperatorName,OperatorBranchName,OperatorPwd,OperatorLoginId
AMS.Model.AMS_PrintTemplate model = new Model.AMS_PrintTemplate();
model.Id = int.Parse(dr["ID"].ToString());
if (dr.Table.Columns.Contains("OperatorName"))
{
model.OperatorName = dr["OperatorName"].ToString();
}
model.CustomerId = int.Parse(dr["CustomerId"].ToString());
model.CustomerName = dr["CustomerName"].ToString();
model.Describe = dr["Describe"].ToString();
model.EffectDate = DateTime.Parse(dr["EffectDate"].ToString());
model.EndDate = DateTime.Parse(dr["EndDate"].ToString());
model.Name = dr["Name"].ToString();
model.Number = dr["Number"].ToString();
model.Template = dr["Template"].ToString();
return(model);
}
/// <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);
}
