public override List <DropListSource> DropList(DataTable dt, string filterExpression)
{
List <DropListSource> list = new List <DropListSource>();
foreach (DataRow dr in dt.Select(filterExpression))
{
DropListSource dropList = new DropListSource();
dropList.Value = DataConvert.ToString(dr["equityOwnerId"]);
dropList.Text = DataConvert.ToString(dr["equityOwnerName"]);
list.Add(dropList);
}
return(list);
}
public List <DropListSource> DropList()
{
string sql = @"select purchaseTypeId,purchaseTypeName from PurchaseType order by purchaseTypeName ";
DataTable dt = AppMember.DbHelper.GetDataSet(sql).Tables[0];
List <DropListSource> list = new List <DropListSource>();
foreach (DataRow dr in dt.Rows)
{
DropListSource dropList = new DropListSource();
dropList.Value = DataConvert.ToString(dr["purchaseTypeId"]);
dropList.Text = DataConvert.ToString(dr["purchaseTypeName"]);
list.Add(dropList);
}
return(list);
}
public List <DropListSource> DropList()
{
string sql = @"select barcodeStyleId,barcodeStyleName from BarcodeStyle order by isDefaultStyle, barcodeStyleName ";
DataTable dt = AppMember.DbHelper.GetDataSet(sql).Tables[0];
List <DropListSource> list = new List <DropListSource>();
foreach (DataRow dr in dt.Rows)
{
DropListSource dropList = new DropListSource();
dropList.Value = DataConvert.ToString(dr["barcodeStyleId"]);
dropList.Text = DataConvert.ToString(dr["barcodeStyleName"]);
list.Add(dropList);
}
return(list);
}
public List <DropListSource> DropList()
{
string sql = @"select groupId,groupNo,groupName from AppGroup order by groupNo ";
DataTable dt = AppMember.DbHelper.GetDataSet(sql).Tables[0];
List <DropListSource> list = new List <DropListSource>();
foreach (DataRow dr in dt.Rows)
{
DropListSource dropList = new DropListSource();
dropList.Value = DataConvert.ToString(dr["groupId"]);
dropList.Text = DataConvert.ToString(dr["groupName"]);
list.Add(dropList);
}
return(list);
}
public List <DropListSource> DropList()
{
string sql = @"select fiscalPeriodId,fiscalPeriodName,fiscalYearId from FiscalPeriod order by fiscalPeriodName ";
DataTable dt = AppMember.DbHelper.GetDataSet(sql).Tables[0];
List <DropListSource> list = new List <DropListSource>();
foreach (DataRow dr in dt.Rows)
{
DropListSource dropList = new DropListSource();
dropList.Value = DataConvert.ToString(dr["fiscalPeriodId"]);
dropList.Text = DataConvert.ToString(dr["fiscalPeriodName"]);
dropList.Filter = DataConvert.ToString(dr["fiscalYearId"]);
list.Add(dropList);
}
return(list);
}
public List <DropListSource> DropList()
{
string sql = @"select accountSubjectId,accountSubjectName,parentId from AccountSubject order by accountSubjectName ";
DataTable dt = AppMember.DbHelper.GetDataSet(sql).Tables[0];
List <DropListSource> list = new List <DropListSource>();
foreach (DataRow dr in dt.Rows)
{
DropListSource dropList = new DropListSource();
dropList.Value = DataConvert.ToString(dr["accountSubjectId"]);
dropList.Text = DataConvert.ToString(dr["accountSubjectName"]);
dropList.Filter = DataConvert.ToString(dr["parentId"]);
list.Add(dropList);
}
return(list);
}
public List <DropListSource> DropList()
{
string sql = @"select unitId,unitName,unitType from Unit order by unitName ";
DataTable dt = AppMember.DbHelper.GetDataSet(sql).Tables[0];
List <DropListSource> list = new List <DropListSource>();
foreach (DataRow dr in dt.Rows)
{
DropListSource dropList = new DropListSource();
dropList.Value = DataConvert.ToString(dr["unitId"]);
dropList.Text = DataConvert.ToString(dr["unitName"]);
dropList.Filter = DataConvert.ToString(dr["unitType"]);
list.Add(dropList);
}
return(list);
}
