/// <summary> /// 创建资源 /// </summary> /// <param name="model"></param> public static void Create(ManageResViewModel model) { //using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext()) using (MRDataEntities _db = new MRDataEntities()) { tbl_Resource res = new tbl_Resource() { res_Movie = model.MovieId, res_Name = model.FileName, res_Content = model.Content, res_Size = float.Parse(model.FileSize), res_Type = model.ResType, res_FavorCount = 0, res_Status = model.Status }; if (model.User != null) { res.res_User = model.User; } string guid; do { guid = Guid.NewGuid().ToString("N").ToUpper(); } while (_db.tbl_Resource.Where(p => p.res_Id == guid).Count() != 0); res.res_Id = guid; //_db.tbl_Resource.InsertOnSubmit(res); //_db.SubmitChanges(); //_db.SetResTime(guid); _db.tbl_Resource.Add(res); _db.SaveChanges(); } }
public ActionResult Index(FormCollection coll)//, string date, string user, int resid, string mode) { #region GetUser string User_CAI = ""; if (coll["ddlUsers"] == null) { User_CAI = User.Identity.Name.ToUpper().Replace("CT\\", ""); } // User_CAI = "PALX"; else { User_CAI = coll["ddlUsers"]; } #endregion #region GetDate DateTime myDate = DateTime.Now; if (coll["txtDate"] != null) { myDate = DateTime.Parse(coll["txtDate"]); } #endregion foreach (var item in coll) { try { if (item.ToString().Contains("chk")) //Only check the checkboxes { tbl_Resource myres = resourcedb.GetResource(int.Parse(item.ToString().Replace("chk", ""))); if (coll[item.ToString()].Replace(",false", "") == "true") { myres.Hide = true; } else if (coll[item.ToString()].Replace(",false", "") == "false") { myres.Hide = false; } } } catch { //Do nothing } } try { resourcedb.Save(); } catch { } string role = roledb.GetUserRolesByUser(User.Identity.Name.ToString().ToUpper().Replace("CT\\", ""))[0]; ViewData["Role"] = role; ViewData["Users"] = new SelectList(userdb.GetUserItems(), "cai", "detail", User_CAI); ViewData["UserProjects"] = userdb.GetUserResources(User_CAI).ToList(); return(View(timedb.GetTimeSheetByUser(User_CAI, myDate))); }
/// <summary> /// 删除资源 /// </summary> /// <param name="id">资源id</param> public static void Delete(string id) { using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext()) { tbl_Resource res = _db.tbl_Resource.SingleOrDefault(s => s.res_Id == id); _db.tbl_Resource.DeleteOnSubmit(res); _db.SubmitChanges(); } }
/// <summary> /// 审核资源不通过 /// </summary> /// <param name="model"></param> public static void Reject(RejectResViewModel model) { using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext()) { tbl_Resource res = _db.tbl_Resource.SingleOrDefault(s => s.res_Id == model.Id); res.res_Status = 1; res.res_Note = model.Note; _db.SubmitChanges(); } }
/// <summary> /// 审核资源通过 /// </summary> /// <param name="id">资源id</param> public static void Audit(string id) { using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext()) { tbl_Resource res = _db.tbl_Resource.SingleOrDefault(s => s.res_Id == id); res.res_Status = 2; _db.SubmitChanges(); } }
public ActionResult DeleteProjectResource(int resource_ID) { try { tbl_Resource resource = resourcedb.GetResource(resource_ID); resourcedb.Delete(resource); resourcedb.Save(); return(Json(new { Status = true, Message = "Success" })); } catch { return(Json(new { Status = false, Message = "Fail" })); } }
public ActionResult ChangeProjectHours(int ResourceID, decimal ProjectHours) { try { tbl_Resource resource = resourcedb.GetResource(ResourceID); resource.ResourceHours = ProjectHours; resourcedb.Save(); return(Json(new { Status = true, Message = "Success" })); } catch (Exception ex) { return(Json(new { Status = false, Message = "Fail: " + ex.Message })); } }
public ResViewModel(tbl_Resource res) { Id = res.res_Id; Content = res.res_Content; FileName = res.res_Name; if (res.res_Size > 1024 * 1024 * 1024) { FileSize = (res.res_Size / (1024 * 1024 * 1024)).ToString() + " G"; } else if (res.res_Size > 1024 * 1024) { FileSize = (res.res_Size / (1024 * 1024)).ToString() + " M"; } else if (res.res_Size > 1024) { FileSize = (res.res_Size / (1024)).ToString() + " K"; } else { FileSize = res.res_Size.ToString() + " 字节"; } FavorCount = (int)res.res_FavorCount; ResType = (byte)res.res_Type; Status = (byte)res.res_Status; Note = res.res_Note; if (!string.IsNullOrEmpty(res.res_User) && !string.IsNullOrWhiteSpace(res.res_User)) { //MR_DataClassesDataContext _db = new MR_DataClassesDataContext(); MRDataEntities _db = new MRDataEntities(); User = res.res_User; Account = _db.tbl_UserAccount.SingleOrDefault(u => u.user_Id == res.res_User).user_Account; } Movie = res.res_Movie; MovieTitle = MovieManager.GetTitle(res.res_Movie); }
public ActionResult InsertProjectResource(int Project_ID, string User_CAI) { try { if (resourcedb.FindResource(Project_ID, User_CAI).Count() > 0) { return(Json(new { Status = false, Message = "Fail" })); } else { tbl_Resource resource = new tbl_Resource(); resource.User_CAI = User_CAI; resource.Project_ID = Project_ID; resource.active = true; resourcedb.Add(resource); resourcedb.Save(); return(Json(new { Status = true, Message = "Success" })); } } catch (Exception ex) { return(Json(new { Status = false, Message = "Fail: " + ex.Message })); } }