/// <summary> /// 绑定项目下拉列表框 /// </summary> /// <param name="enterprise"></param> public void GetProjectList(string enterprise) { //绑定项目下拉列表框 var query = DbHelperSql.Query("select DISTINCT ProjectName from Project where EnterpriseName like '" + enterprise + "'"); DropDownListXM.DataSource = query; DropDownListXM.DataTextField = "ProjectName"; DropDownListXM.DataValueField = "ProjectName"; DropDownListXM.DataBind(); }
/// <summary> /// 页面加载 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { return; } var query = DbHelperSql.Query("select DISTINCT ProjectName from Employee"); DropDownListXM.DataSource = query; DropDownListXM.DataValueField = "ProjectName"; DropDownListXM.DataTextField = "ProjectName"; DropDownListXM.DataBind(); A(""); B(""); }
/// <summary> /// 页面加载 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { return; } if (ActionValidator("FinancialAdd")) { var query = DbHelperSql.Query("select DISTINCT EnterpriseName from Eenterprises where Audit='已通过'"); DropDownList_qy.DataSource = query; DropDownList_qy.DataTextField = "EnterpriseName"; DropDownList_qy.DataValueField = "EnterpriseName"; DropDownList_qy.DataBind(); var entity = DbHelperSql.Query("select DISTINCT ProjectName from Project "); DropDownListXM.DataSource = entity; DropDownListXM.DataTextField = "ProjectName"; DropDownListXM.DataValueField = "ProjectName"; DropDownListXM.DataBind(); if (!string.IsNullOrEmpty(Request.QueryString["FID"])) { var data = DbHelperSql.Query("select * from Financial where FID='" + Request.QueryString["FID"] + "'"); txtTrueMoney.Text = data.Tables[0].Rows[0]["PayMoney"].ToString(); FZperson.Text = data.Tables[0].Rows[0]["Person"].ToString(); DropDownList2.SelectedValue = data.Tables[0].Rows[0]["IsPay"].ToString(); time.Text = data.Tables[0].Rows[0]["SuccessfulTime"].ToString(); note.Text = data.Tables[0].Rows[0]["Note"].ToString(); //项目 DropDownListXM.SelectedValue = data.Tables[0].Rows[0]["ProjectName"].ToString(); //企业 DropDownList_qy.SelectedValue = data.Tables[0].Rows[0]["EnterpriseName"].ToString(); } } else { AlertAndParentSkip("没有权限", "FinancialList"); } }