/// <summary> /// 查询 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnQurey_OnClick(object sender, EventArgs e) { string sqltext = "select *,cast(BM_SINGNUMBER as varchar)+' | '+cast(BM_NUMBER as varchar)+' | '+cast(BM_PNUMBER as varchar) AS NUMBER from " + ViewState["viewtablename"].ToString() + " where BM_ENGID='" + ViewState["TaskID"].ToString() + "' AND BM_KU='库' and BM_MASHAPE='采' and BM_MASTATE='标' AND BM_MARID<>'' AND BM_BJ='N'"; if (ddlParts.SelectedIndex != 0) { sqltext += "AND (BM_XUHAO='" + ddlParts.SelectedValue + "' OR BM_XUHAO LIKE '" + ddlParts.SelectedValue + ".%')"; } udqMS.ExistedConditions = sqltext; sqltext += UserDefinedQueryConditions.ReturnQueryString((GridView)udqMS.FindControl("GridView1"), (Label)udqMS.FindControl("Label1")); sqltext += " order by dbo.f_formatstr(BM_XUHAO,'.')"; DataTable dt = DBCallCommon.GetDTUsingSqlText(sqltext); if (dt.Rows.Count > 0) { GridView1.DataSource = dt; GridView1.DataBind(); NoDataPanel.Visible = false; btnCreate.Visible = true; } else { GridView1.DataSource = null; GridView1.DataBind(); NoDataPanel.Visible = true; btnCreate.Visible = false; } }
/// <summary> /// 查询 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnQuery_OnClick(object sender, EventArgs e) { string strWhere = " BM_ENGID='" + ViewState["TaskID"].ToString() + "' AND BM_MARID!='' AND BM_MSSTATE='0' AND BM_MPSTATE='0' AND BM_OSSTATE='0' "; string sql = "select DISTINCT [BM_MARID],[BM_MANAME],[BM_MAGUIGE],[BM_MAQUALITY],[BM_STANDARD],[BM_MASHAPE],[BM_MASTATE] from View_TM_DQO where "; if (txtGuiGe.Text.Trim() != "") { strWhere += " AND [BM_MAGUIGE] like '%" + txtGuiGe.Text.Trim() + "%'"; } if (txtMarCZ.Text.Trim() != "") { strWhere += " AND [BM_MAQUALITY] like '%" + txtMarCZ.Text.Trim() + "%'"; } if (txtMarid.Text.Trim() != "") { strWhere += " AND [BM_MARID] like '%" + txtMarid.Text.Trim() + "%'"; } if (txtMarName.Text.Trim() != "") { strWhere += " AND [BM_MANAME] like '%" + txtMarName.Text.Trim() + "%'"; } if (txtZongXu.Text.Trim() != "") { strWhere += " AND [BM_ZONGXU]='" + txtZongXu.Text.Trim() + "' or [BM_ZONGXU] like '" + txtZongXu.Text.Trim() + ".%'"; } udqOrg.ExistedConditions = strWhere; strWhere += UserDefinedQueryConditions.ReturnQueryString((GridView)udqOrg.FindControl("GridView1"), (Label)udqOrg.FindControl("Label1")); sql += strWhere + " ORDER BY BM_MARID"; ViewState["strWhere"] = strWhere.Replace('\'', '^'); DataTable dt = DBCallCommon.GetDTUsingSqlText(sql); GridView2.DataSource = dt; GridView2.DataBind(); if (GridView2.Rows.Count > 0) { NoDataPanel1.Visible = false; } else { NoDataPanel1.Visible = true; } }
private string Get_StrWhere() { string returnValue = ViewState["sqlText"].ToString(); //显示级数 if (ddlOrgJishu.SelectedIndex != 0) { returnValue += " AND [dbo].[Splitnum](" + ddlShowType.SelectedValue + ",'.')=" + ddlOrgJishu.SelectedValue + " "; } udqMS.ExistedConditions = returnValue; returnValue = returnValue + UserDefinedQueryConditions.ReturnQueryString((GridView)udqMS.FindControl("GridView1"), (Label)udqMS.FindControl("Label1")); return(returnValue); }
/// <summary> /// 获取查询Where条件 /// </summary> /// <returns></returns> private string CreateConStr() { string sql = ""; sql += " TSA_STATE='" + rblstatus.SelectedValue + "' "; if (ddlSearch.SelectedItem.Text.Trim() != "-请选择-") { sql += "and " + ddlSearch.SelectedValue.Trim() + " like '%" + txtSearch.Text.Trim() + "%'";//下拉 } if (IsPostBack) { udqMS.ExistedConditions = sql; sql = sql + UserDefinedQueryConditions.ReturnQueryString((GridView)udqMS.FindControl("GridView1"), (Label)udqMS.FindControl("Label1")); } return(sql); }
/// <summary> /// 查询 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnOrgQuery_OnClick(object sender, EventArgs e) { this.GetListName(); StringBuilder strb_sql = new StringBuilder(); strb_sql.Append(" BM_ENGID='" + hdfEngid.Value.Trim() + "'"); if (ddlQueryType.SelectedIndex != 0) { if (txtMCorZX.Text.Trim() != "") { if (ddlQueryType.SelectedValue == "BM_ZONGXU" || ddlQueryType.SelectedValue == "BM_XUHAO") { strb_sql.Append(" and (" + ddlQueryType.SelectedValue.ToString() + "='" + txtMCorZX.Text.Trim() + "' OR " + ddlQueryType.SelectedValue.ToString() + " like '" + txtMCorZX.Text.Trim() + ".%')"); } else { strb_sql.Append(" and " + ddlQueryType.SelectedValue.ToString() + " like '%" + txtMCorZX.Text.Trim() + "%'"); } } else { strb_sql.Append(" and " + ddlQueryType.SelectedValue.ToString() + "='" + txtMCorZX.Text.Trim() + "'"); } } //操作的字段 if (ddlRepType.SelectedValue == "BM_TUHAO") { strb_sql.Append(" AND BM_MSSTATE='0' AND BM_OSSTATE='0'"); } else if (ddlRepType.SelectedValue == "BM_MASHAPE" || ddlRepType.SelectedValue == "BM_MASTATE") { strb_sql.Append(" AND BM_MPSTATE='0' AND BM_OSSTATE='0' AND BM_MSSTATE='0'"); } udqMS.ExistedConditions = strb_sql.ToString(); ViewState["Org"] = strb_sql.ToString() + UserDefinedQueryConditions.ReturnQueryString((GridView)udqMS.FindControl("GridView1"), (Label)udqMS.FindControl("Label1")); UCPagingOrg.CurrentPage = 1; this.InitVar(UCPagingOrg, viewtable, "BM_ID", "*,cast(BM_SINGNUMBER as varchar)+' | '+cast(BM_NUMBER as varchar)+' | '+cast(BM_PNUMBER as varchar) AS NUMBER", "dbo.f_formatstr(" + ddlSort.SelectedValue.ToString() + ", '.')", ViewState["Org"].ToString(), 0, 30); this.bindGrid(UCPagingOrg, GridView1, NoDataPanel1); ViewState["CurrentUCPaging"] = "UCPagingOrg"; }
/// <summary> /// 清空 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnMSClear_OnClick(object sender, EventArgs e) { UserDefinedQueryConditions.UserDefinedExternalCallForInitControl((GridView)udqMS.FindControl("GridView1")); }
/// <summary> /// 返回详细信息的查询条件 /// </summary> private string GetSearchList() { this.InitList(); //获取类别 string wherecond = ""; if (ddlmpName.SelectedItem.Text.Trim() == "标准件") { wherecond = " and MP_MASHAPE='采' "; } else if (ddlmpName.SelectedItem.Text.Trim() == "钢材") { wherecond = " and (MP_MASHAPE='板' or MP_MASHAPE='型' or MP_MASHAPE='圆') "; } else if (ddlmpName.SelectedItem.Text.Trim() == "铸锻件") { wherecond = "and ( MP_MASHAPE='锻' or MP_MASHAPE='铸')"; } else if (ddlmpName.SelectedItem.Text.Trim() == "采购成品") { wherecond = " and MP_MASHAPE = '采购成品' "; } else if (ddlmpName.SelectedItem.Text.Trim() == "非金属") { wherecond = " and MP_MASHAPE = '非金属' "; } //材料名称 if (ddlMarName.SelectedIndex != 0) { wherecond += " and MP_NAME='" + ddlMarName.SelectedValue + "'"; } //材料规格 if (ddlMarGuiGe.SelectedIndex != 0) { wherecond += " and MP_GUIGE='" + ddlMarGuiGe.SelectedValue + "'"; } //材料材质 if (ddlMarCaiZhi.SelectedIndex != 0) { wherecond += " and MP_CAIZHI='" + ddlMarCaiZhi.SelectedValue + "'"; } if (ckbShowZero.Checked) { wherecond += " and (MP_YONGLIANG='0' or MP_YONGLIANG='') "; } //根据批号查询数据 string sql_select_detail = " MP_PID='" + mp_no.Value + "'"; //string sql_select_type = "select MP_MASHAPE from "+mptable+" where MP_ID='"+mp_no.Value+"' "; //string matype="";//提交的该批材料计划类别:非定尺板、定尺板、型材、标(发运)、标(组装) //SqlDataReader dr=DBCallCommon.GetDRUsingSqlText(sql_select_type); //if(dr.HasRows) //{ // dr.Read(); // matype=dr["MP_MASHAPE"].ToString(); // dr.Close(); //} //if (matype == "非定尺板") //{ // GridView1.Columns[13].HeaderText = "张数";//数量》》张数 // GridView1.Columns[13].Visible = false;//如果是非定尺不显示数量列 //} //else if (matype == "定尺板") //{ // GridView1.Columns[13].HeaderText = "张数";//数量》》张数 //} //else if (matype == "型材") //{ // GridView1.Columns[13].HeaderText = "根数";//数量》》总长 //} //else if (matype == "标(发运)") //{ // ; //} //else if (matype == "标(组装)") //{ // ; //} //if (matype != "") //{ sql_select_detail += " " + wherecond + ""; //} if (IsPostBack) { udqOrg.ExistedConditions = sql_select_detail; sql_select_detail += UserDefinedQueryConditions.ReturnQueryString((GridView)udqOrg.FindControl("GridView1"), (Label)udqOrg.FindControl("Label1")); } return(sql_select_detail); }
/// <summary> /// BUTTON重置 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnClear_OnClick(object sender, EventArgs e) { UserDefinedQueryConditions.UserDefinedExternalCallForInitControl((GridView)udqMS.FindControl("GridView1")); ddlQueryType.SelectedIndex = 0; txtMCorZX.Text = ""; }