/// <summary>
/// 得到一个对象实体
/// </summary>
public AMS.Model.AMS_PrintTemplate GetModel(string No)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,CustomerId,Name,Number,Operator,Template,EffectDate,EndDate,Describe from AMS_PrintTemplate ");
strSql.Append(" where Number=@Number");
SqlParameter[] parameters =
{
new SqlParameter("@Number", SqlDbType.NVarChar)
};
parameters[0].Value = No;
AMS.Model.AMS_PrintTemplate model = new AMS.Model.AMS_PrintTemplate();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Id"] != null && ds.Tables[0].Rows[0]["Id"].ToString() != "")
{
model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString());
}
if (ds.Tables[0].Rows[0]["CustomerId"] != null && ds.Tables[0].Rows[0]["CustomerId"].ToString() != "")
{
model.CustomerId = int.Parse(ds.Tables[0].Rows[0]["CustomerId"].ToString());
}
if (ds.Tables[0].Rows[0]["Name"] != null && ds.Tables[0].Rows[0]["Name"].ToString() != "")
{
model.Name = ds.Tables[0].Rows[0]["Name"].ToString();
}
if (ds.Tables[0].Rows[0]["Number"] != null && ds.Tables[0].Rows[0]["Number"].ToString() != "")
{
model.Number = ds.Tables[0].Rows[0]["Number"].ToString();
}
if (ds.Tables[0].Rows[0]["Operator"] != null && ds.Tables[0].Rows[0]["Operator"].ToString() != "")
{
model.Operator = int.Parse(ds.Tables[0].Rows[0]["Operator"].ToString());
}
if (ds.Tables[0].Rows[0]["Template"] != null && ds.Tables[0].Rows[0]["Template"].ToString() != "")
{
model.Template = ds.Tables[0].Rows[0]["Template"].ToString();
}
if (ds.Tables[0].Rows[0]["EffectDate"] != null && ds.Tables[0].Rows[0]["EffectDate"].ToString() != "")
{
model.EffectDate = DateTime.Parse(ds.Tables[0].Rows[0]["EffectDate"].ToString());
}
if (ds.Tables[0].Rows[0]["EndDate"] != null && ds.Tables[0].Rows[0]["EndDate"].ToString() != "")
{
model.EndDate = DateTime.Parse(ds.Tables[0].Rows[0]["EndDate"].ToString());
}
if (ds.Tables[0].Rows[0]["Describe"] != null && ds.Tables[0].Rows[0]["Describe"].ToString() != "")
{
model.Describe = ds.Tables[0].Rows[0]["Describe"].ToString();
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(AMS.Model.AMS_PrintTemplate model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update AMS_PrintTemplate set ");
strSql.Append("CustomerId=@CustomerId,");
strSql.Append("Name=@Name,");
strSql.Append("Number=@Number,");
strSql.Append("Operator=@Operator,");
strSql.Append("Template=@Template,");
strSql.Append("EffectDate=@EffectDate,");
strSql.Append("EndDate=@EndDate,");
strSql.Append("Describe=@Describe");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@CustomerId", SqlDbType.Int, 4),
new SqlParameter("@Name", SqlDbType.NVarChar, 20),
new SqlParameter("@Number", SqlDbType.NVarChar, 20),
new SqlParameter("@Operator", SqlDbType.Int, 4),
new SqlParameter("@Template", SqlDbType.Text),
new SqlParameter("@EffectDate", SqlDbType.DateTime),
new SqlParameter("@EndDate", SqlDbType.DateTime),
new SqlParameter("@Describe", SqlDbType.NVarChar, 200),
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = model.CustomerId;
parameters[1].Value = model.Name;
parameters[2].Value = model.Number;
parameters[3].Value = model.Operator;
parameters[4].Value = model.Template;
parameters[5].Value = model.EffectDate;
parameters[6].Value = model.EndDate;
parameters[7].Value = model.Describe;
parameters[8].Value = model.Id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
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);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(AMS.Model.AMS_PrintTemplate model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into AMS_PrintTemplate(");
strSql.Append("CustomerId,Name,Number,Operator,Template,EffectDate,EndDate,Describe)");
strSql.Append(" values (");
strSql.Append("@CustomerId,@Name,@Number,@Operator,@Template,@EffectDate,@EndDate,@Describe)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@CustomerId", SqlDbType.Int, 4),
new SqlParameter("@Name", SqlDbType.NVarChar, 20),
new SqlParameter("@Number", SqlDbType.NVarChar, 20),
new SqlParameter("@Operator", SqlDbType.Int, 4),
new SqlParameter("@Template", SqlDbType.Text),
new SqlParameter("@EffectDate", SqlDbType.DateTime),
new SqlParameter("@EndDate", SqlDbType.DateTime),
new SqlParameter("@Describe", SqlDbType.NVarChar, 200)
};
parameters[0].Value = model.CustomerId;
parameters[1].Value = model.Name;
parameters[2].Value = model.Number;
parameters[3].Value = model.Operator;
parameters[4].Value = model.Template;
parameters[5].Value = model.EffectDate;
parameters[6].Value = model.EndDate;
parameters[7].Value = model.Describe;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 添加新的打印模板
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static string AddNewPrintTemplate(AMS.Model.AMS_PrintTemplate model)
{
AMS.IBllService.IAdvertManageBllService bllService = AMS.ServiceConnectChannel.AdvertManageBllServiceChannel.CreateServiceChannel();
try
{
return(bllService.AddNewPrintTemplate(model));
}
catch (EndpointNotFoundException ex)
{
throw new AMS.Model.CustomerException("连接服务器失败");
}
catch (CommunicationException ex)
{
throw ex;
}
catch (Exception ex)
{
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="id"></param>
/// <returns></returns>
public static bool GetPrintTemplate(int id)
{
try
{
AMS.Model.AMS_PrintTemplate printTemplate = AMS.ServiceProxy.IPrintTemplateService.GetPrintTemplateByNum(id);
if (printTemplate != null)
{
SeatManage.ClassModel.AMS_PrintTemplateModel model = new SeatManage.ClassModel.AMS_PrintTemplateModel();
model.Describe = printTemplate.Describe;
model.EndDate = Convert.ToDateTime(printTemplate.EndDate);
model.EffectDate = Convert.ToDateTime(printTemplate.EffectDate);
model.Template = printTemplate.Template;
model.Num = printTemplate.Number;
List <string> imagesName = GetImagesName(model.Template);
//下载打印模版中的图片
AMS.ServiceProxy.FileOperate fileOperate = new AMS.ServiceProxy.FileOperate();
for (int i = 0; i < imagesName.Count; i++)
{
string fileFullName = string.Format(@"{0}{1}", ServiceSet.TempFilePath, imagesName[i]);
if (!File.Exists(fileFullName))//文件不存在，则下载。
{
if (fileOperate.FileDownLoad(fileFullName, imagesName[i], SeatManage.EnumType.SeatManageSubsystem.SeatSlip) != "")
{
return(false);//下载失败，返回false；
}
}
}
//下载完成，执行上传操作。
SeatManage.Bll.FileOperate seatFileOperate = new SeatManage.Bll.FileOperate();
for (int i = 0; i < imagesName.Count; i++)
{
string fileFullName = string.Format(@"{0}{1}", ServiceSet.TempFilePath, imagesName[i]);
if (File.Exists(fileFullName))//文件不存在，则下载。
{
if (!seatFileOperate.UpdateFile(fileFullName, imagesName[i], SeatManage.EnumType.SeatManageSubsystem.SeatSlip))
{
return(false);//下载失败，返回false；
}
}
}
if (SeatManage.Bll.T_SM_PrintTemplate.GetPrintTemplateByNum(printTemplate.Number) == null)
{
if (SeatManage.Bll.T_SM_PrintTemplate.AddPrintTemplate(model) == SeatManage.EnumType.HandleResult.Successed)
{
//打印模板添加成功，上传文件
for (int i = 0; i < imagesName.Count; i++)
{
string fileFullName = string.Format(@"{0}{1}", ServiceSet.TempFilePath, imagesName[i]);
if (File.Exists(fileFullName))//文件存在则删除。
{
File.Delete(fileFullName);
}
}
return(true);
}
else
{
return(false);
}
}
else
{
if (SeatManage.Bll.T_SM_PrintTemplate.UpdatePrintTemplate(model) == SeatManage.EnumType.HandleResult.Successed)
{
//打印模板添加成功，上传文件
for (int i = 0; i < imagesName.Count; i++)
{
string fileFullName = string.Format(@"{0}{1}", ServiceSet.TempFilePath, imagesName[i]);
if (File.Exists(fileFullName))//文件存在则删除。
{
File.Delete(fileFullName);
}
}
return(true);
}
else
{
return(false);
}
}
}
else
{
//如果获取为空的，也作完成操作
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
}
