public static HandleResult UpdatePrintTemplate(AMS_PrintTemplateModel model)
{
IWCFService.ISeatManageService seatService = WcfAccessProxy.ServiceProxy.CreateChannelSeatManageService();
bool error = false;
try
{
return(seatService.UpdatePrintTemplate(model));
}
catch (Exception ex)
{
error = true;
SeatManageComm.WriteLog.Write("添加打印模板失败：" + ex.Message);
return(EnumType.HandleResult.Failed);
}
finally
{
ICommunicationObject ICommObjectService = seatService as ICommunicationObject;
try
{
if (ICommObjectService.State == CommunicationState.Faulted)
{
ICommObjectService.Abort();
}
else
{
ICommObjectService.Close();
}
}
catch
{
ICommObjectService.Abort();
}
}
}
public AMS_PrintTemplateModel GetPrintTemplateByNum(string Num)
{
try
{
SeatManage.ClassModel.AMS_PrintTemplateModel list = new AMS_PrintTemplateModel();
StringBuilder strWhere = new StringBuilder();
strWhere.Append("Num=@Num");
SqlParameter[] parameters =
{
new SqlParameter("@Num", SqlDbType.NVarChar)
};
parameters[0].Value = Num;
DataSet ds = t_sm_PrintTemplate.GetList(strWhere.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
list = DataRowsToPrintTemplateModel(ds.Tables[0].Rows[0]);
}
else
{
return(null);
}
return(list);
}
catch
{
throw;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(AMS_PrintTemplateModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update AMS_PrintTemplate set ");
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("@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.Template;
parameters[1].Value = model.EffectDate;
parameters[2].Value = model.EndDate;
parameters[3].Value = model.Describe;
parameters[4].Value = model.Id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(AMS_PrintTemplateModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into AMS_PrintTemplate(");
strSql.Append(" Template,EffectDate,EndDate,Describe)");
strSql.Append(" values (");
strSql.Append(" @Template,@EffectDate,@EndDate,@Describe)");
SqlParameter[] parameters =
{
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.Template;
parameters[1].Value = model.EffectDate;
parameters[2].Value = model.EndDate;
parameters[3].Value = model.Describe;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
private static SeatManage.ClassModel.AMS_PrintTemplateModel DataRowsToPrintTemplateModel(DataRow dr)
{
//id,Template,UsedTimeStart,UsedTimeEnd,IsUsed,Describe
SeatManage.ClassModel.AMS_PrintTemplateModel model = new AMS_PrintTemplateModel();
model.Id = int.Parse(dr["id"].ToString());
model.Describe = dr["Describe"].ToString();
model.EffectDate = DateTime.Parse(dr["UsedTimeStart"].ToString());
model.EndDate = DateTime.Parse(dr["UsedTimeEnd"].ToString());
model.Template = dr["Template"].ToString();
model.Num = dr["Num"].ToString();
return(model);
}
public static HandleResult UpdatePrintTemplate(AMS_PrintTemplateModel model)
{
IWCFService.ISeatManageService seatService = new WcfServiceForSeatManage.SeatManageDateService();
bool error = false;
try
{
return(seatService.UpdatePrintTemplate(model));
}
catch (Exception ex)
{
error = true;
SeatManageComm.WriteLog.Write("添加打印模板失败：" + ex.Message);
return(EnumType.HandleResult.Failed);
}
}
public HandleResult UpdatePrintTemplate(AMS_PrintTemplateModel model)
{
try
{
if (t_sm_PrintTemplate.Update(model))
{
return(HandleResult.Successed);
}
else
{
return(HandleResult.Failed);
}
}
catch (Exception ex)
{
throw ex;
}
}
