static public void PopulateByCommonSetting(ComboBox cbo, string groupID, bool fblank = false)
{
var cs = new CommonSetting();
var dtb = cs.SelectAllByGroupID(groupID);
cbo.DataSource = null;
cbo.ValueMember = "DetailID";
cbo.DisplayMember = "DetailDesc";
if (fblank)
{
dtb.Rows.Add("", "");
}
dtb.DefaultView.Sort = "DetailID Asc";
cbo.DataSource = dtb;
//if (fblank)
//cbo.Items.Add(new ComboBoxItem("", ""));
//foreach (DataRow row in dtb.Rows)
//{
// cbo.Items.Add(new ComboBoxItem(row["DetailID"] + "", row["DetailDesc"] + ""));
//}
}
private void PopulateItemUnit()
{
var itemUnit = new CommonSetting();
var dtb = itemUnit.SelectAllByGroupID("StdItemUnit");
cboItemUnit.DisplayMember = "DetailDesc";
cboItemUnit.ValueMember = "DetailID";
cboItemUnit.DataSource = dtb;
}
private void PopulateGrid()
{
grdChooseTransactionStatus.SuspendLayout();
grdChooseTransactionStatus.AutoGenerateColumns = false;
var cs = new CommonSetting();
var dv = new DataView(cs.SelectAllByGroupID("STxnStatus"));
dv.RowFilter = "DetailID in ('S','V')";
grdChooseTransactionStatus.DataSource = dv;
grdChooseTransactionStatus.ResumeLayout();
}
static public string SelectOneByCommonSetting(string groupID)
{
var cs = new CommonSetting();
return(Common.ProcessNull.GetString(cs.SelectAllByGroupID(groupID).Rows[0]["DetailID"]) + "");
}