/// <summary>
/// 更新
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int Update(CompanyNewsInfo model)
{
string strSQL = "UPDATE CompanyNews SET Title = @Title ,Content = @Content,PublishDateTime =@PublishDateTime,ModifyDateTime = GETDATE(),Remark = @Remark,ImageUrl = @ImageUrl,Tags = @Tags WHERE Id = @Id AND CompanyId = @CompanyId";
SqlParameter[] parms = {
new SqlParameter("Id",SqlDbType.Int),
new SqlParameter("CompanyId",SqlDbType.Int),
new SqlParameter("Title",SqlDbType.NVarChar),
new SqlParameter("Content",SqlDbType.NVarChar),
new SqlParameter("PublishDateTime",SqlDbType.DateTime),
new SqlParameter("Remark",SqlDbType.NVarChar),
new SqlParameter("ImageUrl",SqlDbType.NVarChar),
new SqlParameter("Tags",SqlDbType.NVarChar),
};
parms[0].Value = model.Id;
parms[1].Value = model.CompanyId;
parms[2].Value = model.Title;
parms[3].Value = model.Content;
parms[4].Value = model.PublishDateTime;
parms[5].Value = string.IsNullOrEmpty(model.Remark) ? string.Empty : model.Remark;
parms[6].Value = string.IsNullOrEmpty(model.ImageUrl) ? string.Empty : model.ImageUrl;
parms[7].Value = string.IsNullOrEmpty(model.Tags) ? string.Empty : model.Tags;
//插入News2Tech表
InsertNews2Tech(model.Id, model.TechIds);
return SQLPlus.ExecuteNonQuery(CommandType.Text, strSQL, parms);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int Insert(CompanyNewsInfo model)
{
string strSQL = "DECLARE @MyId AS INT;INSERT INTO CompanyNews(CompanyId,Title,Content,PublishDateTime,ModifyDateTime,CreateDateTime,IsDeleted,Remark,ImageUrl,Tags,[Type]) VALUES(@CompanyId,@Title,@Content,@PublishDateTime,GETDATE(),GETDATE(),0,@Remark,@ImageUrl,@Tags,@Type);SELECT @MyId = @@IDENTITY;UPDATE CompanyNews SET Url = '/company/'+CAST(@CompanyId AS NVARCHAR(255))+'/newsdetail.html?id='+CAST(@MyId AS NVARCHAR(255)) WHERE Id = @MyId; SELECT @MyId;";
SqlParameter[] parms = {
new SqlParameter("Id",SqlDbType.Int),
new SqlParameter("CompanyId",SqlDbType.Int),
new SqlParameter("Title",SqlDbType.NVarChar),
new SqlParameter("Content",SqlDbType.NVarChar),
new SqlParameter("PublishDateTime",SqlDbType.DateTime),
new SqlParameter("Remark",SqlDbType.NVarChar),
new SqlParameter("ImageUrl",SqlDbType.NVarChar),
new SqlParameter("Tags",SqlDbType.NVarChar),
new SqlParameter("Type",SqlDbType.NVarChar),
};
parms[0].Value = model.Id;
parms[1].Value = model.CompanyId;
parms[2].Value = model.Title;
parms[3].Value = model.Content;
parms[4].Value = model.PublishDateTime <= DateTime.MinValue ? DateTime.Now : model.PublishDateTime;
parms[5].Value = string.IsNullOrEmpty(model.Remark) ? string.Empty : model.Remark;
parms[6].Value = string.IsNullOrEmpty(model.ImageUrl) ? string.Empty : model.ImageUrl;
parms[7].Value = string.IsNullOrEmpty(model.Tags) ? string.Empty : model.Tags;
parms[8].Value = string.IsNullOrEmpty(model.Type) ? "news" : model.Type;
int id = Convert.ToInt32(SQLPlus.ExecuteScalar(CommandType.Text, strSQL, parms));
//插入News2Tech表
InsertNews2Tech(id,model.TechIds);
return id;
}
/// <summary>
/// 更新
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static CompanyNewsInfo Update(CompanyNewsInfo model)
{
if (model.Id == 0)
{
int id = CompanyNewsManage.Insert(model);
model.Id = id;
}
else
{
CompanyNewsManage.Update(model);
}
return model;
}
public ActionResult ApplicationEdit(CompanyNewsInfo oldModel, FormCollection fc)
{
bool errors = false;
var companyInfo = MemberService.GetCompanyInfoByUserId(PlantEngContext.Current.UserId);
if (string.IsNullOrEmpty(oldModel.Title))
{
errors = true;
ModelState.AddModelError("TitleEmpty", "标题不能为空");
}
if (string.IsNullOrEmpty(oldModel.Content))
{
errors = true;
ModelState.AddModelError("ContentEmpty", "内容不能为空");
}
if (!errors && ModelState.IsValid)
{
oldModel.CompanyId = companyInfo.CompanyId;
oldModel.Type = "application";
//添加技术分类
string requestTechIds = fc["techcat"] == null ? string.Empty : fc["techcat"];
string[] strTechIds = requestTechIds.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
int[] techIds = strTechIds.Select(i => Utils.StrToInt(i, 0)).ToArray<int>();
oldModel.TechIds = techIds;
CompanyNewsService.Update(oldModel);
ViewBag.Msg = "保存成功！";
}
return View(oldModel);
}
