| | |
|---|
| | | { |
|---|
| | | gcMain1.DataSource = null; |
|---|
| | | System.Text.StringBuilder _sbSqlWhere = new System.Text.StringBuilder(); |
|---|
| | | _sbSqlWhere.Append(" and a.ReceiveOrgId in"); |
|---|
| | | _sbSqlWhere.Append(ToolBox.UtilityHelper.GetOrgWhere()); |
|---|
| | | _sbSqlWhere.Append(UtilityHelper.GetSearchWhere(_filterList)); |
|---|
| | | if (strType == QcSeason.其它入库检.ToString()) |
|---|
| | | { |
|---|
| | | _sbSqlWhere.Append(" and isnull(qtrk.qt028,0)=1 and isnull(qtrk.qt032,0)=1 and isnull(qtrk.qt015,0)=1 "); |
|---|
| | | } |
|---|
| | | if (strType == QcSeason.受托入库.ToString()) |
|---|
| | | { |
|---|
| | | _sbSqlWhere.Append(" and isnull(st.isCheck,0)=1 and isnull(st.qt032,0)=1"); |
|---|
| | | } |
|---|
| | | PageQueryModel pgq = new PageQueryModel(curPage, this.pageBar1.RowsCount, "release_no", "asc", "", " and a.order_type='" + strType + "' " + _sbSqlWhere.ToString()); |
|---|
| | | string json = JsonConvert.SerializeObject(pgq); |
|---|
| | | try |
|---|
