public ActionResult Create(AttachmentInfo model,FormCollection fc) {
bool errors = false;
if(string.IsNullOrEmpty(model.Title)){
errors = true;
ModelState.AddModelError("Title", "Please enter the name of the attachment");
}
if(!errors && ModelState.IsValid){
//分类
model.CategoryId = Utils.StrToInt(fc["ddlCats"], 0);
if (model.CategoryId == 0)
{
ModelState.AddModelError("CategoryError", "Please select the category");
}
else
{
int id = AttachmentService.Create(model).Id;
ViewBag.Status = false;
if (id > 0)
{
ViewBag.Status = true;
}
}
}
return View(model);
}
/// <summary>
/// 添加或编辑
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static AttachmentInfo Create(AttachmentInfo model) {
if (model.Id == 0)
{
int id = AttachmentManage.Insert(model);
model.Id = id;
}
else {
AttachmentManage.Update(model);
}
return model;
}
/// <summary>
/// 更新
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int Update(AttachmentInfo model) {
string strSQL = "UPDATE dbo.Attachment SET Title = @Title,ImageUrl = @ImageUrl,DownloadUrl = @DownloadUrl,Size = @Size ,Sort = @Sort,CategoryId = @CategoryId WHERE Id = @Id";
SqlParameter[] param = {
new SqlParameter("Id",SqlDbType.Int),
new SqlParameter("Title",SqlDbType.NVarChar),
new SqlParameter("ImageUrl",SqlDbType.NVarChar),
new SqlParameter("DownloadUrl",SqlDbType.NVarChar),
new SqlParameter("Size",SqlDbType.Int),
new SqlParameter("Sort",SqlDbType.Int),
new SqlParameter("CategoryId",SqlDbType.Int),
};
param[0].Value = model.Id;
param[1].Value = model.Title ?? string.Empty;
param[2].Value = model.ImageUrl ?? string.Empty;
param[3].Value = model.DownloadUrl ?? string.Empty;
param[4].Value = model.Size;
param[5].Value = model.Sort;
param[6].Value = model.CategoryId;
return Goodspeed.Library.Data.SQLPlus.ExecuteNonQuery(CommandType.Text,strSQL,param);
}
/// <summary>
/// 插入
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int Insert(AttachmentInfo model) {
string strSQL = "INSERT INTO dbo.Attachment(Title,ImageUrl,DownloadUrl,IsDeleted,CreateDateTime,Size,Sort,CategoryId) VALUES(@Title,@ImageUrl,@DownloadUrl,0,GETDATE(),@Size,@Sort,@CategoryId);SELECT @@IDENTITY;";
SqlParameter[] param = {
new SqlParameter("Id",SqlDbType.Int),
new SqlParameter("Title",SqlDbType.NVarChar),
new SqlParameter("ImageUrl",SqlDbType.NVarChar),
new SqlParameter("DownloadUrl",SqlDbType.NVarChar),
new SqlParameter("Size",SqlDbType.Int),
new SqlParameter("Sort",SqlDbType.Int),
new SqlParameter("CategoryId",SqlDbType.Int),
};
param[0].Value = model.Id;
param[1].Value = model.Title ?? string.Empty;
param[2].Value = model.ImageUrl ?? string.Empty;
param[3].Value = model.DownloadUrl ?? string.Empty;
param[4].Value = model.Size;
param[5].Value = model.Sort;
param[6].Value = model.CategoryId;
return Convert.ToInt32(Goodspeed.Library.Data.SQLPlus.ExecuteScalar(CommandType.Text,strSQL,param));
}