public ActionResult WorksAdd(Works model, IEnumerable <HttpPostedFileBase> file)
{
try
{
string physicalPath = "~/Areas/Admin/Files/Images/";
int maxFileSize = 500000;
Dictionary <FileResultItem, FileResultType> resultModel = FileDocumentUpload(file, maxFileSize, physicalPath, new string[] { "image/gif", "image/png", "image/jpeg", "image/pjpeg", "image/bmp", "image/x-png", "image/jpg" });
foreach (var item in resultModel)
{
if (item.Value == FileResultType.Error || item.Value == FileResultType.NoneFile || item.Value == FileResultType.SizeOver || item.Value == FileResultType.WrongType)
{
RemoveAll(resultModel.Keys, physicalPath);
return(View("WorksAdd"));
}
}
foreach (var item in resultModel.Keys)
{
_worksService.Add(new Works {
PhotoURL = item.UploadPath, Description = model.Description, Title = model.Title
});
}
}
catch (Exception)
{
throw;
}
return(RedirectToAction("WorksList"));
}
private List <PlWorkingInfo> OnRefreshSublistViewData()
{
var operations = GetDefaultOperations();
Works.Clear();
var workings = GetWorkingsByOperations(operations, null);
if (workings.Length == 0)
{
return(new List <PlWorkingInfo>());
}
var workIds = workings.Where(p => p.WORKID_R.HasValue).Select(p => p.WORKID_R.Value).Distinct().ToArray();
using (var mgr = IoC.Instance.Resolve <IBaseManager <Work> >())
{
foreach (var workid in workIds)
{
Works[workid] = mgr.Get(workid, GetModeEnum.Partial);
}
}
return(workings.Where(p => p.WORKID_R.HasValue)
.Select(p => new PlWorkingInfo(p, Works[p.WORKID_R.Value].Get <string>("VOPERATIONNAME")))
.ToList());
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["username"] == null)
{
Response.Write("<script>alert('尚未登录！');location='Login.aspx'</script>");
}
else
{
if (!IsPostBack)
{
Regex r = new Regex("^[1-9]d*|0$");
if (Request.QueryString["id"] != null && r.IsMatch(Request.QueryString["id"]))
{
int id = Convert.ToInt32(Request.QueryString["id"]);
using (var db = new ITShowEntities())
{
Works person = (from it in db.Works where it.WorksId == id select it).FirstOrDefault();
if (person != null)
{
txtTitle.Text = person.WorksName;
txtLink.Text = person.WorksUrl;
txtTime.Value = person.WorksTime.ToString();
btnImage.ImageUrl = person.WorksImage.Trim();
if (Request.Cookies["arr"] != null)
{
txtTitle.Text = Server.UrlDecode(Request.Cookies["arr"]["title"]);
txtLink.Text = Server.UrlDecode(Request.Cookies["arr"]["link"]);
txtTime.Value = Server.UrlDecode(Request.Cookies["arr"]["time"]);
HttpCookie cookies = Request.Cookies["arr"];//删除cookies
cookies.Expires = System.DateTime.Now.AddDays(-1);
Response.Cookies.Add(cookies);
}
if (Request.Cookies["url"] != null)
{
btnImage.ImageUrl = Request.Cookies["url"].Value;
HttpCookie cookies1 = Request.Cookies["url"];//删除cookies
cookies1.Expires = System.DateTime.Now.AddDays(-1);
Response.Cookies.Add(cookies1);
}
}
else
{
Response.Write("<script>alert('地址栏有误');location='WorksList.aspx'</script>");
}
}
}
else
{
Response.Write("<script>alert('地址栏有误');location='WorksList.aspx'</script>");
}
}
}
}
public void Update(WorksBO work)
{
Works newWork = AutoMapper <WorksBO, Works> .Map(work);
Database.WorksUowRepository.Update(newWork);
Database.Save();
}
public int LoadFromDataBase()
{
X.ADO.CommandedTable worksCTable = X.ADO.GetTable("select * from Work", "Work");
X.ADO.CommandedTable booksCTable = X.ADO.GetTable("select * from Book", "Book");
X.ADO.CommandedTable cdsCTable = X.ADO.GetTable("select * from CD", "CD");
if (worksCTable == null)
{
return(0);
}
else
{
foreach (DataRow row in booksCTable.DataTable.Rows)
{
if (GetBook((int)row["Code"]) == null)
{
Works.Add(new Book("", (string)row["AuthorName"], (string)row["EditorName"]));
}
}
foreach (DataRow row in cdsCTable.DataTable.Rows)
{
if (GetCD((int)row["Code"]) == null)
{
Works.Add(new CD("", (string)row["ArtistName"], (int)row["TrackCount"]));
}
}
foreach (DataRow row in worksCTable.DataTable.Rows)
{
if (GetWork((int)row["Code"]) != null)
{
Works[worksCTable.DataTable.Rows.IndexOf(row)].Title = (string)row["Title"];
}
}
return(worksCTable.DataTable.Rows.Count);
}
}
/// <summary>
/// 일정 데이터 추가시 보드 폼에서 일정 라벨 추가
/// </summary>
/// <param name="boardForm"></param>
public void AddWorkLabel(BoardForm boardForm)
{
int tabIndex = boardForm.TabControl.SelectedIndex;
TabPage tabPage = boardForm.TabControl.TabPages[tabIndex];
tabPage.AutoScroll = true;
Label newWork = new Label
{
Name = "Work" + Works.Last().MyID,
Text = Works.Last().WorkName,
BackColor = Works.Last().Color,
Size = new Size(tabPage.Size.Width - 10, 50),
Location = new Point(5, 50 + (70 * (Works.Count - 1))),
BorderStyle = BorderStyle.FixedSingle,
TextAlign = ContentAlignment.MiddleCenter
};
newWork.Click += (s, e) =>
{
boardForm.CBoardForm.LabelClick((Label)s);
};
tabPage.Controls.Add(newWork);
}
public HttpResponseMessage UpdateWork(Works obj)
{
ReturnHelper rh = new ReturnHelper(200, null, 0, "");
try
{
obj.Update_Time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
int i = obj.Update(" Work_Id=@Work_Id", obj.Work_Id);
if (i > 0)
{
rh.msg = "更新作品成功";
rh.totals = i;
}
else
{
rh.msg = "更新作品失败";
rh.code = 400;
}
}
catch (Exception e)
{
rh.code = 500;
rh.msg = "服务器错误，请通知管理员";
}
return(ReturnJson(JsonConvert.SerializeObject(rh)));
}
public bool UpdateAsync(Works model)
{
using (var conn = DapperFactory.GetConnection()) {
List <string> removeFields = new List <string>
{
"Id",
"MajorName",
"CreateTime",
"Status"
};
if (String.IsNullOrEmpty(model.ImgUrl))
{
removeFields.Add("ImgUrl");
}
var fields = model.ToFields(removeFields: removeFields);
if (fields == null || fields.Count == 0)
{
return(false);
}
var fieldList = new List <string>();
foreach (var field in fields)
{
fieldList.Add(string.Format("{0}=@{0}", field));
}
model.ModifyTime = DateTime.Now;
string sql = string.Format("update [Works] set {0} where Id=@Id;", string.Join(",", fieldList));
return(conn.Execute(sql, model) > 0);
}
}
protected void rpt_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "delete")
{
int id = Convert.ToInt32(e.CommandArgument);
using (var db = new ITShowEntities())
{
Works person = (from it in db.Works where it.WorksId == id select it).FirstOrDefault();
db.Works.Remove(person);
if (db.SaveChanges() == 1)
{
Response.Write("<script>alert('删除成功');location='WorksList.aspx'</script>");
}
else
{
Response.Write("<script>alert('删除失败请重试');location='WorksList.aspx'</script>");
}
}
}
//if (e.CommandName == "URL")
//{
// //string url = Server.UrlEncode (e.CommandArgument.ToString().Trim());
// string url = e.CommandArgument.ToString().Trim();
// Response.Write("<script>window.open('http://www.baidu.com','_blank')</script>");
//}
}
public async Task <IActionResult> Edit(int id, [Bind("WorkId,Company,WorkTitle,WorkLength,Description")] Works works)
{
if (id != works.WorkId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(works);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!WorksExists(works.WorkId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(works));
}
protected void Page_Load(object sender, EventArgs e)
{
id = Convert.ToInt32(Request.QueryString["id"]);
string sql = string.Format("select * from WorksList where ID='{0}' ", id);
string sql2 = "";
DataTable dt = SQLServices.GetDataSet(sql).Tables[0];
works = new Works();
user = (UserInfo)Session["User"];
foreach (DataRow row in dt.Rows)
{
works.Name = row["Author"].ToString();
works.Title = row["Title"].ToString();
}
if (!IsPostBack)
{
if (user.Type.Trim() == "教师" || user.Name.Trim() == works.Name.Trim())
{
sql2 = string.Format("select * from Message m, WorksList w where w.ID={0} and m.Title=w.Title", id);
}
else
{
sql2 = string.Format("select m.Name,m.Message from Message as m where Title = '{0}' and Name in ( select Name from UserList where Type = '学生')", works.Title);
}
Repeater1.DataSource = SQLServices.GetDataSet(sql);
Repeater1.DataBind();
Repeater2.DataSource = SQLServices.GetDataSet(sql2);
Repeater2.DataBind();
}
}
public CarDetailViewModel(CarListDetailsDataModel model, int errorsCount)
: base(model, errorsCount)
{
CompanyID = model.CompanyID;
DateProduce = model.DateProduce;
DatePurchase = model.DatePurchase;
EngineType = model.EngineType;
EngineVolume = model.EngineVolume;
CompanyName = model.UserName;
CompanyPhone = model.UserPhone;
TransmissionType = model.TransmissionType;
model.Works.ForEach(o => Works.Add(o));
CompanyHandler.Instance.LoadComplete += Instance_LoadComplete;
CompanyHandler.Instance.GetCompany(model.CompanyID);
_model = model;
_errorsCount = errorsCount;
if (_errorsCount > 0)
{
_visErrors = Visibility.Visible;
}
DisplayLogoImage();
CarsHandler.Instance.OrderDataLoaded += Instance_OrderDataLoaded;
CarsHandler.Instance.GetCarOrder(CarStorage.Instance.SelectedCar.CarModel.CarNumber);
CarsHandler.Instance.GetCarRecomendationsComplete += Instance_GetCarRecomendationsComplete;
CarsHandler.Instance.GetCarRecomendations(_model.ID);
}
//Repeater分页控制显示方法
public void contrlRepeater()
{
string value = ChangeType.SelectedValue;
DataTable pageDt = GetWorksInfo(value);
PagedDataSource pds = new PagedDataSource();
pds.DataSource = pageDt.DefaultView;
pds.AllowPaging = true;
pds.PageSize = 8;
pds.CurrentPageIndex = Convert.ToInt32(this.labPage.Text) - 1;
Works.DataSource = pds;
LabCountPage.Text = pds.PageCount.ToString();
labPage.Text = (pds.CurrentPageIndex + 1).ToString();
this.lbtnpritPage.Enabled = true;
this.lbtnFirstPage.Enabled = true;
this.lbtnNextPage.Enabled = true;
this.lbtnDownPage.Enabled = true;
if (pds.CurrentPageIndex < 1)
{
this.lbtnpritPage.Enabled = false;
this.lbtnFirstPage.Enabled = false;
}
if (pds.CurrentPageIndex == pds.PageCount - 1)
{
this.lbtnNextPage.Enabled = false;
this.lbtnDownPage.Enabled = false;
}
Works.DataBind();
}
public void Run(int start, int length, Works w)
{
//保存线程
List <Task> tasks = new List <Task>();
//计算每个线程分配数量
//区间左开右闭
var dl = (int)Math.Ceiling((double)length / ThreadingCount);
for (int i = 0; i < ThreadingCount; i++)
{
if ((i + 1) * dl > length)
{
//这个时候已经将任务分配完了
//不需要再开线程了
var b = i * dl;
var n = length;
tasks.Add(Task.Run(() => w(i * dl, length, WorkBarrier)));
break;
}
else
{
var b = i * dl;
var n = i * dl + dl;
tasks.Add(Task.Run(() => w(b, n, WorkBarrier)));
}
}
Task.WaitAll(tasks.ToArray());
}
/// <summary>
/// 图片文件的显示：相册
/// </summary>
/// <param name="serviceWorks"></param>
/// <param name="worksId"></param>
/// <returns></returns>
private void ShowImages(long worksId)
{
StringBuilder htmlContent = new StringBuilder();
List <WorksFile> imagesList = Bll.WorksBll.GetWorksFile(worksId.ToString(), "2");
if (imagesList.Count > 0)
{
Works works = Bll.WorksBll.GetWorksSubmitById(worksId.ToString());
string periodId = works.PeriodID.ToString();
Periods period = Bll.WorksBll.GetPeriodsById(periodId).FirstOrDefault();
string courseId = period.CourseID.ToString();
Course course = Bll.WorksBll.GetCourseById(courseId).FirstOrDefault();
string siteUrl = "http://va.neu.edu.cn";
if (course != null)
{
siteUrl += course.Url;
}
htmlContent.AppendLine("<fieldset><legend>作品图片</legend>");
htmlContent.AppendLine("<div class='box'>");
htmlContent.AppendLine("<div id ='imgs' class='imgs'>");
foreach (var file in imagesList)
{
htmlContent.AppendLine("<img src='" + siteUrl + file.FilePath + "' onClick='$(this).ImgZoomIn();' height='200'>");
}
htmlContent.AppendLine("</div>");
htmlContent.AppendLine("</div>");
htmlContent.AppendLine("</fieldset>");
ImagesDiv.InnerHtml = htmlContent.ToString();
}
else
{
ImagesDiv.Visible = false;
}
}
public HttpResponseMessage DeleteWork(Works obj)
{
ReturnHelper rh = new ReturnHelper(200, null, 0, "");
try
{
int i = obj.Delete(" Work_Id=@Work_Id", obj.Work_Id);
if (i > 0)
{
rh.msg = "删除作品成功";
rh.totals = i;
}
else
{
rh.msg = "删除作品失败";
rh.code = 400;
}
}
catch (Exception e)
{
rh.code = 500;
rh.msg = "服务器错误，请通知管理员";
}
return(ReturnJson(JsonConvert.SerializeObject(rh)));
}
/// <summary>
/// Create a fixed-key subwork.
/// </summary>
/// <param name="name"></param>
/// <param name="attach">an attachment object</param>
/// <typeparam name="W"></typeparam>
/// <returns>The newly created and subwork instance.</returns>
/// <exception cref="ServiceException">Thrown if error</exception>
public W Create <W>(string name, object attach = null) where W : Work
{
if (Level >= MaxNesting)
{
throw new ServiceException("allowed work nesting " + MaxNesting);
}
if (works == null)
{
works = new Roll <Work>(16);
}
// create instance by reflection
Type typ = typeof(W);
ConstructorInfo ci = typ.GetConstructor(new[] { typeof(WorkContext) });
if (ci == null)
{
throw new ServiceException(typ + "no valid constructor");
}
WorkContext wc = new WorkContext(name)
{
Attach = attach,
Parent = this,
Level = Level + 1,
Directory = (Parent == null) ? name : Path.Combine(Parent.Directory, name),
Service = Service
};
W work = (W)ci.Invoke(new object[] { wc });
Works.Add(work);
return(work);
}
public JsonResult Set(Works model)
{
if (model == null)
{
return(Error("参数错误。"));
}
var fileWorks = Request.Files["fileWorks"];
if (fileWorks != null)
{
string uploadResult = UploadHelper.Process(fileWorks.FileName, fileWorks.InputStream);
if (!string.IsNullOrEmpty(uploadResult))
{
model.ImgUrl = uploadResult;
}
}
if (String.IsNullOrEmpty(model.ImgUrl))
{
return(Error("作品图片不能为空。"));
}
var result = new ResultBase();
if (model.Id > 0)
{
result.success = _worksService.UpdateAsync(model);
}
else
{
result.success = _worksService.InsertAsync(model);
}
return(Json(result));
}
/// <summary>
/// 通过ID获取作品信息
/// </summary>
/// <param name="worksId">作品ID</param>
/// <returns></returns>
public static Works GetWorksSubmitById(string worksId)
{
long workId = long.Parse(worksId);
Works ds = db.Works.SingleOrDefault(p => p.WorksID == workId);
return(ds);
}
public ActionResult Delete(int?id)
{
bool Flag = true;
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Works works = db.Works.Find(id);
if (works == null)
{
return(HttpNotFound());
}
var worktimes = db.WorkTimes.Where(p => p.WorksId == id).FirstOrDefault();
var workmanager = db.WorkManages.Where(p => p.WorksId == id).FirstOrDefault();
if (worktimes == null && workmanager == null)
{
Flag = true;
}
else
{
Flag = false;
}
ViewBag.a = Flag;
return(View(works));
}
/// <summary>
/// 加载
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
Useraccount = currentUser.LoginName.ToString();
Useraccount = Useraccount.Substring(Useraccount.IndexOf('\\') + 1);
//我的作品gvMyWorks事件
gvMyWorks.PagerSettings.Mode = PagerButtons.NumericFirstLast;
gvMyWorks.PagerSettings.FirstPageText = "1";
gvMyWorks.DataKeyNames = new string[] { "WorksID" };
ViewState["SortOrder"] = "Score";
ViewState["OrderDire"] = "ASC";
//ddl课程和期次绑定
BindCourses(DAL.Course.GetCourses().Tables[0]);
ddlPeriods.Visible = false;
//BindPeriods(Convert.ToInt64(ddlCourses.SelectedValue));
if (Useraccount == null)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "message", "alert('请先登录');window.opener ='';window.open('','_self');window.close()", true);
//return;
}
else
{
DataTable dtMyWorks = Works.GetMyWorks(Useraccount).Tables[0];
ViewState["worksinfo"] = dtMyWorks;
BindWorks(dtMyWorks);
}
}
}
public ActionResult Main(UploadViewModel upload)
{
portfolioContext context = new portfolioContext();
if (!ModelState.IsValid)
{
return(View("Index", upload));
}
int id = Convert.ToInt32(upload.Works.Filter);
var filtervalue = context.filters.SingleOrDefault(x => x.Id == id);
HttpPostedFileBase image = Request.Files["Image"];
byte[] bytes = null;
using (BinaryReader br = new BinaryReader(image.InputStream))
{
bytes = br.ReadBytes(image.ContentLength);
}
Works work = new Works
{
Image = bytes,
Description = upload.Works.Description,
Title = upload.Works.Title,
Filter = filtervalue.Filter,
DT = DateTime.Now
};
context.Works.Add(work);
context.SaveChanges();
return(RedirectToAction("Main", "Admin"));
}
public HttpResponseMessage AddWork(Works obj)
{
ReturnHelper rh = new ReturnHelper(200, null, 0, "");
try
{
obj.Work_Id = Guid.NewGuid().ToString("N");
obj.Report_Time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
int i = obj.Insert();
if (i > 0)
{
rh.msg = "添加作品成功";
rh.totals = i;
}
else
{
rh.msg = "添加作品失败";
rh.code = 400;
}
}
catch (Exception e)
{
rh.code = 500;
rh.msg = "服务器错误，请通知管理员";
}
return(ReturnJson(JsonConvert.SerializeObject(rh)));
}
/// <summary>
/// 删除作品
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtnDelete_Click(object sender, ImageClickEventArgs e)
{
string worksId = WorksId.ToString();
Works wks = Bll.WorksBll.GetWorksSubmitById(worksId);
wks.Flag = 0;
Bll.WorksBll.Update(wks);
}
public ActionResult DeleteConfirmed(int id)
{
Works works = db.Works.Find(id);
db.Works.Remove(works);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private void OnAddWork()
{
var newWork = new WorkTileViewModel(this);
Works.Add(newWork);
newWork.OnEdit();
WasChanged = true;
}
public Utils(Form mainForm)
{
this.MainForm = mainForm;
this.Action = new Actions(this);
this.Menu = new Menus(this);
this.Animation = new Animations(this);
this.Work = new Works(this);
}
public MetadataRecord(int priref)
{
var works = new Works();
var task = Task.Run(() => works.GetWork(priref));
task.Wait();
Work = task.Result;
}
public void WhenSearchingForWorksAndThereAreMoreThan100RepeatedRequestsAreMadeAndTheEndResultIsAggregated()
{
const string artistId = "6fe07aa5-fec0-4eca";
var page1 = new Works
{
Id = "the id",
Title = "Some Song"
};
var page2 = new Works
{
Id = "second page",
Title = "another song that's on a different page",
Disambiguation = "hello"
};
var expected = new List <Works>
{
page1,
page2
};
var httpClientWrapperPage1 = new Mock <IHttpClientWrapper>();
httpClientWrapperPage1.Setup(x => x.GetResponse <MusicBrainzArtistWorksCollection>())
.Returns(new MusicBrainzArtistWorksCollection {
Works = new List <Works> {
page1
}, WorkCount = 101, WorkOffset = 0
});
var httpClientWrapperPage2 = new Mock <IHttpClientWrapper>();
httpClientWrapperPage2.Setup(x => x.GetResponse <MusicBrainzArtistWorksCollection>())
.Returns(new MusicBrainzArtistWorksCollection {
Works = new List <Works> {
page2
}, WorkCount = 101, WorkOffset = 100
});
var httpClientFactory = new Mock <IHttpClientFactoryWrapper>();
httpClientFactory
.Setup(x => x.CreateClient(HttpMethod.Get,
$"http://musicbrainz.org/ws/2/work?artist={artistId}&limit=100&offset=0"))
.Returns(httpClientWrapperPage1.Object);
httpClientFactory
.Setup(x => x.CreateClient(HttpMethod.Get,
$"http://musicbrainz.org/ws/2/work?artist={artistId}&limit=100&offset=100"))
.Returns(httpClientWrapperPage2.Object);
var classUnderTest = new ArtistRepository(httpClientFactory.Object);
var result = classUnderTest.GetWorksFor(artistId);
Assert.Collection(result.Works,
item => Assert.Equal(page1, item),
item => Assert.Equal(page2, item));
}
public bool InsertAsync(Works model)
{
if (model == null)
{
throw new ArgumentNullException("model不能为null");
}
return(_worksRepository.InsertAsync(model));
}
public static void Main (string [] args)
{
// this works
Works w = new Works (3.0);
w [0, 0] += 3.0;
// this breaks
Breaks b = new Breaks (3.0);
b [0, 0] += 3.0;
}
public static void Main(string[] args)
{
System.Console.WriteLine("This works");
Works w = new Works(3.0);
w[0, 0] += 3.0;
System.Console.WriteLine("This breaks");
Breaks b = new Breaks(3.0);
b[0, 0] += 3.0;
}
