/// <summary>
/// 获取实体
/// </summary>
public Model.redpacket GetRedPacketModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select TOP 1 [id],[channel_id],[title],[content],[market_price],[sell_price],[total_count],[start_date],[end_date],[add_time],[status],[is_top],[is_slide],[is_red],[sort_id],[remark1],[remark2],[img_url] ");
strSql.Append(" ,(case when c.book_count is null then '0' else c.book_count end) as book_count ");
strSql.Append(" FROM dt_redpacket a ");
strSql.Append(" left join (select COUNT(*) as book_count ,redpacket_id from dbo.dt_redpacket_guid t group by t.redpacket_id) c ");
strSql.Append(" on a.id=c.redpacket_id ");
strSql.Append(" where id=@id ");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int,4)};
parameters[0].Value = id;
Model.redpacket model = new Model.redpacket();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
#region DATA
if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
if (ds.Tables[0].Rows[0]["channel_id"] != null && ds.Tables[0].Rows[0]["channel_id"].ToString() != "")
{
model.channel_id = int.Parse(ds.Tables[0].Rows[0]["channel_id"].ToString());
}
if (ds.Tables[0].Rows[0]["title"] != null && ds.Tables[0].Rows[0]["title"].ToString() != "")
{
model.title = ds.Tables[0].Rows[0]["title"].ToString();
}
if (ds.Tables[0].Rows[0]["content"] != null && ds.Tables[0].Rows[0]["content"].ToString() != "")
{
model.content = ds.Tables[0].Rows[0]["content"].ToString();
}
if (ds.Tables[0].Rows[0]["market_price"] != null && ds.Tables[0].Rows[0]["market_price"].ToString() != "")
{
model.market_price = decimal.Parse(ds.Tables[0].Rows[0]["market_price"].ToString());
}
if (ds.Tables[0].Rows[0]["sell_price"] != null && ds.Tables[0].Rows[0]["sell_price"].ToString() != "")
{
model.sell_price = decimal.Parse(ds.Tables[0].Rows[0]["sell_price"].ToString());
}
if (ds.Tables[0].Rows[0]["total_count"] != null && ds.Tables[0].Rows[0]["total_count"].ToString() != "")
{
model.total_count = int.Parse(ds.Tables[0].Rows[0]["total_count"].ToString());
}
if (ds.Tables[0].Rows[0]["book_count"] != null && ds.Tables[0].Rows[0]["book_count"].ToString() != "")
{
model.book_count = int.Parse(ds.Tables[0].Rows[0]["book_count"].ToString());
}
if (ds.Tables[0].Rows[0]["start_date"] != null && ds.Tables[0].Rows[0]["start_date"].ToString() != "")
{
model.start_date = ds.Tables[0].Rows[0]["start_date"].ToString();
}
if (ds.Tables[0].Rows[0]["end_date"] != null && ds.Tables[0].Rows[0]["end_date"].ToString() != "")
{
model.end_date = ds.Tables[0].Rows[0]["end_date"].ToString();
}
if (ds.Tables[0].Rows[0]["add_time"] != null && ds.Tables[0].Rows[0]["add_time"].ToString() != "")
{
model.add_time = DateTime.Parse(ds.Tables[0].Rows[0]["add_time"].ToString());
}
if (ds.Tables[0].Rows[0]["status"] != null && ds.Tables[0].Rows[0]["status"].ToString() != "")
{
model.status = int.Parse(ds.Tables[0].Rows[0]["status"].ToString());
}
if (ds.Tables[0].Rows[0]["is_top"] != null && ds.Tables[0].Rows[0]["is_top"].ToString() != "")
{
model.is_top = int.Parse(ds.Tables[0].Rows[0]["is_top"].ToString());
}
if (ds.Tables[0].Rows[0]["is_slide"] != null && ds.Tables[0].Rows[0]["is_slide"].ToString() != "")
{
model.is_slide = int.Parse(ds.Tables[0].Rows[0]["is_slide"].ToString());
}
if (ds.Tables[0].Rows[0]["is_red"] != null && ds.Tables[0].Rows[0]["is_red"].ToString() != "")
{
model.is_red = int.Parse(ds.Tables[0].Rows[0]["is_red"].ToString());
}
if (ds.Tables[0].Rows[0]["sort_id"] != null && ds.Tables[0].Rows[0]["sort_id"].ToString() != "")
{
model.sort_id = int.Parse(ds.Tables[0].Rows[0]["sort_id"].ToString());
}
if (ds.Tables[0].Rows[0]["remark1"] != null && ds.Tables[0].Rows[0]["remark1"].ToString() != "")
{
model.remark1 = ds.Tables[0].Rows[0]["remark1"].ToString();
}
if (ds.Tables[0].Rows[0]["remark2"] != null && ds.Tables[0].Rows[0]["remark2"].ToString() != "")
{
model.remark2 = int.Parse(ds.Tables[0].Rows[0]["remark2"].ToString());
}
if (ds.Tables[0].Rows[0]["img_url"] != null && ds.Tables[0].Rows[0]["img_url"].ToString() != "")
{
model.img_url = ds.Tables[0].Rows[0]["img_url"].ToString();
}
#endregion
model.albums = new article_albums().GetList(id);
return model;
}
else
{
return null;
}
}
private bool DoAdd()
{
bool result = true;
Model.redpacket model = new Model.redpacket();
BLL.redpacket bll = new BLL.redpacket();
model.channel_id = this.channel_id;
model.title = txtTitle.Text.Trim();
model.content = Utils.ToHtml(txtContent.Text);
model.market_price = decimal.Parse(txtMarketPrice.Text);
model.sell_price = decimal.Parse(txtSellPrice.Text);
model.total_count = int.Parse(txtTotal.Text.Trim());
model.book_count = 0;
model.img_url =txtImgUrl.Text.Trim();
model.start_date = txtStartDate.Text.Trim();
model.end_date = txtEndDate.Text.Trim();
model.status = string.IsNullOrEmpty(rdoStatus.SelectedValue) ? 0 : int.Parse(rdoStatus.SelectedValue);
model.sort_id = int.Parse(txtSortId.Text.Trim());
model.add_time = DateTime.Now;
model.is_slide = 0;
model.is_top = 0;
model.is_red = 0;
model.remark1 = "";
model.remark2 = 0;
if (cblItem.Items[0].Selected == true)
{
model.is_top = 1;
}
if (cblItem.Items[1].Selected == true)
{
model.is_red = 1;
}
model.albums = null;
if (bll.Add(model) < 1)
{
result = false;
}
return result;
}