public void LoadCtls()
{
string strSQL = "SELECT * FROM LK_BoardType WHERE BoardCategory = 1 ORDER BY iValue";
IDBManager dbManager = new DBManager(DataProvider.SqlServer);
dbManager.ConnectionString = ConfigurationManager.ConnectionStrings["myConn"].ConnectionString;
DataSet dsItems = new DataSet();
try
{
dbManager.Open();
dsItems = dbManager.ExecuteDataSet(CommandType.Text, strSQL);
cboBoardType.Items.Clear();
cboBoardType.DataSource = dsItems;
cboBoardType.DataMember = dsItems.Tables[0].ToString();
cboBoardType.DataTextField = "BoardType";
cboBoardType.DataValueField = "iValue";
cboBoardType.DataBind();
cboBoardType.Items.Add("Pick one");
cboBoardType.ClearSelection();
cboBoardType.SelectedIndex = cboBoardType.Items.Count - 1;
}
catch (Exception ex)
{
ErrorLog.ErrorRoutine(false, "AddAlert:LoadCtls:Error:" + ex.Message);
}
finally
{
dbManager.Close();
dbManager.Dispose();
}
}
public void BindEnumToDDL(System.Web.UI.WebControls.DropDownList ddl, Enum e)
{
FieldInfo[] fs = e.GetType().GetFields();
DataTable dt = new DataTable();
DataColumn dc = new DataColumn("Text");
dt.Columns.Add(dc);
dc = new DataColumn("Value");
dt.Columns.Add(dc);
DataRow dr;
foreach (FieldInfo f in fs)
{
dr = dt.NewRow();
dr[0] = f.Name;
if (f.IsPublic)
{
dr[1] = (e.GetType().InvokeMember(f.Name, BindingFlags.GetField, null, null, null)).ToString();
}
dt.Rows.Add(dr);
}
ddl.DataSource = dt;
ddl.DataValueField = "Value";
ddl.DataTextField = "Text";
ddl.DataBind();
ddl.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--请选择--", "0"));
}
public static void BindProperty(System.Web.UI.WebControls.DropDownList ddl, DataTable dt)
{
ddl.DataSource = dt;
ddl.DataTextField = "Text";
ddl.DataValueField = "Value";
ddl.DataBind();
}
public static object DropDownFillCity(System.Web.UI.WebControls.DropDownList Dropdown, string stateid)
{
OracleConnection connection = new OracleConnection();
String query;
String DISTINCT = "";
query = "Select var_city_name,num_city_id from AOUP_LCOPRE_CITY_DEF where num_city_stateid = " + stateid + " order by var_city_name";
connection = new OracleConnection(ConfigurationSettings.AppSettings["ConString"].ToString().Trim());
connection.Open();
OracleCommand cmd = new OracleCommand(query, connection);
OracleDataReader dr = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Columns.Add("var_city_name", typeof(String));
dt.Columns.Add("num_city_id", typeof(String));
dt.Rows.Add("-- Select City --", 0);
while (dr.Read())
{
dt.Rows.Add(dr[0].ToString(), dr[1].ToString());
}
Dropdown.DataSource = dt;
Dropdown.DataTextField = dt.Columns[0].ToString();
Dropdown.DataValueField = dt.Columns[1].ToString();
Dropdown.DataBind();
connection.Close();
return(Dropdown);
}
public static void BindToDropDownFromDescriptions(ref System.Web.UI.WebControls.DropDownList ddl, Type enumType, ListItemSortType sortType)
{
ddl.DataSource = GetItemListByDescription(enumType, sortType);
ddl.DataTextField = "key";
ddl.DataValueField = "value";
ddl.DataBind();
}
/// <summary>
/// Bind ListDictionaryStringString to DropDownList the val is the first column and txt is second
/// </summary>
/// <param name="ddl"></param>
/// <param name="ldss"></param>
/// <param name="dataTextField"></param>
/// <param name="dataValueField"></param>
public static void DropDownListBindData(System.Web.UI.WebControls.DropDownList ddl, List <Dictionary <string, string> > ldss, string dataTextField = "txt", string dataValueField = "val")
{
try
{
ddl.DataTextField = dataTextField;
ddl.DataValueField = dataValueField;
System.Data.DataTable dt = new System.Data.DataTable();
dt.Columns.Add(dataValueField);
dt.Columns.Add(dataTextField);
ldss.Select(delegate(Dictionary <String, String> _dss)
{
try
{
System.Data.DataRow dr = dt.NewRow();
// dr.ItemArray = _dss.Select((KeyValuePair<string, string> x, int i) => { return x.Value; }).ToArray();
dr.ItemArray = new object[] { _dss[dataValueField], _dss[dataTextField] };
dt.Rows.Add(dr);
}
catch (Exception exa) { }
return(_dss);
}).ToArray();
ddl.DataSource = dt;
ddl.DataBind();
}
catch (Exception ex)
{
ddl.SelectedValue = ddl.Items[0].Value;
}
}
public void BindAllReturnInstitutions(System.Web.UI.WebControls.DropDownList ddplist, int ritypeid)
{
DataTable dataTable = new DataTable();
if (ritypeid > 0)
{
List <QueryStore> result = new List <QueryStore>();
string sqlQuery = String.Format("SELECT a.ri_id, a.fullname FROM t_core_reporting_institution a JOIN t_core_ri_mapping b ON a.ri_id = b.ri_id JOIN t_core_ri_type c ON b.ri_type_id = c.ri_type_id WHERE c.ri_type_id = @ritypeid");
using (SqlCommand command = new SqlCommand(sqlQuery, DatabaseOps.OpenSqlConnection()))
{
command.CommandType = CommandType.Text;
command.Parameters.AddWithValue("@ritypeid", ritypeid);
SqlDataAdapter adapter = new SqlDataAdapter(command);
adapter.Fill(dataTable);
ddplist.DataSource = dataTable;
ddplist.DataValueField = "ri_id";
ddplist.DataTextField = "fullname";
ddplist.DataBind();
ddplist.Items.Insert(0, "-Select Institution-");
}
}
}
/// <summary>
/// 绑定菜单下拉列表——显示所有的数据
/// </summary>
public void BandDropDownListShowUnit(Page page, System.Web.UI.WebControls.DropDownList ddl)
{
//在内存中筛选记录
var dt = DataTableHelper.GetFilterData(GetDataTable(), "1", "1", PROD_UNITTable.Id, " asc");
try
{
//显示值
ddl.DataTextField = PROD_UNITTable.UNIT_NAME;
//显示key
ddl.DataValueField = PROD_UNITTable.UNIT_ID;
//数据层次
//绑定数据源
ddl.DataSource = dt;
ddl.DataBind();
//ddl.SelectedIndex = 0;
//ddl.Items.Insert(0, new FineUI.ListItem("请选择大类", ""));
//ddl.SelectedValue = "";
}
catch (Exception e)
{
// 记录日志
CommonBll.WriteLog("", e);
}
}
/// <summary>
/// 绑定菜单下拉列表——显示所有的数据
/// </summary>
public void BandDropDownListShowProductName_1(Page page, System.Web.UI.WebControls.DropDownList ddl)
{
//在内存中筛选记录
var dt = DataTableHelper.GetFilterData(GetDataTable(), "1", "1", PRODUCT00Table.Id, "");
try
{
//显示值
// ddl.DataTextField = PRODUCT00Table.PROD_NAME1;
//显示key
// ddl.DataValueField = PRODUCT00Table.PROD_ID;
//数据层次
//绑定数据源
//绑定数据源
//ddl.DataSource = dt;
//ddl.DataBind();
ddl.DataTextField = PRODUCT00Table.PROD_NAME1;
ddl.DataValueField = PRODUCT00Table.PROD_ID;
ddl.DataSource = dt;
ddl.DataBind();
//ddl.Items.Insert(0, new FineUI.ListItem("请选择", "0"));
//ddl.SelectedValue = "0";
}
catch (Exception e)
{
// 记录日志
CommonBll.WriteLog("", e);
}
}
public static void ddlNationLoad(System.Web.UI.WebControls.DropDownList ddl)
{
ddl.DataSource = Db.ExecuteQuery("SELECT nationId,commonName FROM nation ORDER BY nationId", out bool boolDbError, out string strDbError);
ddl.DataTextField = "commonName";
ddl.DataValueField = "nationId";
ddl.DataBind();
}
public override System.Web.UI.Control RenderControl(DataEditorSetting sender)
{
ddl.ID = sender.GetName();
ddl.Items.Clear();
List <KeyValuePair <String, String> > items = new List <KeyValuePair <String, String> >();
string[] preValuesSource = { "@createDate", "@creatorName", "@level", "@nodeType", "@nodeTypeAlias", "@pageID", "@pageName", "@parentID", "@path", "@template", "@updateDate", "@writerID", "@writerName" };
string fieldSql = "select distinct alias from cmsPropertyType order by alias";
IRecordsReader dataTypes = umbraco.BusinessLogic.Application.SqlHelper.ExecuteReader(fieldSql);
ddl.DataTextField = "alias";
ddl.DataValueField = "alias";
ddl.DataSource = dataTypes;
ddl.DataBind();
foreach (string s in preValuesSource)
{
ddl.Items.Add(new System.Web.UI.WebControls.ListItem(s, s.Replace("@", "")));
}
System.Web.UI.WebControls.ListItem li = new System.Web.UI.WebControls.ListItem("Choose...", "");
li.Selected = true;
ddl.Items.Insert(0, li);
ddl.SelectedValue = _val;
return(ddl);
}
private void BindData(DbObject dbobj)
{
DataSet dsobj = new DataSet();
SqlParameter[] parameters2 =
{
new SqlParameter("@OrgId", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Default, OrgId),
};
dsobj = dbobj.dsRunProcedure("sp_SelectEquipAltLists", parameters2, "Lists");
ddStatusId.DataSource = dsobj;
ddStatusId.DataMember = "Lists";
ddStatusId.DataValueField = "id";
ddStatusId.DataTextField = "vchName";
ddStatusId.DataBind();
ddPMScheduleId.DataSource = dsobj;
ddPMScheduleId.DataMember = "Lists1";
ddPMScheduleId.DataValueField = "id";
ddPMScheduleId.DataTextField = "vchName";
ddPMScheduleId.DataBind();
ddPMScheduleId.Items.Insert(0, "");
ddInspectionId.DataSource = dsobj;
ddInspectionId.DataMember = "Lists2";
ddInspectionId.DataValueField = "id";
ddInspectionId.DataTextField = "vchName";
ddInspectionId.DataBind();
ddInspectionId.Items.Insert(0, "");
}
/// <summary>
/// 下拉列表绑定数据
/// </summary>
/// <param name="dropDownList">下列表框</param>
/// <param name="dt">数据源</param>
/// <param name="dataTextField"></param>
/// <param name="dataValueField"></param>
public static void SetDropDownListDataBind(this System.Web.UI.WebControls.DropDownList dropDownList, DataTable dt, string dataTextField, string dataValueField)
{
if (null == dropDownList)
{
return;
}
if (null == dt)
{
return;
}
if (true == dataTextField.AsNullOrWhiteSpace())
{
return;
}
if (true == dataValueField.AsNullOrWhiteSpace())
{
return;
}
if (0 == dt.Rows.Count)
{
return;
}
dropDownList.DataSource = dt;
dropDownList.DataTextField = dataTextField;
dropDownList.DataValueField = dataValueField;
dropDownList.DataBind();
}
/// <summary>
/// 绑定菜单下拉列表——显示所有的数据
/// </summary>
public void BandDropDownListShowKind(Page page, System.Web.UI.WebControls.DropDownList ddl)
{
//在内存中筛选记录
System.Collections.Generic.List <Solution.DataAccess.DbHelper.ConditionFun.SqlqueryCondition> conditionList = new System.Collections.Generic.List <Solution.DataAccess.DbHelper.ConditionFun.SqlqueryCondition>();
conditionList.Add(new Solution.DataAccess.DbHelper.ConditionFun.SqlqueryCondition(SubSonic.Query.ConstraintType.Where, "1", SubSonic.Query.Comparison.Equals, "1", false, false));
var dt = DataTableHelper.GetFilterData(GetDataTable(false, 0, null, 0, 0, conditionList, null), "1", "1", PROD_KINDTable.Id, " asc");
try
{
//显示值
ddl.DataTextField = PROD_KINDTable.KIND_NAME;
//显示key
ddl.DataValueField = PROD_KINDTable.KIND_ID;
//数据层次
//绑定数据源
ddl.DataSource = dt;
ddl.DataBind();
//ddl.SelectedIndex = 0;
//ddl.Items.Insert(0, new FineUI.ListItem("请选择大类", ""));
//ddl.SelectedValue = "";
}
catch (Exception e)
{
// 记录日志
CommonBll.WriteLog("", e);
}
}
public static void LlenarCombo <T>(System.Web.UI.WebControls.DropDownList dropDownList, List <T> lista, string DataTextField, string DataValueField)
{
dropDownList.Items.Clear();
dropDownList.DataSource = lista;
dropDownList.DataTextField = DataTextField;
dropDownList.DataValueField = DataValueField;
dropDownList.DataBind();
}
public static void CargarComboUsuario(System.Web.UI.WebControls.DropDownList ddl, string columnasConcatenar, string columna, string id, string tabla)
{
ddl.DataSource = AccesoLogica.Select(columnasConcatenar, tabla);
ddl.DataTextField = columna;
ddl.DataValueField = id;
ddl.DataBind();
ddl.Items.Insert(0, "---");
}
public static void DDLBind(string sql, System.Web.UI.WebControls.DropDownList D1, string VField, string TField)
{
D1.DataSource = AccessDB.GetDataSet(sql).Tables[0].DefaultView;
D1.DataTextField = TField;
D1.DataValueField = VField;
D1.DataBind();
D1.Items.Insert(0, "");
}
public static void FillDropDownList(System.Web.UI.WebControls.DropDownList ddl, System.Data.DataSet ds, string valueField, string textField)
{
ddl.Items.Clear();
ddl.DataTextField = textField;
ddl.DataValueField = valueField;
ddl.DataSource = ds;
ddl.DataBind();
}
public void ListaTiposFiltroCartasSHF(ref System.Web.UI.WebControls.DropDownList oddlF, bool IncluirValorInicial = true)
{
DLSoftware DataLayerSoftware = new DLSoftware();
oddlF.DataSource = DataLayerSoftware.ListaTiposFiltroMaxI(IncluirValorInicial);
oddlF.DataValueField = "Valor";
oddlF.DataTextField = "Descripcion";
oddlF.DataBind();
}
/// <summary>
/// 根据特定条件,下拉框数据加载
/// </summary>
/// <param name="DDL_Items">下拉框</param>
/// <param name="tablename">表名</param>
/// <param name="mtext">名称字段</param>
/// <param name="mvalue">编号字段</param>
/// <param name="RowName">条件字段名</param>
/// <param name="oValue">条件字段值</param>
public static void LoadSelection(ref System.Web.UI.WebControls.DropDownList DDL_Items, string tablename, string mtext, string mvalue, string RowName, string oValue)
{
DDL_Items.DataSource = GetSelections(tablename, RowName, oValue);
DDL_Items.Items.Clear();
DDL_Items.DataTextField = mtext;
DDL_Items.DataValueField = mvalue;
DDL_Items.DataBind();
}
/// <summary>
/// 根据特定条件,下拉框数据加载
/// </summary>
/// <param name="DDL_Items">下拉框</param>
/// <param name="tablename">表名</param>
/// <param name="mtext">名称字段</param>
/// <param name="mvalue">编号字段</param>
/// <param name="RowName">条件字段名</param>
/// <param name="oValue">条件字段值</param>
public static void LoadSelectionBySql(ref System.Web.UI.WebControls.DropDownList DDL_Items, string sql, string mtext, string mvalue)
{
DDL_Items.DataSource = CSql.CreateDataSet(sql);
DDL_Items.Items.Clear();
DDL_Items.DataTextField = mtext;
DDL_Items.DataValueField = mvalue;
DDL_Items.DataBind();
}
/// <summary>
/// 绑定币别
/// </summary>
private void DataBindCurrency()
{
DataSet dsBaseCurrency = PurchaseOrderHelper.GetBaseCurrency();
ddlCurrency.DataTextField = "Name_CN";
ddlCurrency.DataValueField = "ID";
ddlCurrency.DataSource = dsBaseCurrency;
ddlCurrency.DataBind();
}
/// <summary>
/// 获得数据列表
/// </summary>
//public DataSet GetList(int PageSize,int PageIndex,string strWhere)
//{
//return dal.GetList(PageSize,PageIndex,strWhere);
//}
public void LogTypeBind(System.Web.UI.WebControls.DropDownList ddlControl)
{
string str = "select Distinct LOGTYPE from SYS_OperateLog";
ddlControl.DataSource = DbHelperSQL.DQuery(str);
ddlControl.DataTextField = "LOGTYPE";
ddlControl.DataValueField = "LOGTYPE";
ddlControl.DataBind();
ddlControl.Items.Insert(0, new System.Web.UI.WebControls.ListItem("请选择操作类型", ""));
}
/// <summary>
/// 根据特定条件,下拉框数据加载
/// </summary>
/// <param name="DDL_Items">下拉框</param>
/// <param name="tablename">表名</param>
/// <param name="mtext">名称字段</param>
/// <param name="mvalue">编号字段</param>
/// <param name="ConStr">条件字段</param>
public static void LoadSelection(ref System.Web.UI.WebControls.DropDownList DDL_Items, string tablename, string mtext, string mvalue, string ConStr)
{
string sqlTxt = "SELECT * FROM " + tablename + " where " + ConStr;
DDL_Items.DataSource = CSql.CreateDataSet(sqlTxt);
DDL_Items.Items.Clear();
DDL_Items.DataTextField = mtext;
DDL_Items.DataValueField = mvalue;
DDL_Items.DataBind();
}
//绑定外包医院下拉框
private void BindDropSendCustomer(System.Web.UI.WebControls.DropDownList ddlcustomer)
{
if (ViewState["SendCustomer"] == null)
{
ViewState["SendCustomer"] = dictCustomerService.GetDictCustomerListByType("1").Where <Dictcustomer>(c => c.Dictlabid == Convert.ToDouble(DropDictLab.SelectedValue)).ToList <Dictcustomer>();
}
ddlcustomer.DataTextField = "Customername";
ddlcustomer.DataValueField = "Dictcustomerid";
ddlcustomer.DataSource = ViewState["SendCustomer"] as IList <Dictcustomer>;
ddlcustomer.DataBind();
ddlcustomer.Items.Insert(0, new System.Web.UI.WebControls.ListItem("请选择", "-1"));
}
private void BindData(DbObject dbobj)
{
DataSet dsobj = new DataSet();
SqlParameter[] parameters2 =
{
new SqlParameter("@OrgId", SqlDbType.Int)
};
parameters2[0].Value = OrgId;
dsobj = dbobj.dsRunProcedure("sp_SelectEquipTypesMakesModels", parameters2, "Types");
dsobj.Relations.Add(new DataRelation("Types_Makes", dsobj.Tables["Types"].Columns["Id"], dsobj.Tables["Types1"].Columns["TypeId"]));
dsobj.Relations.Add(new DataRelation("Makes_Models", dsobj.Tables["Types1"].Columns["Id"], dsobj.Tables["Types2"].Columns["MakeId"]));
ddTypeId.DataSource = dsobj;
ddTypeId.DataMember = "Types";
ddTypeId.DataValueField = "id";
ddTypeId.DataTextField = "vchName";
ddTypeId.DataBind();
ddTypeId.Items.Insert(0, "");
ddMakeId.DataSource = dsobj;
ddMakeId.DataMember = "Types1";
ddMakeId.DataValueField = "id";
ddMakeId.DataTextField = "vchMakeName";
ddMakeId.DataBind();
ddMakeId.Items.Insert(0, "");
ddModelId.DataSource = dsobj;
ddModelId.DataMember = "Types2";
ddModelId.DataValueField = "id";
ddModelId.DataTextField = "vchModelName";
ddModelId.DataBind();
ddModelId.Items.Insert(0, "");
ddDeptId.DataSource = dsobj;
ddDeptId.DataMember = "Types3";
ddDeptId.DataValueField = "id";
ddDeptId.DataTextField = "vchName";
ddDeptId.DataBind();
ddDeptId.Items.Insert(0, "");
ddLocationId.DataSource = dsobj;
ddLocationId.DataMember = "Types4";
ddLocationId.DataValueField = "id";
ddLocationId.DataTextField = "vchName";
ddLocationId.DataBind();
ddLocationId.Items.Insert(0, "");
ListLink1.DataBind();
ListLink2.DataBind();
}
public System.Web.UI.WebControls.DropDownList FillCombo(System.Web.UI.WebControls.DropDownList combo, string query, string textField, string valueField)
{
DataTable dt = new DataTable();
SqlDataAdapter adap = new SqlDataAdapter(query, GetConnectionForAdapter());
adap.Fill(dt);
combo.DataSource = dt;
combo.DataTextField = textField;
combo.DataValueField = valueField;
combo.DataBind();
return(combo);
}
public static void CargarCombo_inner(System.Web.UI.WebControls.DropDownList ddl, string id, string columna, string tabla_uno, string tabla_dos, string parametro)
{
try
{
ddl.DataSource = AccesoLogica.Select_inner_join(id + ", " + columna, tabla_uno, tabla_dos, parametro);
ddl.DataTextField = columna;
ddl.DataValueField = id;
ddl.DataBind();
ddl.Items.Insert(0, "---");
}
catch
{
}
}
protected void FillDDL(ref System.Web.UI.WebControls.DropDownList ddl, System.Data.SqlClient.SqlCommand sql, string textField, string valueField)
{
try
{
ddl.DataSource = getData(sql);
ddl.DataTextField = textField;
ddl.DataValueField = valueField;
ddl.DataBind();
}
catch (System.Exception ex)
{
conCloseNo();
}
}
public static void DropDownListBindData(System.Web.UI.WebControls.DropDownList ddl, System.Data.DataTable dt, string dataTextField = "txt", string dataValueField = "val")
{
try
{
ddl.DataTextField = dataTextField;
ddl.DataValueField = dataValueField;
ddl.DataSource = dt;
ddl.DataBind();
}
catch (Exception ex)
{
ddl.SelectedValue = ddl.Items[0].Value;
}
}
