/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(SeatManage.ClassModel.AMS_PrintTemplateModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_SM_PrintTemplate(");
strSql.Append("Template,UsedTimeStart,UsedTimeEnd,IsUsed,Describe,Num)");
strSql.Append(" values (");
strSql.Append("@Template,@UsedTimeStart,@UsedTimeEnd,@IsUsed,@Describe,@Num)");
SqlParameter[] parameters =
{
new SqlParameter("@Template", SqlDbType.Text),
new SqlParameter("@UsedTimeStart", SqlDbType.DateTime),
new SqlParameter("@UsedTimeEnd", SqlDbType.DateTime),
new SqlParameter("@IsUsed", SqlDbType.Int, 4),
new SqlParameter("@Describe", SqlDbType.NVarChar, 200),
new SqlParameter("@Num", model.Num)
};
parameters[0].Value = model.Template;
parameters[1].Value = model.EffectDate;
parameters[2].Value = model.EndDate;
parameters[3].Value = 1;
parameters[4].Value = model.Describe;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(SeatManage.ClassModel.AMS_PrintTemplateModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_SM_PrintTemplate set ");
strSql.Append("Template=@Template,");
strSql.Append("UsedTimeStart=@UsedTimeStart,");
strSql.Append("UsedTimeEnd=@UsedTimeEnd,");
strSql.Append("IsUsed=@IsUsed,");
strSql.Append("Describe=@Describe");
strSql.Append(" where Num=@Num ");
SqlParameter[] parameters =
{
new SqlParameter("@Template", SqlDbType.Text),
new SqlParameter("@UsedTimeStart", SqlDbType.DateTime),
new SqlParameter("@UsedTimeEnd", SqlDbType.DateTime),
new SqlParameter("@IsUsed", SqlDbType.Int, 4),
new SqlParameter("@Describe", SqlDbType.NVarChar, 200),
new SqlParameter("@Num", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.Template;
parameters[1].Value = model.EffectDate;
parameters[2].Value = model.EndDate;
parameters[3].Value = 1;
parameters[4].Value = model.Describe;
parameters[5].Value = model.Num;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <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;
}
}
