//绑定调入部门和调出部门 protected void bind_ddl() { string sqltext_dep = "select distinct DEP_NAME,DEP_CODE from TBDS_DEPINFO where DEP_CODE LIKE '[0-9][0-9]'"; DBCallCommon.FillDroplist(ddl_MOVE_OUTPART, sqltext_dep); DBCallCommon.FillDroplist(ddl_MOVE_INPART, sqltext_dep); }
protected void bind_ddl() { Encrypt_Decrypt ed = new Encrypt_Decrypt(); ContractNo = ed.DecryptText(Request.QueryString["ContractNo"].ToString()); lbl_con.Text = ContractNo; string sql_title = "select PCON_ENGNAME,PCON_ENGTYPE from TBPM_CONPCHSINFO where PCON_BCODE='" + ContractNo + "' "; System.Data.DataTable dt_title = DBCallCommon.GetDTUsingSqlText(sql_title); if (dt_title.Rows.Count > 0) { lbl_project.Text = dt_title.Rows[0][0].ToString().Trim(); lbl_engineer.Text = dt_title.Rows[0][1].ToString().Trim(); } //string type = (ViewState["type"].ToString() == "1" ? " and [YS_XS_Finished] ='1'" : " and YS_XS_Finished is null"); //string sqltext_people = "select distinct YS_ADDNAME,YS_ADDNAME from View_YS_COST_BUDGET_REAL where 1=1 " +type; //string sqltext_PJ = "SELECT DISTINCT PCON_PJNAME ,PCON_PJNAME FROM View_YS_COST_BUDGET_REAL where 1=1" +type; //string sqltext_ENG = "SELECT DISTINCT PCON_ENGNAME,PCON_ENGNAME FROM View_YS_COST_BUDGET_REAL where 1=1" +type; string sqltext_EQ = "SELECT PCON_EQNAME,PCON_EQNAME FROM View_YS_COST_BUDGET_REAL where 1=1 and YS_CONTRACT_NO='" + ContractNo + "' "; //DBCallCommon.FillDroplist(dpl_people, sqltext_people); //DBCallCommon.FillDroplist(ddl_project, sqltext_PJ); //DBCallCommon.FillDroplist(ddl_engineer, sqltext_ENG); DBCallCommon.FillDroplist(ddl_task, sqltext_EQ); }
protected void bind_ddl() { //string sqltext_people = "select distinct YS_ADDNAME,YS_ADDNAME from View_YS_CON_BUDGET_REAL where 1=1 " + type; string sqltext_PJ = "SELECT DISTINCT PCON_PJNAME ,PCON_PJNAME FROM View_YS_CON_BUDGET_REAL where 1=1 and YS_XS_Finished='0'"; string sqltext_ENG = "SELECT DISTINCT PCON_ENGNAME,PCON_ENGNAME FROM View_YS_CON_BUDGET_REAL where 1=1 and YS_XS_Finished='0'"; //DBCallCommon.FillDroplist(dpl_people, sqltext_people); DBCallCommon.FillDroplist(ddl_project, sqltext_PJ); DBCallCommon.FillDroplist(ddl_engineer, sqltext_ENG); }
protected void Page_Load(object sender, EventArgs e) { string sqltxt = ""; InitVar(); if (!IsPostBack) { ddlSearchchild.Visible = false; sqltxt = "select distinct CL_NAME,CL_CODE from TBCS_LOCINFO where CL_FATHERCODE='ROOT'"; DBCallCommon.FillDroplist(ddlSearch, sqltxt); selectaddgroupd.SelectedIndex = 0; bindGrid(); } CheckUser(ControlFinder); }
protected void GridViewSearch_DataBound(object sender, EventArgs e) { foreach (GridViewRow gr in GridViewSearch.Rows) { if (ddlType.SelectedValue == "03") { DropDownList ddl = (gr.FindControl("DropDownListName") as DropDownList); ddl.DataTextField = "value"; ddl.DataValueField = "key"; ddl.DataSource = bindThreeList(); ddl.DataBind(); } else { DropDownList ddl = (gr.FindControl("DropDownListName") as DropDownList); ddl.DataTextField = "value"; ddl.DataValueField = "key"; DropDownList ddlTypeValue = (gr.FindControl("ddlTypeValue") as DropDownList); if (ddlType.SelectedValue == "02") { ddl.DataSource = bindTwoList(); ddl.DataBind(); string sql = "select ty_name,TY_ID from TBMA_typeinfo where ty_fatherid !='ROOT'"; DBCallCommon.FillDroplist(ddlTypeValue, sql); } else { ddl.DataSource = bindOneList(); ddl.DataBind(); ddlTypeValue.Items.Add(new ListItem("-请选择-", "-请选择-")); ddlTypeValue.Items.Add(new ListItem("原材料", "01")); ddlTypeValue.Items.Add(new ListItem("低值易耗品", "02")); } } if (gr.RowIndex == 4) { (gr.FindControl("tb_logic") as System.Web.UI.WebControls.TextBox).Visible = false; } } }
protected void ddlSearch_SelectedIndexChanged(object sender, EventArgs e) { string ddlvalue = ""; if (ddlSearch.SelectedItem.Text.Trim() == "-请选择-") { ddlSearchchild.Visible = false; bindGrid(); } else { ddlSearchchild.Visible = true; ddlvalue = ddlSearch.SelectedItem.Value.ToString(); sqlText = "select distinct CL_NAME,CL_CODE from TBCS_LOCINFO where CL_FATHERCODE='" + ddlvalue + "' "; //Response.Write(ddlvalue); //Response.End(); DBCallCommon.FillDroplist(ddlSearchchild, sqlText); RebindGrid(); } }
protected void bind_ddl() { string sqltext_PJ = "SELECT DISTINCT PCON_PJNAME ,PCON_PJNAME FROM View_YS_COST_BUDGET_REAL where 1=1"; string sqltext_ENG = "SELECT DISTINCT PCON_ENGNAME,PCON_ENGNAME FROM View_YS_COST_BUDGET_REAL where 1=1"; DBCallCommon.FillDroplist(ddl_project, sqltext_PJ); DBCallCommon.FillDroplist(ddl_engineer, sqltext_ENG); string sql_updatetime = "select top 1 YS_UPDATE_TIME from YS_COST_BUDGET_ORDER order by YS_UPDATE_TIME desc"; System.Data.DataTable dt = DBCallCommon.GetDTUsingSqlText(sql_updatetime); if (dt.Rows.Count > 0) { if (dt.Rows[0][0].ToString() != "") { DateTime time = Convert.ToDateTime(dt.Rows[0][0].ToString()); lab_updatetime.Text = time.ToString("yyyy-MM-dd HH:mm"); } } else { lab_updatetime.Text = "未更新"; } }
protected void bind_ddl() { string type = (ViewState["type"].ToString() == "1" ? " and [YS_XS_Finished] ='1'" : " and YS_XS_Finished != '0'"); //string sqltext_people = "select distinct YS_ADDNAME,YS_ADDNAME from View_YS_CON_BUDGET_REAL where 1=1 " + type; string sqltext_PJ = "SELECT DISTINCT PCON_PJNAME ,PCON_PJNAME FROM View_YS_CON_BUDGET_REAL where 1=1" + type; string sqltext_ENG = "SELECT DISTINCT PCON_ENGNAME,PCON_ENGNAME FROM View_YS_CON_BUDGET_REAL where 1=1" + type; if (ViewState["type"].ToString() == "1") { //btnModify.Visible = false; //btnShowSta.Visible = false; LabelTitle.Text = "合同预算分析"; } else { //btnModify.Visible = true; //btnShowSta.Visible = false; LabelTitle.Text = "合同预算监控"; } //DBCallCommon.FillDroplist(dpl_people, sqltext_people); DBCallCommon.FillDroplist(ddl_project, sqltext_PJ); DBCallCommon.FillDroplist(ddl_engineer, sqltext_ENG); }
//protected string check_ddl_YS() //{ // Encrypt_Decrypt ed = new Encrypt_Decrypt(); // string ContractNo = ed.DecryptText(Request.QueryString["ContractNo"].ToString()); // string Mar_code = Request.QueryString["Marcode"].ToString(); // string str_ys_name = ""; // if (Mar_code=="01.07") // { // if (ddl_YS_name.SelectedItem.Text.ToString()=="定尺板") // { // if (DropDownList_mar_type.SelectedItem.Text.ToString()!="定尺板") // { // str_ys_name = " and PO_MASHAPE='定尺板'"; // } // } // else // if (ddl_YS_name.SelectedItem.Text.ToString() == "轨道系统") // { // str_ys_name = " and marnm like '%轨道%'"; // } // else if (ddl_YS_name.SelectedItem.Text.ToString() == "普通材料") // { // str_ys_name = " and charindex('轨道',marnm)=0 and PO_MASHAPE!='定尺板'"; // } // } // if (Mar_code=="01.11"||Mar_code=="01.08") // { // str_ys_name = " and charindex('" + ddl_YS_name.SelectedItem.Text.ToString() + "',marnm)>0 "; // string sql_contain = "select YS_Product_Name from TBBD_Product_type where YS_Product_Tag='1' " + // "and charindex('-',YS_Product_Code)>0 and YS_Product_Name like '%" + ddl_YS_name.SelectedItem.Text.ToString() + "%' " + // "and YS_Product_Name!='" + ddl_YS_name.SelectedItem.Text.ToString() + "'"; // System.Data.DataTable dt_contain = DBCallCommon.GetDTUsingSqlText(sql_contain); // for (int s = 0; s < dt_contain.Rows.Count; s++) // { // str_ys_name += " and charindex('" + dt_contain.Rows[s]["YS_Product_Name"] + "',marnm)=0"; // } // } // if (Mar_code=="other") // { // string sql_mar_type = "select YS_Product_Code from TBBD_Product_type where YS_Product_Name='" + ddl_YS_name.SelectedItem.Text.ToString() + "'"; // System.Data.DataTable dt_mar_type = DBCallCommon.GetDTUsingSqlText(sql_mar_type); // if (dt_mar_type.Rows.Count > 0) // { // str_ys_name += " and marid like '" + dt_mar_type.Rows[0][0].ToString() + "%'"; // } // } // return str_ys_name; //} //protected void bind_ddl_YSname() //{ // Encrypt_Decrypt ed = new Encrypt_Decrypt(); // string ContractNo = ed.DecryptText(Request.QueryString["ContractNo"].ToString()); // string Mar_code = Request.QueryString["Marcode"].ToString(); // string name_type = ""; // switch (Mar_code) // { // case "01.07": name_type = "FERROUS_METAL"; break; // case "01.11": name_type = "PURCHASE_PART"; break; // case "01.08": name_type = "MACHINING_PART"; break; // case "01.15": name_type = "PAINT_COATING"; break; // case "01.18": name_type = "ELECTRICAL"; break; // case "other": name_type = "OTHERMAT_COST"; break; // default: break; // } // string sql_YS_NAME = "select distinct YS_NAME,YS_NAME from YS_COST_BUDGET_DETAIL where YS_CONTRACT_NO='" + ContractNo + "' and YS_FATHER='" + name_type + "' and YS_NAME!='其它'"; // DBCallCommon.FillDroplist(ddl_YS_name, sql_YS_NAME); //} protected void bind_ddl_mar() { Encrypt_Decrypt ed = new Encrypt_Decrypt(); string ContractNo = ed.DecryptText(Request.QueryString["ContractNo"].ToString()); string Mar_code = Request.QueryString["Marcode"].ToString(); switch (Mar_code) { case "01.07": YS_NAME.Text = "黑色金属"; break; case "01.11": YS_NAME.Text = "外购件"; break; case "01.08": YS_NAME.Text = "加工件"; break; case "01.15": YS_NAME.Text = "油漆涂料"; break; case "01.18": YS_NAME.Text = "电气电料"; break; case "other": YS_NAME.Text = "其他材料费"; break; default: break; } string sql_where = " engid='" + ContractNo + "'"; //获取材料ID if (Mar_code != "other") { sql_where += " and marid like '" + Mar_code + "%'"; } else { sql_where += " and charindex(substring(marid,1,5),'01.07.01.08.01.11.01.15.01.18')=0"; } string sqltext_mar_type = "SELECT DISTINCT isnull(PO_MASHAPE,'无') ,PO_MASHAPE FROM View_TBPC_PURORDERDETAIL_PLAN_TOTAL where " + sql_where; DBCallCommon.FillDroplist(DropDownList_mar_type, sqltext_mar_type); }