private void dataSearch(string type = "left") { int total = 0; string msg = ""; NameValueCollection nvc = new NameValueCollection(); if (type == "left") { if (ddlGoodsType.SelectedValue.Length > 0) { nvc.Add("CATID", ddlGoodsType.SelectedValue); } if (tgbSearch.Text.Length > 0) { nvc.Add("CX", tgbSearch.Text); } if (ddlStoreType.SelectedValue.Length > 0) { nvc.Add("DEPTOUT", ddlStoreType.SelectedValue); } if (ddlDept.SelectedValue.Length > 0) { nvc.Add("LEFT", ddlDept.SelectedValue); } GridGoods.DataSource = GetGoodsList(GridGoods.PageIndex, GridGoods.PageSize, nvc, ref total, ref msg); GridGoods.DataBind(); GridGoods.RecordCount = total; } else if (type == "right") { string sortField = GridCFGGoods.SortField; string sortDirection = GridCFGGoods.SortDirection; if (trbSearch.Text.Length > 0) { nvc.Add("CX", trbSearch.Text); } if (ddlDept.SelectedValue.Length > 0) { nvc.Add("RIGHT", ddlDept.SelectedValue); } DataTable table = GetGoodsList(GridCFGGoods.PageIndex, GridCFGGoods.PageSize, nvc, ref total, ref msg); DataView view1 = table.DefaultView; view1.Sort = String.Format("{0} {1}", sortField, sortDirection); GridCFGGoods.DataSource = view1; GridCFGGoods.DataBind(); GridCFGGoods.RecordCount = total; } }
private void dataSearch(string type = "left") { int total = 0; NameValueCollection nvc = new NameValueCollection(); object obj = DbHelperOra.GetSingle("SELECT value FROM SYS_PARA where code = 'ShowName'"); if (type == "left") { String Sql = "select g.GDSEQ, g.GDID,"; if ((obj ?? "").ToString() == "HIS") { Sql += @"NVL(g.HISNAME,g.GDNAME) GDNAME,NVL(g.STR3,g.GDSPEC) GDSPEC,"; } else { Sql += @"g.GDNAME,g.GDSPEC,"; } Sql += @"D.NAME UNITNAME,S.NAME FLAG_CN,DECODE(G.ISFLAG7,'Y','本地','下传') ISFLAG7_CN,F_GETPRODUCERNAME(G.PRODUCER) PRODUCERNAME,f_getsupname(G.SUPPLIER) SUPNAME FROM DOC_GOODS G,DOC_GOODSUNIT D, (SELECT CODE, NAME FROM SYS_CODEVALUE WHERE TYPE = 'GOODS_STATUS') S WHERE G.ISDELETE = 'N' AND G.FLAG = S.CODE(+) AND G.UNIT = D.CODE(+) AND G.FLAG = 'Y'"; if (ddlGoodsType.SelectedValue.Length > 0) { Sql += string.Format(" AND CATID0='{0}'", ddlGoodsType.SelectedValue); } if (!string.IsNullOrWhiteSpace(ddlGhs.SelectedValue)) { Sql += string.Format(" AND G.GDSEQ NOT IN(SELECT GDSEQ FROM DOC_GOODSSUP WHERE SUPID = '{0}')", ddlGhs.SelectedValue); } if (tgbSearch.Text.Trim().Length > 0) { Sql += string.Format(" AND (G.GDNAME LIKE '%{0}%' OR G.GDSEQ LIKE '%{0}%' OR G.NAMEJC LIKE '%{0}%' OR G.BAR3 LIKE '%{0}%' OR F_GETPRODUCERNAME(G.PRODUCER) LIKE '%{0}%' OR G.HISNAME LIKE '%{0}%' )", tgbSearch.Text.Trim()); } if (!string.IsNullOrWhiteSpace(ddlISFLAG7.SelectedValue)) { Sql += string.Format(" AND G.ISFLAG7 = '{0}'", ddlISFLAG7.SelectedValue); } DataTable dtData = PubFunc.DbGetPage(GridGoods.PageIndex, GridGoods.PageSize, Sql, ref total); GridGoods.RecordCount = total; GridGoods.DataSource = dtData; GridGoods.DataBind(); } else if (type == "right") { if (ddlGhs.SelectedValue != null && ddlGhs.SelectedValue.Length < 1) { GridCFGGoods.RecordCount = 0; GridCFGGoods.DataSource = null; GridCFGGoods.DataBind(); return; } String Sql = "SELECT b.GDSEQ,"; if ((obj ?? "").ToString() == "HIS") { Sql += @"NVL(b.HISNAME,b.GDNAME) GDNAME,NVL(b.STR3,b.GDSPEC) GDSPEC,"; } else { Sql += @"b.GDNAME,b.GDSPEC,"; } Sql += "f_getproducername(B.PRODUCER) PRODUCERNAME,f_getunitname(B.UNIT) UNITNAME FROM DOC_GOODSSUP A,DOC_GOODS B WHERE A.GDSEQ = B.GDSEQ AND B.FLAG = 'Y'"; if (trbSearch.Text.Trim().Length > 0) { Sql += string.Format(" AND (B.GDNAME LIKE '%{0}%' OR B.GDSEQ LIKE '%{0}%' OR B.NAMEJC LIKE '%{0}%' OR B.BAR3 LIKE '%{0}%' OR F_GETPRODUCERNAME(B.PRODUCER) LIKE '%{0}%')", trbSearch.Text.Trim()); } if (ddlGhs.SelectedValue != null && ddlGhs.SelectedValue.Length > 0) { Sql += string.Format(" AND A.SUPID = '{0}'", ddlGhs.SelectedValue); } if (ddlMODE.SelectedValue == "0" || ddlMODE.SelectedValue == "1") { if (ddlPssId.SelectedValue.Length < 1) { //Alert.Show("请选择配送商!", "提示信息", MessageBoxIcon.Warning); //return; } else { Sql += string.Format(" AND A.PSSID = '{0}'", ddlPssId.SelectedValue); } } if (ddlMODE.SelectedValue.Length > 0) { Sql += string.Format(" AND A.TYPE = '{0}'", ddlMODE.SelectedValue); } DataTable dtData = PubFunc.DbGetPage(GridCFGGoods.PageIndex, GridCFGGoods.PageSize, Sql, ref total); GridCFGGoods.RecordCount = total; GridCFGGoods.DataSource = dtData; GridCFGGoods.DataBind(); } }