public DataTable Load(ref PaginationInfo pagination, TestMasterInfo.Conditions conditions)
{
DataTable result = new DataTable();
try
{
var db = new TestMasterDB();
result = db.Load(ref pagination, conditions);
}
catch (Exception ex)
{
var dbExpLog = new ExpLogDB();
dbExpLog.Insert(new ExpLogInfo {
ClassName = "TestBiz.Master", MethodName = "Load", ErrMsg = ex.Message
});
}
return(result);
}
/// <summary>
/// 取一筆資料
/// </summary>
/// <param name="SID"></param>
/// <param name="ID"></param>
/// <param name="NO"></param>
/// <returns></returns>
public TestMasterInfo Load(int?SID = null, string ID = null, string NO = null)
{
TestMasterInfo result = null;
try
{
var db = new TestMasterDB();
result = db.Load(SID, ID, NO);
}
catch (Exception ex)
{
var dbExpLog = new ExpLogDB();
dbExpLog.Insert(new ExpLogInfo {
ClassName = "TestBiz.Master", MethodName = "Load", ErrMsg = ex.Message
});
}
return(result);
}
public DataTable Load(ref PageInationInfo pagination, TestMasterInfo.Condtions Condtions)
{
DataTable result = new DataTable();
try
{
var db = new TestMasterDB();
result = db.Load(ref pagination, Condtions.SID, ID: Condtions.ID, NO: Condtions.NO, Name: Condtions.Name, Phone: Condtions.Phone
, Address: Condtions.Address,
BirthdayFrom: Condtions.BirthdayFrom, BirthdayTo: Condtions.BirthdayTo, AgeFrom: Condtions.AgeFrom, AgeTo: Condtions.AgeTo);
}
catch (Exception ex)
{
var dbExpLog = new ExpLogDB();
dbExpLog.Insert(new ExpLogInfo {
ClassName = "TestBiz.Master", MethodName = "Load", ErrMsg = ex.Message
});
}
return(result);
}
/// <summary>
/// 依條件取多筆資料
/// </summary>
/// <param name="SID"></param>
/// <param name="ID"></param>
/// <param name="NO"></param>
/// <param name="Name"></param>
/// <param name="Phone"></param>
/// <param name="Address"></param>
/// <param name="BirthdayFrom"></param>
/// <param name="BirthdayTo"></param>
/// <param name="AgeFrom"></param>
/// <param name="AgeTo"></param>
/// <returns></returns>
public DataTable Load(ref PaginationInfo pagination, int?SID = null, string ID = null, string NO = null, string Name = null, string Phone = null,
string Address = null, DateTime?BirthdayFrom = null, DateTime?BirthdayTo = null,
decimal?AgeFrom = null, decimal?AgeTo = null)
{
DataTable result = new DataTable();
try
{
var db = new TestMasterDB();
result = db.Load(ref pagination, SID, ID: ID, NO: NO, Name: Name, Phone: Phone, Address: Address,
BirthdayFrom: BirthdayFrom, BirthdayTo: BirthdayTo, AgeFrom: AgeFrom, AgeTo: AgeTo);
}
catch (Exception ex)
{
var dbExpLog = new ExpLogDB();
dbExpLog.Insert(new ExpLogInfo {
ClassName = "TestBiz.Master", MethodName = "Load", ErrMsg = ex.Message
});
}
return(result);
}