AdvertManage.Model.AMS_HardAdModel DataRowToAMS_HardAdModel(DataRow dr)
{
AdvertManage.Model.AMS_HardAdModel model = new AMS_HardAdModel();
if (dr["ID"] != null && dr["ID"].ToString() != "")
{
model.ID = int.Parse(dr["ID"].ToString());
}
if (dr["Number"] != null && dr["Number"].ToString() != "")
{
model.Number = dr["Number"].ToString();
}
if (dr["EffectDate"] != null && dr["EffectDate"].ToString() != "")
{
model.EffectDate = DateTime.Parse(dr["EffectDate"].ToString());
}
if (dr["EndDate"] != null && dr["EndDate"].ToString() != "")
{
model.EndDate = DateTime.Parse(dr["EndDate"].ToString());
}
if (dr["AdImage"] != null && dr["AdImage"].ToString() != "")
{
model.AdImage = (byte[])dr["AdImage"];
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(AMS_HardAdModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into AMS_HardAd(");
strSql.Append("Number,EffectDate,EndDate,AdImage)");
strSql.Append(" values (");
strSql.Append("@Number,@EffectDate,@EndDate,@AdImage)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Number", SqlDbType.NVarChar, 50),
new SqlParameter("@EffectDate", SqlDbType.DateTime),
new SqlParameter("@EndDate", SqlDbType.DateTime),
new SqlParameter("@AdImage", SqlDbType.Image)
};
parameters[0].Value = model.Number;
parameters[1].Value = model.EffectDate;
parameters[2].Value = model.EndDate;
parameters[3].Value = model.AdImage;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(AMS_HardAdModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update AMS_HardAd set ");
strSql.Append("Number=@Number,");
strSql.Append("EffectDate=@EffectDate,");
strSql.Append("EndDate=@EndDate,");
strSql.Append("AdImage=@AdImage");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@Number", SqlDbType.NVarChar, 50),
new SqlParameter("@EffectDate", SqlDbType.DateTime),
new SqlParameter("@EndDate", SqlDbType.DateTime),
new SqlParameter("@AdImage", SqlDbType.Image),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.Number;
parameters[1].Value = model.EffectDate;
parameters[2].Value = model.EndDate;
parameters[3].Value = model.AdImage;
parameters[4].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 硬广图片二进制流
/// </summary>
/// <summary>
/// 新增一条硬广
/// </summary>
public bool AddNewHardAd()
{
try
{
if (_AdImage.UriSource != null && !string.IsNullOrEmpty(_Number) && (_EndDate > _EffectDate))
{
AMS_HardAdModel model = new AMS_HardAdModel();
model.Number = _Number;
model.EffectDate = _EffectDate;
model.EndDate = _EndDate;
FileStream fs = new FileStream(_AdImage.UriSource.OriginalString, FileMode.Open, FileAccess.Read);
byte[] btye = new byte[fs.Length];
fs.Read(btye, 0, Convert.ToInt32(fs.Length));
fs.Close();
model.AdImage = btye;
if (AMS_HardAdBLL.AddHardAd(model) == AdvertManage.Model.Enum.HandleResult.Failed)
{
throw new Exception("添加硬广失败，详情请查看错误日志！");
}
return(true);
}
else
{
throw new Exception("信息填写有误，请重新确认！");
}
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
return(false);
}
}
public Model.Enum.HandleResult UpdateHardAd(AMS_HardAdModel model)
{
try
{
if (hardAdDal.Update(model))
{
return(AdvertManage.Model.Enum.HandleResult.Successed);
}
else
{
return(HandleResult.Failed);
}
}
catch (Exception ex)
{
throw ex;
}
}
