/// <summary>
/// 更新函数
/// </summary>
/// <param name="info">Model</param>
/// <returns>影响数据物理ID，已存在逻辑主码返回-1</returns>
public long UPDATE(Log info)
{
try
{
if (SELECT_BY_EVID_MID_DATETIME(info.Tablename, info.Tableid, info.Mid, info.Datetime) == null)
{
return(-1);
}
S_log temp = new S_log();
Table <S_log> table = db.GetTable <S_log>();
temp = (from row in db.S_log where row.id == info.Id select row).First();
//temp.id = info.Id;
temp.tablename = info.Tablename;
temp.tableid = info.Tableid;
temp.mid = info.Mid;
temp.datetime = info.Datetime;
temp.discription = info.Discription;
db.SubmitChanges();
return(temp.id);
}
catch
{
return(-2);
}
}
/// <summary>
/// 插入函数
/// </summary>
/// <param name="info">Model</param>
/// <returns>影响数据物理ID</returns>
public long INSERT(Log info)
{
try
{
if (SELECT_BY_EVID_MID_DATETIME(info.Tablename, info.Tableid, info.Mid, info.Datetime) != null)
{
return(-1);
}
S_log temp = new S_log();
//temp.id = info.Id;
temp.tablename = info.Tablename;
temp.tableid = info.Tableid;
temp.mid = info.Mid;
temp.datetime = info.Datetime;
temp.discription = info.Discription;
Table <S_log> table = db.GetTable <S_log>();
table.InsertOnSubmit(temp);
db.SubmitChanges();
return(temp.id);
}
catch
{
return(-2);
}
}
/// <summary>
/// 根据逻辑主码查询
/// </summary>
/// <param name="tablename">被操作表名</param>
/// <param name="tableid">被操作表数据主码ID</param>
/// <param name="mid">操作人ID</param>
/// <param name="datetime">操作时间</param>
/// <returns>结果</returns>
public Log SELECT_BY_EVID_MID_DATETIME(string tablename, long tableid, int mid, DateTime datetime)
{
try
{
Log rd = new Log();
S_log temp = (from row in db.S_log where row.tablename == tablename && row.tableid == tableid && row.mid == mid && row.datetime == datetime select row).First();
rd.Id = temp.id;
rd.Tablename = temp.tablename;
rd.Tableid = temp.tableid;
rd.Mid = temp.mid;
rd.Datetime = temp.datetime;
rd.Discription = temp.discription;
return(rd);
}
catch
{
return(null);
}
}
/// <summary>
/// 根据物理主码查询
/// </summary>
/// <param name="id">id</param>
/// <returns>结果</returns>
public Log SELECT_BY_ID(long id)
{
try
{
Log rd = new Log();
S_log temp = (from row in db.S_log where row.id == id select row).First();
rd.Id = temp.id;
rd.Tablename = temp.tablename;
rd.Tableid = temp.tableid;
rd.Mid = temp.mid;
rd.Datetime = temp.datetime;
rd.Discription = temp.discription;
return(rd);
}
catch
{
return(null);
}
}
