public ActionResult Index()
{
IEnumerable <ex1table> table;
using (var ent = new fp7dataEntities1())
{
table = ent.ex1table.ToArray();
}
return(View(table));
}
public int[] Search(string keyword)
{
int[] hit = new int[0];
int hitcount = 0;
using (var ctx = new fp7dataEntities1())
{
foreach (ex1table searchRecord in ctx.ex1table)
{
// Keyword文字列がIDに含まれるか
if (keyword.Length <= searchRecord.id.ToString().Length)
{
if (isHitIndex(searchRecord.id.ToString(), keyword))
{
hitcount += 1;
Array.Resize(ref hit, hitcount);
hit[hitcount - 1] = (int)searchRecord.id;
continue;
}
}
// Keyword文字列が年月日に含まれるか
if (keyword.Length <= searchRecord.time.ToLongDateString().Length)
{
if (isHitIndex(searchRecord.time.ToLongDateString(), keyword))
{
hitcount += 1;
Array.Resize(ref hit, hitcount);
hit[hitcount - 1] = (int)searchRecord.id;
continue;
}
}
// Keyword文字列が時分秒に含まれるか
if (keyword.Length < searchRecord.time.ToLongTimeString().Length)
{
if (isHitIndex(searchRecord.time.ToLongTimeString(), keyword))
{
hitcount += 1;
Array.Resize(ref hit, hitcount);
hit[hitcount - 1] = (int)searchRecord.id;
continue;
}
}
}
}
return(hit);
}
//
// Delete(Person p)
// 削除対象と同じIdを持っているPersonインスタンスを削除する
//
public void Delete(int _id)
{
using (var ctx = new fp7dataEntities1())
{
var deleteTarget = ctx.ex1table.Find(_id);
try
{
ctx.ex1table.Remove(deleteTarget);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
ctx.SaveChanges();
}
}
public void Edit(int _id, int[] _val)
{
using (var ctx = new fp7dataEntities1())
{
var editRecord = ctx.ex1table.Find(_id);
editRecord.val1 = (short)_val[0];
editRecord.val2 = (short)_val[1];
editRecord.val3 = (short)_val[2];
editRecord.val4 = (short)_val[3];
editRecord.val5 = (short)_val[4];
editRecord.val6 = (short)_val[5];
editRecord.val7 = (short)_val[6];
editRecord.val8 = (short)_val[7];
editRecord.time = DateTime.Now;
ctx.SaveChanges();
}
}
