| | |
|---|
| | | public void getSuppler(string orgId, string _dftVale = "") |
|---|
| | | { |
|---|
| | | lookSearchSupplier.EditValue = null; |
|---|
| | | string _keyWhere = ""; |
|---|
| | | System.Text.StringBuilder _sbSqlWhere = new System.Text.StringBuilder(); |
|---|
| | | if (!string.IsNullOrEmpty(orgId)) |
|---|
| | | _keyWhere = " and a.FSubsidiary ='" + orgId + "'"; |
|---|
| | | var pgq = new PageQueryModel(1, 999999, "a.FSubsidiary asc,a.departmentcode", "asc", "", " and 1=1" + _keyWhere); |
|---|
| | | _sbSqlWhere.Append(" and a.FSubsidiary ='" + orgId + "'"); |
|---|
| | | _sbSqlWhere.Append(" and a.FSubsidiary in"); |
|---|
| | | _sbSqlWhere.Append(ToolBox.UtilityHelper.GetOrgWhere()); |
|---|
| | | |
|---|
| | | var pgq = new PageQueryModel(1, 999999, "a.FSubsidiary asc,a.departmentcode", "asc", "", " and 1=1" + _sbSqlWhere.ToString()); |
|---|
| | | var json = JsonConvert.SerializeObject(pgq); |
|---|
| | | try |
|---|
| | | { |
|---|
