| | |
|---|
| | | { |
|---|
| | | if (warehousecode != "" && warehousecode != null) |
|---|
| | | { |
|---|
| | | search += "and code like '%'+@warehousecode+'%' "; |
|---|
| | | search += "and A.code like '%'+@warehousecode+'%' "; |
|---|
| | | dynamicParams.Add("@warehousecode", warehousecode); |
|---|
| | | } |
|---|
| | | if (warehousename != "" && warehousename != null) |
|---|
| | | { |
|---|
| | | search += "and name like '%'+@warehousename+'%' "; |
|---|
| | | search += "and A.name like '%'+@warehousename+'%' "; |
|---|
| | | dynamicParams.Add("@warehousename", warehousename); |
|---|
| | | } |
|---|
| | | if (description != "" && description != null) |
|---|
| | | { |
|---|
| | | search += "and description like '%'+@description+'%' "; |
|---|
| | | search += "and A.description like '%'+@description+'%' "; |
|---|
| | | dynamicParams.Add("@description", description); |
|---|
| | | } |
|---|
| | | if (createuser != "" && createuser != null) |
|---|
| | | { |
|---|
| | | search += "and lm_user like '%'+@createuser+'%' "; |
|---|
| | | search += "and T.username like '%'+@createuser+'%' "; |
|---|
| | | dynamicParams.Add("@createuser", createuser); |
|---|
| | | } |
|---|
| | | if (search == "") |
|---|
| | |
|---|
| | | } |
|---|
| | | // --------------查询指定数据-------------- |
|---|
| | | var total = 0; //总条数 |
|---|
| | | var sql = @"select id,code,name,description,lm_user,lm_date from T_Sec_Stck |
|---|
| | | where is_delete<>'1' " + search; |
|---|
| | | var sql = @"select A.id,A.code,A.name,A.description,T.username as lm_user,A.lm_date from T_Sec_Stck A |
|---|
| | | left join TUser T on A.lm_user=T.usercode |
|---|
| | | where A.is_delete<>'1' " + search; |
|---|
| | | var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total); |
|---|
| | | mes.code = "200"; |
|---|
| | | mes.Message = "查询成功!"; |
|---|
| | |
|---|
| | | } |
|---|
| | | if (createuser != "" && createuser != null) |
|---|
| | | { |
|---|
| | | search += "and A.lm_user like '%'+@createuser+'%' "; |
|---|
| | | search += "and U.username like '%'+@createuser+'%' "; |
|---|
| | | dynamicParams.Add("@createuser", createuser); |
|---|
| | | } |
|---|
| | | if (stockcode != "" && stockcode != null) |
|---|
| | |
|---|
| | | } |
|---|
| | | // --------------查询指定数据-------------- |
|---|
| | | var total = 0; //总条数 |
|---|
| | | var sql = @"select A.id,A.code,A.name,A.description,A.stock_code,B.name as stock_name,A.lm_user,A.lm_date |
|---|
| | | var sql = @"select A.id,A.code,A.name,A.description,A.stock_code,B.name as stock_name,U.username as lm_user,A.lm_date |
|---|
| | | from T_Sec_Loca A |
|---|
| | | left join T_Sec_Stck B on A.stock_code=B.code |
|---|
| | | left join TUser U on A.lm_user=U.usercode |
|---|
| | | where A.is_delete<>'1' " + search; |
|---|
| | | var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total); |
|---|
| | | mes.code = "200"; |
|---|
