/// <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 }));
}
}
