/// <summary>
/// 修改資料
/// </summary>
/// <param name="e"></param>
public void Update(ExpLogInfo e)
{
Database db = base.GetDatabase();
StringBuilder sbCmd = new StringBuilder();
sbCmd.Append(" UPDATE [ExpLog] SET ");
sbCmd.Append(" ClassName = @ClassName ");
sbCmd.Append(" ,MethodName = @MethodName ");
sbCmd.Append(" ,ErrMsg = @ErrMsg ");
sbCmd.Append(" ,UDate = @UDate ");
sbCmd.Append(" WHERE SID = @SID ");
DbCommand dbCommand = db.GetSqlStringCommand(sbCmd.ToString());
#region Add In Parameter
db.AddInParameter(dbCommand, "@SID", DbType.Int32, e.SID);
db.AddInParameter(dbCommand, "@ClassName", DbType.String, e.ClassName);
db.AddInParameter(dbCommand, "@MethodName", DbType.String, e.MethodName);
db.AddInParameter(dbCommand, "@ErrMsg", DbType.String, e.ErrMsg);
db.AddInParameter(dbCommand, "@UDate", DbType.DateTime, e.UDate);
#endregion
try
{
db.ExecuteNonQuery(dbCommand);
base.ErrFlag = true;
}
catch (Exception ex)
{
throw; //將原來的 exception 再次的抛出去
}
}
/// <summary>
/// 讀
/// </summary>
/// <param name="iSID"></param>
/// <returns></returns>
public ExpLogInfo Load(int iSID)
{
ExpLogInfo Result = new ExpLogInfo();
Database db = base.GetDatabase();
StringBuilder sbCmd = new StringBuilder();
sbCmd.Append(" SELECT * FROM [ExpLog] WITH (Nolock) ");
sbCmd.Append(" WHERE (1=1) ");
sbCmd.Append(" AND SID = @SID ");
DbCommand dbCommand = db.GetSqlStringCommand(sbCmd.ToString());
#region Add In Parameter
db.AddInParameter(dbCommand, "@SID", DbType.Int32, iSID);
#endregion
try
{
base.ErrFlag = true;
DataTable dtTemp = db.ExecuteDataSet(dbCommand).Tables[0];
if (dtTemp != null && dtTemp.Rows.Count > 0)
{
DataRow dr = dtTemp.Rows[0];
Result.SID = Convert.ToInt32(dr["SID"]);
Result.ClassName = Convert.ToString(dr["ClassName"]);
Result.MethodName = Convert.ToString(dr["MethodName"]);
Result.ErrMsg = Convert.ToString(dr["ErrMsg"]);
Result.UDate = dr["UDate"] == DBNull.Value ? new Nullable <DateTime>() : Convert.ToDateTime(dr["UDate"]);
}
else
{
Result = null;
}
//if (dtTemp.Rows.Count == 0)
//{
// base.EditMode = EditType.Insert;
// //Result = false;
//}
//else
//{
// base.EditMode = EditType.Update;
// //Result = true;
//}
}
catch (Exception ex)
{
Result = null;
throw; //將原來的 exception 再次的抛出去
}
return(Result);
}
public bool Insert(ExpLogInfo entity)
{
var result = true;
try{
var db = new ExpLogDB();
db.Insert(entity);
}
catch
{
result = false;
}
return(result);
}
/// <summary>
/// 以SID取一筆資料
/// </summary>
/// <param name="SID"></param>
/// <returns></returns>
public ExpLogInfo Load(int SID)
{
ExpLogInfo result = new ExpLogInfo();
try
{
var db = new ExpLogDB();
result = db.Load(SID);
}
catch
{
result = null;
}
return(result);
}
public ExpLogInfo Load(DateTime UDate)
{
ExpLogInfo Result = new ExpLogInfo();
Database db = base.GetDatabase();
StringBuilder sbCmd = new StringBuilder();
sbCmd.Append(" SELECT * FROM [ExpLog] WITH (Nolock) ");
sbCmd.Append(" WHERE cast(UDate as date)=@UDate ");
DbCommand dbCommand = db.GetSqlStringCommand(sbCmd.ToString());
#region Add In Parameter
db.AddInParameter(dbCommand, "@Udate", DbType.Date, UDate.Date);
#endregion
try
{
base.ErrFlag = true;
DataTable dtTemp = db.ExecuteDataSet(dbCommand).Tables[0];
if (dtTemp != null && dtTemp.Rows.Count > 0)
{
DataRow dr = dtTemp.Rows[0];
Result.SID = Convert.ToInt32(dr["SID"]);
Result.ClassName = Convert.ToString(dr["ClassName"]);
Result.MethodName = Convert.ToString(dr["MethodName"]);
Result.ErrMsg = Convert.ToString(dr["ErrMsg"]);
Result.UDate = dr["UDate"] == DBNull.Value ? new Nullable <DateTime>() : Convert.ToDateTime(dr["UDate"]);
}
else
{
Result = null;
}
}
catch (Exception ex)
{
Result = null;
throw; //將原來的 exception 再次的抛出去
}
return(Result);
}
