/// <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;
//}
/// <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(string KIND)
{
DataTable result = new DataTable();
try
{
var db = new TestDropDownListDB();
//result = db.Load(KIND: KIND);
}
catch (Exception ex)
{
var dbExpLog = new ExpLogDB();
dbExpLog.Insert(new ExpLogInfo {
ClassName = "TestBiz.Master", MethodName = "Load", ErrMsg = ex.Message
});
}
return(result);
}
private void BindddlITEM()
{
string KIND = ddlKIND.Text;
#region 存取資料庫執行SQL
TestDropDownListDB db = new TestDropDownListDB();
DataTable dt = db.ITEM_Load(KIND: KIND);
#endregion
#region 讓欄位說明呈現
DataRow ndr = dt.NewRow();
ndr["ITEM"] = "品項";
dt.Rows.InsertAt(ndr, 0);
#endregion
#region 繫結欄位
ddlITEM.DataSource = dt;
ddlITEM.DataTextField = "ITEM";
ddlITEM.DataValueField = "ITEM";
ddlITEM.DataBind();
#endregion
}
private void BindddlKIND()
{
//string KIND = ddlKIND.Text;
#region 存取資料庫執行SQL
TestDropDownListDB db = new TestDropDownListDB();
DataTable dt = db.KIND_Load();
#endregion
#region 讓欄位說明呈現
DataRow ndr = dt.NewRow();
ndr["KIND"] = "種類";
dt.Rows.InsertAt(ndr, 0);
#endregion
#region 繫結欄位
ddlKIND.DataSource = dt;
ddlKIND.DataTextField = "KIND";
ddlKIND.DataValueField = "KIND";
ddlKIND.DataBind();
#endregion
}
