/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(TitleAdvertInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into AMS_TitleAd(");
strSql.Append("EffectDate,EndDate,AdContent,Num)");
strSql.Append(" values (");
strSql.Append("@EffectDate,@EndDate,@AdContent,@Num)");
SqlParameter[] parameters =
{
new SqlParameter("@EffectDate", SqlDbType.DateTime),
new SqlParameter("@EndDate", SqlDbType.DateTime),
new SqlParameter("@AdContent", SqlDbType.Text),
new SqlParameter("@Num", model.TitleAdvertNo)
};
parameters[0].Value = model.EffectDate;
parameters[1].Value = model.EndDate;
parameters[2].Value = model.TitleAdvert;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public static SeatManage.EnumType.HandleResult UpdateTitleAdvert(TitleAdvertInfo model)
{
IWCFService.ISeatManageService seatService = WcfAccessProxy.ServiceProxy.CreateChannelSeatManageService();
bool error = false;
try
{
return(seatService.UpdateTitleAdvert(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();
}
}
}
/// <summary>
/// 冠名广告信息行转换成列
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private TitleAdvertInfo dataRowToTitleAdvertInfo(DataRow dr)
{
TitleAdvertInfo info = new TitleAdvertInfo();
info.EffectDate = DateTime.Parse(dr["EffectDate"].ToString());
info.EndDate = DateTime.Parse(dr["EndDate"].ToString());
info.TitleAdvert = dr["AdContent"].ToString();
info.TitleAdvertNo = dr["Num"].ToString();
info.ID = int.Parse(dr["AdNo"].ToString());
return(info);
}
public static SeatManage.EnumType.HandleResult UpdateTitleAdvert(TitleAdvertInfo model)
{
IWCFService.ISeatManageService seatService = new WcfServiceForSeatManage.SeatManageDateService();
bool error = false;
try
{
return(seatService.UpdateTitleAdvert(model));
}
catch (Exception ex)
{
error = true;
SeatManageComm.WriteLog.Write("添加冠名广告失败：" + ex.Message);
return(EnumType.HandleResult.Failed);
}
}
public SeatManage.EnumType.HandleResult UpdateTitleAdvert(TitleAdvertInfo model)
{
try
{
if (ams_TitleAd.Update(model))
{
return(SeatManage.EnumType.HandleResult.Successed);
}
else
{
return(SeatManage.EnumType.HandleResult.Failed);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取冠名信息
/// </summary>
/// <returns></returns>
public TitleAdvertInfo GetTitleAdvertInfo()
{
StringBuilder strWhere = new StringBuilder();
strWhere.Append(string.Format(" datediff(day,EffectDate,@NowDate)>=0 and datediff(day,EndDate,@NowDate)<=0 order by EffectDate desc"));
SqlParameter[] parameters =
{
new SqlParameter("@NowDate", SqlDbType.DateTime)
};
parameters[0].Value = GetServerDateTime();
DataSet ds = ams_TitleAd.GetList(strWhere.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
TitleAdvertInfo info = dataRowToTitleAdvertInfo(ds.Tables[0].Rows[0]);
return(info);
}
else
{
return
(null);
}
}
public TitleAdvertInfo GetTitleModel(string Num)
{
StringBuilder strWhere = new StringBuilder();
strWhere.Append(string.Format("Num=@Num"));
SqlParameter[] parameters =
{
new SqlParameter("@Num", SqlDbType.NVarChar)
};
parameters[0].Value = Num;
DataSet ds = ams_TitleAd.GetList(strWhere.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
TitleAdvertInfo info = dataRowToTitleAdvertInfo(ds.Tables[0].Rows[0]);
return(info);
}
else
{
return
(null);
}
}
/// <summary>
/// 把行转换为对应的实体。
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private TerminalInfo DataRowToTerminalInfo(DataRow dr)
{
TerminalInfo terminal = new TerminalInfo();
terminal.ClientNo = dr["DeviceNum"].ToString();
terminal.TerminalMacAddress = dr["TerminalMacAddress"].ToString();
terminal.ScreenshotPath = dr["ScreenshotPath"].ToString();
string tempFile = dr["Date"].ToString();
if (!string.IsNullOrEmpty(tempFile))
{
terminal.StatusUpdateTime = DateTime.Parse(tempFile);
}
terminal.IsUpdatePlayList = (bool)dr["IsUpdatePlayList"];
terminal.Describe = dr["Describe"].ToString();
tempFile = dr["DeviceSetting"].ToString();
if (!string.IsNullOrEmpty(tempFile))
{
terminal.DeviceSetting = ClientConfig.Convert(tempFile);
}
tempFile = dr["EmpowerLoseEfficacyTime"].ToString();
if (!string.IsNullOrEmpty(tempFile))
{
terminal.EmpowerLoseEfficacyTime = DateTime.Parse(tempFile);
}
if (dr["LastPrintTimes"] == DBNull.Value)
{
terminal.LastPrintTimes = 0;
}
else
{
terminal.LastPrintTimes = int.Parse(dr["LastPrintTimes"].ToString());
}
if (dr["PrintedTimes"] == DBNull.Value)
{
terminal.PrintedTimes = 0;
}
else
{
terminal.PrintedTimes = int.Parse(dr["PrintedTimes"].ToString());
}
if (dr["PrinterStatus"] == DBNull.Value)
{
terminal.PrinterStatus = false;
}
else
{
terminal.PrinterStatus = Convert.ToBoolean(dr["PrinterStatus"].ToString());
}
//HardAdvertInfo hardAdvert = GetHardAdvert();//获取有效的硬广
//if (hardAdvert != null)
//{
// terminal.HardAdImage = hardAdvert.AdvertImage;
//}
TitleAdvertInfo titleAdvert = GetTitleAdvertInfo();//获取冠名广告
if (titleAdvert != null)
{
terminal.TitleAd = titleAdvert.TitleAdvert;
}
return(terminal);
}
