public DataSet GetSuCaiPageList(string strWhere, int c, int pagesize, string cols)
{
DAL.WxSuCaiInfoDAL dal = new DAL.WxSuCaiInfoDAL();
DataSet ds = dal.GetPageList(strWhere, c, pagesize, cols);
DataTable dt = ds.Tables[2];
if (dt.Rows.Count == 0)
{
return(ds);
}
dt.Columns.Add("DetailJson");
List <string> li = new List <string>();
foreach (DataRow dr in dt.Rows)
{
li.Add(dr["WxSuCaiInfoId"].ToString());
}
string WxSuCaiInfoIdStr = string.Join(",", li);
DAL.WxSuCaiDetailDAL detailDal = new DAL.WxSuCaiDetailDAL();
DataSet dsDetail = detailDal.GetList(" WxSuCaiInfoId in (" + WxSuCaiInfoIdStr + ") ");
DataTable dtDetail = dsDetail.Tables[0];
foreach (DataRow dr in dt.Rows)
{
DataTable dj = Common.DataSetting.TableSelect(" WxSuCaiInfoId='" + dr["WxSuCaiInfoId"] + "' ", dtDetail);
dr["DetailJson"] = Common.JsonHelper.ToJson(dj);
}
return(ds);
}
/// <summary>
/// 保存一个素材明细
/// </summary>
/// <param name="model"></param>
public void SaveSuCaiDetail(Model.WxSuCaiDetailModel model)
{
DAL.WxSuCaiDetailDAL dal = new DAL.WxSuCaiDetailDAL();
if (model.WxSuCaiDetailId == 0)
{
dal.Add(model);
}
else
{
dal.Update(model);
}
}
public void RemoveSuCaiDetail(string strWhere)
{
DAL.WxSuCaiDetailDAL dal = new DAL.WxSuCaiDetailDAL();
dal.DeleteList(strWhere);
}
