public Site_CMSItem Site_CMSItem_SelectByc_gidAndb_gid(string c_gid, string b_gid)
{
DbCommand dbCmd = db.GetStoredProcCommand("Proc_Site_CMSItem_SelectByc_gidAndb_gid");
db.AddInParameter(dbCmd, "@c_gid", DbType.String, c_gid);
db.AddInParameter(dbCmd, "@b_gid", DbType.String, b_gid);
Site_CMSItem obj = null;
try
{
using (IDataReader reader = db.ExecuteReader(dbCmd))
{
while (reader.Read())
{
//属性赋值
obj = this.Obj2Model <Site_CMSItem>(reader);
}
}
return(obj);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public int Site_CMSItem_UpdateByi_gid(Site_CMSItem obj)
{
DbCommand dbCmd = db.GetStoredProcCommand("Proc_Site_CMSItem_UpdateByi_gid");
db.AddInParameter(dbCmd, "@i_id", DbType.Int32, obj.i_id);
db.AddInParameter(dbCmd, "@i_gid", DbType.String, obj.i_gid);
db.AddInParameter(dbCmd, "@i_p_gid", DbType.String, obj.i_p_gid);
db.AddInParameter(dbCmd, "@i_b_gid", DbType.String, obj.i_b_gid);
db.AddInParameter(dbCmd, "@i_title", DbType.String, obj.i_title);
db.AddInParameter(dbCmd, "@i_c_gid", DbType.String, obj.i_c_gid);
db.AddInParameter(dbCmd, "@i_c_type", DbType.String, obj.i_c_type);
db.AddInParameter(dbCmd, "@i_subTitle", DbType.String, obj.i_subTitle);
db.AddInParameter(dbCmd, "@i_intro", DbType.String, obj.i_intro);
db.AddInParameter(dbCmd, "@i_c_img_src", DbType.String, obj.i_c_img_src);
db.AddInParameter(dbCmd, "@i_status", DbType.Int32, obj.i_status);
db.AddInParameter(dbCmd, "@i_createUser", DbType.String, obj.i_createUser);
db.AddInParameter(dbCmd, "@i_createTime", DbType.String, obj.i_createTime);
try
{
int returnValue = db.ExecuteNonQuery(dbCmd);
return(returnValue);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public List <Site_CMSItem> Site_CMSItem_SelectPage(string cloumns, string orderBy, string where, int pageIndex, int pageSize, out int rowCount)
{
DbCommand dbCmd = db.GetStoredProcCommand("Proc_Site_CMSItem_SelectPage");
db.AddOutParameter(dbCmd, "@rowCount", DbType.Int32, 4);
db.AddInParameter(dbCmd, "@cloumns", DbType.String, cloumns);
db.AddInParameter(dbCmd, "@pageIndex", DbType.Int32, pageIndex);
db.AddInParameter(dbCmd, "@pageSize", DbType.Int32, pageSize);
db.AddInParameter(dbCmd, "@orderBy", DbType.String, orderBy);
db.AddInParameter(dbCmd, "@where", DbType.String, where);
List <Site_CMSItem> list = new List <Site_CMSItem>();
try
{
using (IDataReader reader = db.ExecuteReader(dbCmd))
{
while (reader.Read())
{
//属性赋值
Site_CMSItem obj = this.Obj2Model <Site_CMSItem>(reader);
list.Add(obj);
}
reader.NextResult();
}
rowCount = (int)dbCmd.Parameters["@rowCount"].Value;
return(list);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public int Site_CMSItem_UpdateByi_gid(Site_CMSItem obj)
{
using (SiteCatesAccess access = new SiteCatesAccess())
{
return(access.Site_CMSItem_UpdateByi_gid(obj));
}
}
public int Site_CMSItem_Insert(Site_CMSItem obj)
{
using (SiteCatesAccess access = new SiteCatesAccess())
{
return(access.Site_CMSItem_Insert(obj));
}
}
public ActionResult SiteCMSItemCheck()
{
string i_gid = Request["i_gid"] ?? string.Empty;
int status = Request["status"].ToInt32(1);
int successCount = 0;
int failCount = 0;
int result = 0;
Site_CMSItem info = null;
string[] i_gidArr = i_gid.Split(new string[] { ",", "，" }, StringSplitOptions.RemoveEmptyEntries);
for (int i = 0; i < i_gidArr.Length; i++)
{
info = SiteServiceClass.Site_CMSItem_SelectByi_gid(i_gidArr[i]);
info.i_status = status;
result = SiteServiceClass.Site_CMSItem_UpdateByi_gid(info);
if (result > 0)
{
successCount++;
}
else
{
failCount++;
}
}
if (i_gidArr.Length == 1)
{
return(Json(new { success = true, errors = new { text = "审核成功" } }));
}
else
{
return(Json(new { success = true, errors = new { text = string.Format("审核成功{0}条，失败{1}条", successCount, failCount) } }));
}
}
public static int Site_CMSItem_UpdateByi_gid(Site_CMSItem obj)
{
ISiteService channel = Entity.CreateChannel <ISiteService>(SiteEnum.SiteService.SiteService);
var result = channel.Site_CMSItem_UpdateByi_gid(obj);
(channel as IDisposable).Dispose();
return(result);
}
public ActionResult SiteCMSItemEditView()
{
string i_gid = Request["i_gid"] ?? string.Empty;
string b_gid = Request["b_gid"] ?? string.Empty;
string p_gid = Request["p_gid"] ?? string.Empty;
Site_CMSItem info = null;
if (string.IsNullOrEmpty(i_gid))
{
info = new Site_CMSItem();
}
else
{
info = SiteServiceClass.Site_CMSItem_SelectByi_gid(i_gid);
}
ViewData["window"] = Request["window"] ?? string.Empty;
ViewData["info"] = info;
ViewBag.b_gid = b_gid;
ViewBag.p_gid = p_gid;
return(View());
}
public ActionResult SiteContentRecommendEdit()
{
//内容ID
string c_id = Request["c_id"] ?? string.Empty;
//推荐区块ID
string b_gid = Request["b_gid"] ?? string.Empty;
//区块页面ID
string p_gid = Request["p_gid"] ?? string.Empty;
VideoInfo fInfo = null;
Site_CMSItem item = null;
int existCount = 0;
int successCount = 0;
int failCount = 0;
int result = 0;
Site_CMSBlock b_info = SiteServiceClass.Site_CMSBlock_SelectByb_gid(b_gid);
string[] c_idArr = c_id.Split(new string[] { ",", "，" }, StringSplitOptions.RemoveEmptyEntries);
for (int i = 0; i < c_idArr.Length; i++)
{
fInfo = VideoServiceClass.VideoInfo_SelectById(c_idArr[i].ToInt32());
item = SiteServiceClass.Site_CMSItem_SelectByc_gidAndb_gid(c_idArr[i], b_gid);
if (item != null)
{
existCount++;
continue;
}
item = new Site_CMSItem();
item.i_b_gid = b_gid;
item.i_intro = fInfo.v_intro;//
item.i_createTime = DateTime.Now;
item.i_createUser = SiteHelp.CurrentUserName;
item.i_c_gid = fInfo.Id.ToString();//唯一Id
item.i_c_type = fInfo.v_c_id.ToString();//分类ID
item.i_gid = Guid.NewGuid().ToString().Substring(0, 8);
item.i_p_gid = p_gid;
item.i_status = (int)SiteEnum.SiteItemStatus.待审核;
item.i_subTitle = fInfo.v_timeLength;//时长
item.i_title = fInfo.v_titile;
item.i_c_img_src = string.Empty;
//图片需要根据该区块设置的图片尺寸，缩放该图片,使用原图来进行缩放
if (!string.IsNullOrEmpty(b_info.b_img_size.Trim()))
{
if (!string.IsNullOrEmpty(fInfo.v_coverImgSrc))
{
string sourceSrc = fInfo.v_coverImgSrc;
string error;
byte[] imgData = SiteUntility.GetRemoteImage(sourceSrc, out error);
if (imgData != null)
{
List<string> srcResult = UploadServiceClass.UploadImg(
imgData,
SiteEnum.SiteUploadConfigName.baseUpload.ToString(),
new List<string>() { b_info.b_img_size },
".jpg", "s", SiteEnum.SiteService.VideoUploadService
);
item.i_c_img_src = srcResult[1];
}
}
}
result = SiteServiceClass.Site_CMSItem_Insert(item);
if (result > 0)
{
successCount++;
}
else
{
failCount++;
}
}
if (c_idArr.Length == 1)
{
return Json(new { success = true, errors = new { text = "推荐成功" } });
}
else
{
return Json(new { success = true, errors = new { text = string.Format("推荐成功{0}条，失败{1}条，重复{2}条", successCount, failCount, existCount) } });
}
}
public ActionResult SiteCMSItemEdit()
{
string i_title = Request["i_title"] ?? string.Empty;
string i_subTitle = Request["i_subTitle"] ?? string.Empty;
string i_content = Request["i_content"] ?? string.Empty;
string i_sort = Request["i_sort"] ?? string.Empty;
string i_gid = Request["i_gid"] ?? string.Empty;
string b_gid = Request["b_gid"] ?? string.Empty;
string p_gid = Request["p_gid"] ?? string.Empty;
Site_CMSItem info = null;
if (string.IsNullOrEmpty(i_gid))
{
info = new Site_CMSItem();
//新增
info.i_gid = Entity.GenerateGUID();
info.i_createTime = DateTime.Now;
info.i_createUser = SiteHelp.CurrentUserName;
info.i_b_gid = b_gid;
info.i_p_gid = p_gid;
info.i_c_gid = string.Empty;
info.i_c_type = string.Empty;
info.i_status = (int)SiteEnum.SiteItemStatus.待审核;
info.i_c_img_src = string.Empty;
}
else
{
info = SiteServiceClass.Site_CMSItem_SelectByi_gid(i_gid);
}
info.i_title = i_title;
info.i_subTitle = i_subTitle;
info.i_intro = i_content;
int sort = 0;
int.TryParse(i_sort, out sort);
info.i_sort = sort;
if (string.IsNullOrEmpty(i_gid))
{
int result = SiteServiceClass.Site_CMSItem_Insert(info);
if (result > 0)
{
return(Json(new { success = true, errors = new { text = "新增成功" } }));
}
else
{
return(Json(new { success = false, errors = new { text = "新增失败" } }));
}
}
else
{
int result = SiteServiceClass.Site_CMSItem_UpdateByi_gid(info);
if (result > 0)
{
return(Json(new { success = true, errors = new { text = "修改成功" } }));
}
else
{
return(Json(new { success = false, errors = new { text = "修改失败" } }));
}
}
}
