/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(SlideShowModel model)
{
bool reValue = true;
int reCount = 0;
StringBuilder strSql = new StringBuilder();
strSql.Append("update SlideShow set ");
strSql.Append(" Url = @Url , ");
strSql.Append(" Event = @Event , ");
strSql.Append(" SlideshowTitle = @SlideshowTitle , ");
strSql.Append(" SlideshowMemo = @SlideshowMemo , ");
strSql.Append(" CreateTime = @CreateTime , ");
strSql.Append(" CreateUser = @CreateUser , ");
strSql.Append(" OrderNo = @OrderNo , ");
strSql.Append(" lv = @lv , ");
strSql.Append(" SlideshowType = @SlideshowType , ");
strSql.Append(" SlideshowImgId = @SlideshowImgId ");
strSql.Append(" where SlideshowId=@SlideshowId ");
SqlParameter[] parameters =
{
new SqlParameter("@SlideshowId", SqlDbType.Decimal, 9),
new SqlParameter("@Url", SqlDbType.VarChar, 250),
new SqlParameter("@Event", SqlDbType.VarChar, 50),
new SqlParameter("@SlideshowTitle", SqlDbType.VarChar, 100),
new SqlParameter("@SlideshowMemo", SqlDbType.VarChar, 500),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUser", SqlDbType.VarChar, 50),
new SqlParameter("@OrderNo", SqlDbType.Int, 4),
new SqlParameter("@lv", SqlDbType.Int, 4),
new SqlParameter("@SlideshowType", SqlDbType.VarChar, 10),
new SqlParameter("@SlideshowImgId", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.SlideshowId;
parameters[1].Value = model.Url;
parameters[2].Value = model.Event;
parameters[3].Value = model.SlideshowTitle;
parameters[4].Value = model.SlideshowMemo;
parameters[5].Value = model.CreateTime;
parameters[6].Value = model.CreateUser;
parameters[7].Value = model.OrderNo;
parameters[8].Value = model.lv;
parameters[9].Value = model.SlideshowType;
parameters[10].Value = model.SlideshowImgId; try
{//异常处理
reCount = this.helper.ExecSqlReInt(strSql.ToString(), parameters);
}
catch (Exception ex)
{
this.helper.Close();
throw ex;
}
if (reCount <= 0)
{
reValue = false;
}
return(reValue);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(SlideShowModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SlideShow(");
strSql.Append("Url,Event,SlideshowTitle,SlideshowMemo,CreateTime,CreateUser,OrderNo,lv,SlideshowType,SlideshowImgId");
strSql.Append(") values (");
strSql.Append("@Url,@Event,@SlideshowTitle,@SlideshowMemo,@CreateTime,@CreateUser,@OrderNo,@lv,@SlideshowType,@SlideshowImgId");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Url", SqlDbType.VarChar, 250),
new SqlParameter("@Event", SqlDbType.VarChar, 50),
new SqlParameter("@SlideshowTitle", SqlDbType.VarChar, 100),
new SqlParameter("@SlideshowMemo", SqlDbType.VarChar, 500),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUser", SqlDbType.VarChar, 50),
new SqlParameter("@OrderNo", SqlDbType.Int, 4),
new SqlParameter("@lv", SqlDbType.Int, 4),
new SqlParameter("@SlideshowType", SqlDbType.VarChar, 10),
new SqlParameter("@SlideshowImgId", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.Url;
parameters[1].Value = model.Event;
parameters[2].Value = model.SlideshowTitle;
parameters[3].Value = model.SlideshowMemo;
parameters[4].Value = model.CreateTime;
parameters[5].Value = model.CreateUser;
parameters[6].Value = model.OrderNo;
parameters[7].Value = model.lv;
parameters[8].Value = model.SlideshowType;
parameters[9].Value = model.SlideshowImgId;
bool result = false;
try
{
model.SlideshowId = decimal.Parse(helper.ExecuteNonQueryBackId(strSql.ToString(), "SlideshowId", parameters));
result = true;
}
catch (Exception ex)
{
this.helper.Close();
throw ex;
}
finally
{
}
return(result);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SlideShowModel GetModel(decimal SlideshowId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select SlideshowId, Url, Event, SlideshowTitle, SlideshowMemo, CreateTime, CreateUser, OrderNo, lv, SlideshowType, SlideshowImgId ");
strSql.Append(" from SlideShow ");
strSql.Append(" where SlideshowId=@SlideshowId");
SqlParameter[] parameters =
{
new SqlParameter("@SlideshowId", SqlDbType.Decimal)
};
parameters[0].Value = SlideshowId;
SlideShowModel model = new SlideShowModel();
DataSet ds = helper.ExecSqlReDs(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["SlideshowId"].ToString() != "")
{
model.SlideshowId = decimal.Parse(ds.Tables[0].Rows[0]["SlideshowId"].ToString());
}
model.Url = ds.Tables[0].Rows[0]["Url"].ToString();
model.Event = ds.Tables[0].Rows[0]["Event"].ToString();
model.SlideshowTitle = ds.Tables[0].Rows[0]["SlideshowTitle"].ToString();
model.SlideshowMemo = ds.Tables[0].Rows[0]["SlideshowMemo"].ToString();
if (ds.Tables[0].Rows[0]["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(ds.Tables[0].Rows[0]["CreateTime"].ToString());
}
model.CreateUser = ds.Tables[0].Rows[0]["CreateUser"].ToString();
if (ds.Tables[0].Rows[0]["OrderNo"].ToString() != "")
{
model.OrderNo = int.Parse(ds.Tables[0].Rows[0]["OrderNo"].ToString());
}
if (ds.Tables[0].Rows[0]["lv"].ToString() != "")
{
model.lv = int.Parse(ds.Tables[0].Rows[0]["lv"].ToString());
}
model.SlideshowType = ds.Tables[0].Rows[0]["SlideshowType"].ToString();
model.SlideshowImgId = ds.Tables[0].Rows[0]["SlideshowImgId"].ToString();
return(model);
}
else
{
return(null);
}
}
public List <SlideShowModel> PrepareSlideShowModel(IQueryable <SlideShow> slides)
{
var data = new List <SlideShowModel>();
foreach (var item in slides)
{
SlideShowModel slide = new SlideShowModel();
slide.Description = item.Description;
slide.ButtonName = item.ButtonName;
slide.ButtonLink = item.ButtonLink;
slide.Title = item.Title;
var ids = new int[1] {
item.PhotoId
};
slide.SlidePhoto = _photoService.GetPhotosByIds(ids).Any() ? _photoService.GetPhotosByIds(ids).FirstOrDefault().FileUrl : "/";
data.Add(slide);
}
return(data);
}
