public Model.Enum.HandleResult AddSlipPrintInfo(List <Model.View_SlipPrintInfo> model)
{
try
{
foreach (Model.View_SlipPrintInfo models in model)
{
Model.AMS_Campus campusModel = GetSingleCampusInfo(models.SchoolNumber, false);
Model.AMS_SlipCustomer slipCustomer = GetSlipCustomerByNum(models.SlipCustomerNum);
if (slipCustomer != null)
{
models.CampusId = campusModel.Id;
models.SlipCustomerId = slipCustomer.Id;
Model.AMS_SlipPrintInfo addmodel = new Model.AMS_SlipPrintInfo
{
SlipCustomerId = models.SlipCustomerId,
Date = models.Date,
CampusId = models.CampusId,
LookOverAmount = models.LookOverAmount,
PrintAmount = models.PrintAmount
};
SlipPrintDal.Add(addmodel);
}
}
return(HandleResult.Successed);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// model转换
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private AMS.Model.AMS_SlipCustomer DataRowToAMS_SlipCustomerModel(DataRow dr)
{
//CustomerNo,CompanyName,CustomerLinkWay,CustomerDescribe,Id,Number,SlipName,ImageUrl
//SlipTemplate,CouponsXml,OperatorLonginId,OperatorPwd,OperatorBranchName
//OperatorName,OperatorRemark,SlipCustomerDescribe,IsPrint,Type,EndDate
//EffectDate,CampusNum,CustomerImage
AMS.Model.AMS_SlipCustomer model = new Model.AMS_SlipCustomer();
model.Id = int.Parse(dr["Id"].ToString());
model.Number = dr["Number"].ToString();
if (dr.Table.Columns.Contains("CompanyName"))
{
model.CustomerName = dr["CompanyName"].ToString();
}
model.CustomerId = Convert.ToInt32(dr["CustomerId"]);
model.CustomerImage = dr["CustomerImage"].ToString();
model.EffectDate = DateTime.Parse(dr["EffectDate"].ToString());
model.EndDate = DateTime.Parse(dr["EndDate"].ToString());
model.ImageUrl = dr["ImageUrl"].ToString();
if (dr["IsPrint"].ToString() == "0")
{
model.IsPrint = false;
}
else
{
model.IsPrint = true;
}
model.SlipName = dr["SlipName"].ToString();
model.SlipTemplate = dr["SlipTemplate"].ToString();
if (dr.Table.Columns.Contains("OperatorName"))
{
model.OperatorName = dr["OperatorName"].ToString();
}
model.CampusNum = dr["CampusNum"].ToString();
return(model);
}
public string DeleteSlipCustomer(Model.AMS_SlipCustomer model)
{
try
{
if (!dal_SlipCustomer.Delete(model.Id))
{
return("优惠券删除失败！");
}
return("");
}
catch (Exception ex)
{
return(ex.Message);
}
}
public Model.AMS_SlipCustomer GetSlipCustomerByNum(string Num)
{
try
{
Model.AMS_SlipCustomer modellist = new Model.AMS_SlipCustomer();
string sql = string.Format(" Number='{0}'", Num);
DataSet ds = dal_SlipCustomerView.GetList(sql);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
modellist = DataRowToAMS_SlipCustomerModel(ds.Tables[0].Rows[i]);
}
return(modellist);
}
catch (Exception ex)
{
throw ex;
}
}
public string UpdateSlipCustomer(Model.AMS_SlipCustomer model)
{
try
{
Model.AMS_SlipCustomer sameModel = dal_SlipCustomer.GetModel(model.Number);
if (sameModel != null && sameModel.Id != model.Id)
{
return("优惠券编号重复！");
}
if (!dal_SlipCustomer.Update(model))
{
return("优惠券修改失败！");
}
return("");
}
catch (Exception ex)
{
return(ex.Message);
}
}
public string AddNewSlipCustomer(Model.AMS_SlipCustomer model)
{
try
{
Model.AMS_SlipCustomer sameModel = dal_SlipCustomer.GetModel(model.Number);
if (sameModel != null)
{
return("优惠券编号重复！");
}
if (dal_SlipCustomer.Add(model) == 0)
{
return("优惠券添加失败！");
}
return("");
}
catch (Exception ex)
{
return(ex.Message);
}
}
public Model.AMS_SlipCustomer GetSlipCustomerById(int ID)
{
try
{
Model.AMS_SlipCustomer modellist = new Model.AMS_SlipCustomer();
string sql = string.Format(" ID={0}", ID);
DataSet ds = dal_SlipReleaseCampusView.GetList(sql);
if (ds.Tables[0].Rows.Count < 1)
{
return(null);
}
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
modellist = DataRowToAMS_SlipReleaseCampusModel(ds.Tables[0].Rows[i]);
}
return(modellist);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 根据ID获取优惠券信息
/// </summary>
/// <returns></returns>
public static bool GetSlipCustomer(int num)
{
//TODO:未测试
try
{
Model.AMS_SlipCustomer advertModel = AMS.ServiceProxy.ISlipCustomerService.GetSlipCustomerByID(num);
AMS.ServiceProxy.FileOperate advertfileOperate = new AMS.ServiceProxy.FileOperate();
SeatManage.Bll.FileOperate seatmanagefileOperate = new SeatManage.Bll.FileOperate();
if (advertModel != null)
{
SeatManage.ClassModel.AMS_SlipCustomer seatModel = SeatManage.Bll.AMS_SlipCustomer.GetSlipCustomerByNum(advertModel.Number);
if (seatModel == null)
{
//优惠券在数据库中不存在：先执行下载操作，然后更新
string ImageUrlFullName = string.Format(@"{0}{1}", ServiceSet.TempFilePath, advertModel.ImageUrl);
try
{
advertfileOperate.FileDownLoad(ImageUrlFullName, advertModel.ImageUrl, SeatManage.EnumType.SeatManageSubsystem.SlipCustomer);
}
catch (Exception ex)
{
SeatManage.SeatManageComm.WriteLog.Write(string.Format("优惠券{0}下载失败：{1}", advertModel.Number, ex.Message));
}
try
{
if (seatmanagefileOperate.UpdateFile(ImageUrlFullName, advertModel.ImageUrl, SeatManage.EnumType.SeatManageSubsystem.SlipCustomer))
{
//上传完成，执行删除操作
File.Delete(ImageUrlFullName);
}
else
{
return(false);
}
}
catch (Exception ex)
{
SeatManage.SeatManageComm.WriteLog.Write(string.Format("优惠券{0}上传失败：{1}", advertModel.Number, ex.Message));
}
string CustomerImagefullName = string.Format(@"{0}{1}", ServiceSet.TempFilePath, advertModel.CustomerImage);
advertfileOperate.FileDownLoad(CustomerImagefullName, advertModel.CustomerImage, SeatManage.EnumType.SeatManageSubsystem.SlipCustomer);
if (seatmanagefileOperate.UpdateFile(CustomerImagefullName, advertModel.CustomerImage, SeatManage.EnumType.SeatManageSubsystem.SlipCustomer))
{
File.Delete(CustomerImagefullName);
}
else
{
return(false);
}
if (Convert.ToBoolean(advertModel.IsPrint))
{
XmlDocument Templatedoc = new XmlDocument();
Templatedoc.LoadXml(advertModel.SlipTemplate);
XmlElement Templateroot = Templatedoc.DocumentElement;
XmlNodeList Templatexnlist = ((XmlNode)Templateroot).ChildNodes;
for (int j = 0; j < Templatexnlist.Count; j++)
{
if (Templatexnlist[j].Name == "Pic")
{
try
{
advertfileOperate.FileDownLoad((ServiceSet.TempFilePath + Templatexnlist[j].InnerText), Templatexnlist[j].InnerText, SeatManage.EnumType.SeatManageSubsystem.SlipCustomer);
}
catch (Exception ex)
{
SeatManage.SeatManageComm.WriteLog.Write(string.Format("优惠券{0}下载失败：{1}", advertModel.Number, ex.Message));
}
try
{
if (seatmanagefileOperate.UpdateFile((ServiceSet.TempFilePath + Templatexnlist[j].InnerText), Templatexnlist[j].InnerText, SeatManage.EnumType.SeatManageSubsystem.SlipCustomer))
{
//上传完成，执行删除操作
File.Delete(ServiceSet.TempFilePath + Templatexnlist[j].InnerText);
}
else
{
return(false);
}
}
catch (Exception ex)
{
SeatManage.SeatManageComm.WriteLog.Write(string.Format("优惠券{0}上传失败：{1}", advertModel.Number, ex.Message));
}
}
}
}
}
if (seatModel != null && seatModel.CampusNum == advertModel.CampusNum)
{
//获取学校数据库中的优惠券。如果存在并且校区编号相同执行更新。
seatModel.CampusNum = advertModel.CampusNum;
seatModel.CustomerLogo = advertModel.CustomerImage;
seatModel.EffectDate = Convert.ToDateTime(advertModel.EffectDate);
seatModel.EndDate = Convert.ToDateTime(advertModel.EndDate);
seatModel.ImageName = advertModel.ImageUrl;
seatModel.No = advertModel.Number;
seatModel.SlipTemplate = advertModel.SlipTemplate;
seatModel.IsPrint = Convert.ToBoolean(advertModel.IsPrint);
SeatManage.Bll.AMS_SlipCustomer.UpdateSlipCustomer(seatModel);
}
else
{
seatModel = new SeatManage.ClassModel.AMS_SlipCustomer();
seatModel.CampusNum = advertModel.CampusNum;
seatModel.CustomerLogo = advertModel.CustomerImage;
seatModel.EffectDate = Convert.ToDateTime(advertModel.EffectDate);
seatModel.EndDate = Convert.ToDateTime(advertModel.EndDate);
seatModel.ImageName = advertModel.ImageUrl;
seatModel.No = advertModel.Number;
seatModel.SlipTemplate = advertModel.SlipTemplate;
seatModel.IsPrint = Convert.ToBoolean(advertModel.IsPrint);
seatModel.Num = advertModel.Number;
SeatManage.Bll.AMS_SlipCustomer.AddSlipCustomer(seatModel);
}
}
return(true);
}
catch (Exception ex)
{
SeatManage.SeatManageComm.WriteLog.Write(string.Format("获取优惠券客户失败：{0}", ex.Message));
return(false);
}
}
/// <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);
}
