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, "Ａ列");
csv.DataInput(2, 5, "Ｂ列");
csv.DataInput(3, 5, "Ｃ列");
csv.DataInput(4, 5, "Ｄ列");
csv.DataInput(5, 5, "Ｅ列");
csv.DataInput(6, 5, "Ｆ列");
csv.DataInput(7, 5, "Ｇ列");
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, "Ａ列");
csv.DataInput(2, 5, "Ｂ列");
csv.DataInput(3, 5, "Ｃ列");
csv.DataInput(4, 5, "Ｄ列");
csv.DataInput(5, 5, "Ｅ列");
csv.DataInput(6, 5, "Ｆ列");
csv.DataInput(7, 5, "Ｇ列");
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);
}
