public async Task <IActionResult> PutResultMaster(int id, ResultMaster resultMaster) { if (id != resultMaster.Id) { return(BadRequest()); } _context.Entry(resultMaster).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ResultMasterExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <ActionResult <ResultMaster> > PostResultMaster(ResultMaster resultMaster) { _context.ResultMaster.Add(resultMaster); await _context.SaveChangesAsync(); return(CreatedAtAction("GetResultMaster", new { id = resultMaster.Id }, resultMaster)); }
public ActionResult Result(ExamModel model) { ExamService objService = new ExamService(); int uid = 0; if (Session["UID"] != null) { uid = Convert.ToInt32(Session["UID"].ToString()); } var lstResult = Dbcontext.ResultMasters.Where(m => m.EID == model.EID && m.StudID == model.StudID && m.SubID == model.SubID).SingleOrDefault(); if (lstResult != null) { ResultMaster res = Dbcontext.ResultMasters.Where(r => r.EID == model.EID && r.StudID == model.StudID && r.SubID == model.SubID).SingleOrDefault(); res.Marks = model.Marks; res.UpdatedBy = uid; res.UpdatedDate = System.DateTime.Now; Dbcontext.SaveChanges(); } else { model.CreatedBy = uid; model.CreatedDate = System.DateTime.Now; objService.InsertResult(model); } return(RedirectToAction("Result")); }
// 現在確定した測定データのタイトルをCSVファイルに出力する void CSVTitleOutput(String filePath) { CsvOutput csv = new CsvOutput(); var datas = ResultMaster.ReadResult(0); csv.DataInput(2, 3, "母材"); csv.DataInput(2, 4, datas.type._typeName); csv.DataInput(2, 6, "総数"); csv.DataInput(2, 7, ResultMaster.Qty.ToString() + " 枚"); csv.DataInput(2, 9, "原板ロット"); csv.DataInput(2, 10, datas._lotName); csv.DataInput(6, 3, "検査日"); csv.DataInput(6, 4, datas.now.ToString("yyyy年")); csv.DataInput(7, 4, datas.now.ToString("MM月dd日")); // int[] res = GetResult2JudgeData(ref datas); int[] res = ResultMaster.ResultCount4Rank; csv.DataInput(6, 6, "合格(紫)"); csv.DataInput(7, 6, String.Format("{0}枚", res[3])); csv.DataInput(6, 7, "合格(緑)"); csv.DataInput(7, 7, String.Format("{0}枚", res[2])); csv.DataInput(6, 8, "合格(黄)"); csv.DataInput(7, 8, String.Format("{0}枚", res[1])); csv.DataInput(6, 9, "不合格"); csv.DataInput(7, 9, String.Format("{0}枚", res[0])); // csv.DataInput(6, 7, GetResult2NGCount(ref datas).ToString() + " 枚"); csv.FileOut(filePath); }
public int InsertResult(ExamModel model) { try { Mapper.CreateMap <ExamModel, ResultMaster>(); ResultMaster objUser = Mapper.Map <ResultMaster>(model); Dbcontext.ResultMasters.Add(objUser); return(Dbcontext.SaveChanges()); } catch (Exception ex) { throw ex; } }
public static List <ResultMaster> SaveResultMaster(ResultMaster resultmaster) { OracleParameterCollection param = new OracleParameterCollection(); param.Add(new OracleParameter(Common.CMS_SP_INSERT_RESULT_MST.E_KEY, resultmaster.KEY)); param.Add(new OracleParameter(Common.CMS_SP_INSERT_RESULT_MST.E_ACTION_ID, resultmaster.ACTION_ID)); param.Add(new OracleParameter(Common.CMS_SP_INSERT_RESULT_MST.E_RESULT_CODE, resultmaster.RESULT_CODE)); param.Add(new OracleParameter(Common.CMS_SP_INSERT_RESULT_MST.E_RESULT_DESC, resultmaster.RESULT_DESC)); param.Add(new OracleParameter(Common.CMS_SP_INSERT_RESULT_MST.E_ACTIVE, resultmaster.USER_ACTIVE)); param.Add(new OracleParameter(Common.CMS_SP_INSERT_RESULT_MST.P_OUTTBL, OracleType.Cursor)); param[Common.CMS_SP_INSERT_RESULT_MST.P_OUTTBL].Direction = ParameterDirection.Output; OracleParameter[] Oraparam = new OracleParameter[param.Count]; param.CopyTo(Oraparam, 0); param.Clear(); var liResultMaster = (List <ResultMaster>)OracleHelper.FetchData <ResultMaster>(Oraparam, Common.Queries.CMS_SP_INSERT_RESULT_MST, EnumCommand.DataSource.list).DataSource.Data; return(liResultMaster); }
void _writeCsvResultAndGraph(CsvOutput csv, int page) { var d = ResultMaster.ReadResult(page); csv.DataInput(0, 0, String.Format("{0}枚目", page + 1)); csv.DataInput(0, 1, "検査日"); csv.DataInput(1, 1, d.now.ToString("yyyy/MM/dd HH:mm:ss")); csv.DataInput(0, 2, "検査品番"); csv.DataInput(1, 2, d._typeName); csv.DataInput(0, 3, "公称厚み"); csv.DataInput(1, 3, d.type._stdThickness + "mm"); csv.DataInput(3, 1, "総合判定"); csv.DataInput(4, 1, d._allResult); csv.DataInput(3, 2, "総合平均"); csv.DataInput(4, 2, d._allAverage); csv.DataInput(3, 3, "基準値"); csv.DataInput(4, 3, d.type.GetRange); csv.DataInput(7, 1, "検査担当者"); csv.DataInput(8, 1, d._humanName); csv.DataInput(0, 5, "項目"); csv.DataInput(1, 5, "A列"); csv.DataInput(2, 5, "B列"); csv.DataInput(3, 5, "C列"); csv.DataInput(4, 5, "D列"); csv.DataInput(5, 5, "E列"); csv.DataInput(6, 5, "F列"); csv.DataInput(7, 5, "G列"); csv.DataInput(0, 6, "最小値"); csv.DataInput(0, 7, "最大値"); csv.DataInput(0, 8, "平均値"); csv.DataInput(0, 9, "判定"); for (int row = 0; row < 4; row++) { for (int col = 0; col < 7; col++) { csv.DataInput(col + 1, row + 6, d._results[row][col]); } } csv.DataInput(10, 0, new String[] { "CNT", "A", "B", "C", "D", "E", "F", "G" }); int x = 11, y = 1; foreach (var val in d.GetResultMM()) { if (!float.IsNaN(val)) { csv.DataInput(x, y, val.ToString()); x++; } else { csv.DataInput(10, y, y.ToString()); y++; x = 11; } } csv.AddOffset(0, y + 2); }
// 現在確定した測定データ一覧をCSVファイルに出力する void CSVOutput(String filePath) { CsvOutput csv = new CsvOutput(); //var datas = ResultMaster.ReadResult( 0 ); int pageMax = ResultMaster.Qty; int page = 1; if (ResultMaster.Qty == 0) { return; } for (int i = 0; i < pageMax; i++) { _writeCsvResultAndGraph(csv, i); } for (int i = 0; i < pageMax; i++) { var d = ResultMaster.ReadResult(i); csv.DataInput(0, 0, String.Format("{0}枚中{1}枚目", pageMax, page)); csv.DataInput(0, 1, "検査日"); csv.DataInput(1, 1, d.now.ToString("yyyy/MM/dd HH:mm:ss")); csv.DataInput(0, 2, "検査品番"); csv.DataInput(1, 2, d._typeName); csv.DataInput(0, 3, "公称厚み"); csv.DataInput(1, 3, d.type._stdThickness + "mm"); csv.DataInput(3, 1, "総合判定"); csv.DataInput(4, 1, d._allResult); csv.DataInput(3, 2, "総合平均"); csv.DataInput(4, 2, d._allAverage); csv.DataInput(3, 3, "基準値"); csv.DataInput(4, 3, d.type.GetRange); csv.DataInput(7, 1, "検査担当者"); csv.DataInput(8, 1, d._humanName); csv.DataInput(0, 5, "項目"); csv.DataInput(1, 5, "A列"); csv.DataInput(2, 5, "B列"); csv.DataInput(3, 5, "C列"); csv.DataInput(4, 5, "D列"); csv.DataInput(5, 5, "E列"); csv.DataInput(6, 5, "F列"); csv.DataInput(7, 5, "G列"); csv.DataInput(0, 6, "最小値"); csv.DataInput(0, 7, "最大値"); csv.DataInput(0, 8, "平均値"); csv.DataInput(0, 9, "判定"); for (int row = 0; row < 4; row++) { for (int col = 0; col < 7; col++) { csv.DataInput(col + 1, row + 6, d._results[row][col]); } } csv.AddOffset(0, 13); page++; } csv.FileOut(filePath); }