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();
}
}
