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 SaveSuCaiInfo(Model.WxSuCaiInfoModel model)
{
DAL.WxSuCaiInfoDAL dal = new DAL.WxSuCaiInfoDAL();
if (model.WxSuCaiInfoId == 0)
{
//新增
model.CreateTime = DateTime.Now;
dal.Add(model);
}
else
{
//修改
dal.Update(model);
}
}
public Model.WxSuCaiInfoModel GetSuCaiInfoModel(decimal WxSuCaiInfoId)
{
DAL.WxSuCaiInfoDAL dal = new DAL.WxSuCaiInfoDAL();
return(dal.GetModel(WxSuCaiInfoId));
}
