public int Site_Content_Insert(Site_Content obj)
{
DbCommand dbCmd = db.GetStoredProcCommand("Proc_Site_Content_Insert");
db.AddOutParameter(dbCmd, "@c_id", DbType.Int32, 4);
db.AddInParameter(dbCmd, "@c_gid", DbType.String, obj.c_gid);
db.AddInParameter(dbCmd, "@c_c_gid", DbType.String, obj.c_c_gid);
db.AddInParameter(dbCmd, "@c_title", DbType.String, obj.c_title);
db.AddInParameter(dbCmd, "@c_keywords", DbType.String, obj.c_keywords);
db.AddInParameter(dbCmd, "@c_sub_title", DbType.String, obj.c_sub_title);
db.AddInParameter(dbCmd, "@c_intro", DbType.String, obj.c_intro);
db.AddInParameter(dbCmd, "@c_content", DbType.String, obj.c_content);
db.AddInParameter(dbCmd, "@c_img_src", DbType.String, obj.c_img_src);
db.AddInParameter(dbCmd, "@c_createUserId", DbType.String, obj.c_createUserId);
db.AddInParameter(dbCmd, "@c_createUserName", DbType.String, obj.c_createUserName);
db.AddInParameter(dbCmd, "@c_createUserNickName", DbType.String, obj.c_createUserNickName);
db.AddInParameter(dbCmd, "@c_createTime", DbType.DateTime, obj.c_createTime);
db.AddInParameter(dbCmd, "@c_status", DbType.Int32, obj.c_status);
db.AddInParameter(dbCmd, "@c_state", DbType.Boolean, obj.c_state);
db.AddInParameter(dbCmd, "@c_updateTime", DbType.DateTime, obj.c_updateTime);
try
{
int returnValue = db.ExecuteNonQuery(dbCmd);
int c_id = (int)dbCmd.Parameters["@c_id"].Value;
return(returnValue);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public List <Site_Content> Site_Content_SelectPageByc_id(int cateId, int pageIndex, int pageSize, out int rowCount)
{
DbCommand dbCmd = db.GetStoredProcCommand("Proc_Site_Content_SelectPageByc_id");
db.AddInParameter(dbCmd, "@cateId", DbType.Int32, cateId);
db.AddInParameter(dbCmd, "@pageIndex", DbType.Int32, pageIndex);
db.AddInParameter(dbCmd, "@pageSize", DbType.Int32, pageSize);
db.AddOutParameter(dbCmd, "@rowCount", DbType.Int32, 4);
List <Site_Content> list = new List <Site_Content>();
try
{
using (IDataReader reader = db.ExecuteReader(dbCmd))
{
while (reader.Read())
{
//属性赋值
Site_Content obj = this.Obj2Model <Site_Content>(reader);
list.Add(obj);
}
reader.NextResult();
}
rowCount = (int)dbCmd.Parameters["@rowCount"].Value;
return(list);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public List <Site_Content> Site_Content_SelectPage(string cloumns, int pageIndex, int pageSize, string orderBy, string where, out int rowCount)
{
DbCommand dbCmd = db.GetStoredProcCommand("Proc_Site_Content_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_Content> list = new List <Site_Content>();
try
{
using (IDataReader reader = db.ExecuteReader(dbCmd))
{
while (reader.Read())
{
Site_Content obj = this.Obj2Model <Site_Content>(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_Content_UpdateByc_id(Site_Content obj)
{
using (SiteContentAccesss access = new SiteContentAccesss())
{
return(access.Site_Content_UpdateByc_id(obj));
}
}
public ActionResult SiteContentCheck()
{
string c_gid = Request["c_gid"] ?? string.Empty;
int status = Request["status"].ToInt32(1);
int successCount = 0;
int failCount = 0;
int result = 0;
Site_Content info = null;
string[] c_gidArr = c_gid.Split(new string[] { ",", "，" }, StringSplitOptions.RemoveEmptyEntries);
for (int i = 0; i < c_gidArr.Length; i++)
{
info = SiteServiceClass.Site_Content_SelectByc_gid(c_gidArr[i]);
info.c_status = status;
result = SiteServiceClass.Site_Content_UpdateByc_id(info);
if (result > 0)
{
successCount++;
}
else
{
failCount++;
}
}
if (c_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 int Site_Content_Insert(Site_Content obj)
{
using (SiteContentAccesss access = new SiteContentAccesss())
{
return(access.Site_Content_Insert(obj));
}
}
public static int Site_Content_UpdateByc_id(Site_Content obj)
{
ISiteService channel = Entity.CreateChannel <ISiteService>(SiteEnum.SiteService.SiteService);
var result = channel.Site_Content_UpdateByc_id(obj);
(channel as IDisposable).Dispose();
return(result);
}
// GET: Detail
public ActionResult Index(string gid)
{
Site_Content info = SiteServiceClass.Site_Content_SelectByc_gid(gid);
if (info != null)
{
if (info.c_status == (int)SiteEnum.SiteItemStatus.待审核 || info.c_status == (int)SiteEnum.SiteItemStatus.关闭)
{
return(RedirectToAction("NotFound", "Error"));
}
}
else
{
return(RedirectToAction("Index", "Error"));
}
ViewBag.info = info;
return(View());
}
public ActionResult ContentEditView()
{
string cate_gid = Request["cate_gid"] ?? string.Empty;
string c_gid = Request["c_gid"] ?? string.Empty;
Site_Content info = null;
if (string.IsNullOrEmpty(c_gid))
{
info = new Site_Content();
}
else
{
info = SiteServiceClass.Site_Content_SelectByc_gid(c_gid);
}
ViewData["window"] = Request["window"] ?? string.Empty;
ViewData["info"] = info;
ViewBag.c_gid = c_gid;
ViewBag.cate_gid = cate_gid;
return(View());
}
public Site_Content Site_Content_SelectByc_gid(string c_gid)
{
DbCommand dbCmd = db.GetStoredProcCommand("Proc_Site_Content_SelectByc_gid");
db.AddInParameter(dbCmd, "@c_gid", DbType.String, c_gid);
Site_Content obj = null;
try
{
using (IDataReader reader = db.ExecuteReader(dbCmd))
{
while (reader.Read())
{
//属性赋值
obj = this.Obj2Model <Site_Content>(reader);
}
}
return(obj);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public ActionResult SiteContentRecommendEdit()
{
//内容ID
string c_gid = Request["c_gid"] ?? string.Empty;
//推荐区块ID
string b_gid = Request["b_gid"] ?? string.Empty;
//区块页面ID
string p_gid = Request["p_gid"] ?? string.Empty;
Site_Content content = 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_gidArr = c_gid.Split(new string[] { ",", "，" }, StringSplitOptions.RemoveEmptyEntries);
for (int i = 0; i < c_gidArr.Length; i++)
{
content = SiteServiceClass.Site_Content_SelectByc_gid(c_gidArr[i]);
item = SiteServiceClass.Site_CMSItem_SelectByc_gidAndb_gid(c_gidArr[i], b_gid);
if (item != null)
{
existCount++;
continue;
}
item = new Site_CMSItem();
item.i_b_gid = b_gid;
item.i_intro = content.c_intro;
item.i_createTime = DateTime.Now;
item.i_createUser = SiteHelp.CurrentUserName;
item.i_c_gid = content.c_gid;
item.i_c_type = string.Empty;
item.i_gid = Guid.NewGuid().ToString().Substring(0, 8);
item.i_p_gid = p_gid;
item.i_status = (int)SiteEnum.SiteItemStatus.待审核;
item.i_subTitle = content.c_sub_title;
item.i_title = content.c_sub_title;
item.i_c_img_src = string.Empty;
//图片需要根据该区块设置的图片尺寸，缩放该图片,使用原图来进行缩放
if (!string.IsNullOrEmpty(b_info.b_img_size.Trim()))
{
if (!string.IsNullOrEmpty(content.c_img_src))
{
int index = content.c_img_src.LastIndexOf('_');
string sourceSrc = content.c_img_src.Substring(0, index) + ".jpg";
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"
);
item.i_c_img_src = srcResult[1];
}
}
}
result = SiteServiceClass.Site_CMSItem_Insert(item);
if (result > 0)
{
successCount++;
}
else
{
failCount++;
}
}
if (c_gidArr.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 SiteContentEdit()
{
string c_title = Request["c_title"] ?? string.Empty;
string c_keywords = Request["c_keywords"] ?? string.Empty;
string c_subTitle = Request["c_subTitle"] ?? string.Empty;
string c_content = Request["c_content"] ?? string.Empty;
string c_intro = Request["c_intro"] ?? string.Empty;
string c_gid = Request["c_gid"] ?? string.Empty;
string c_c_gid = Request["cate_gid"] ?? string.Empty;
Site_Content info = null;
if (string.IsNullOrEmpty(c_gid))
{
info = new Site_Content();
//新增
info.c_gid = Entity.GenerateGUID();
info.c_createUserName = SiteHelp.CurrentUserName;
info.c_createUserNickName = SiteHelp.CurrentUserNickName;
info.c_createUserId = string.Empty;
info.c_createTime = DateTime.Now;
}
else
{
info = SiteServiceClass.Site_Content_SelectByc_gid(c_gid);
}
info.c_status = (int)SiteEnum.SiteItemStatus.待审核;
info.c_updateTime = DateTime.Now;
info.c_sub_title = c_subTitle;
info.c_title = c_title;
info.c_keywords = c_keywords;
info.c_c_gid = c_c_gid;
info.c_content = c_content;
info.c_intro = c_intro;
info.c_img_src = string.Empty;
//默认第一张图片为封面
MatchCollection list = Regex.Matches(c_content, @"<img src=""(?<img>[\S]*)""[^/]*/>");
if (list.Count > 0)
{
string img_src = list[0].Groups["img"].Value;
info.c_img_src = img_src;
}
if (string.IsNullOrEmpty(c_gid))
{
int result = SiteServiceClass.Site_Content_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_Content_UpdateByc_id(info);
if (result > 0)
{
return(Json(new { success = true, errors = new { text = "修改成功" } }));
}
else
{
return(Json(new { success = false, errors = new { text = "修改失败" } }));
}
}
}