| | |
|---|
| | | |
|---|
| | | |
|---|
| | | #region[组织架构,查询组织信息] |
|---|
| | | public static ToMessage STorgData(string storg_code, string storg_name, int startNum, int endNum, string prop, string order) |
|---|
| | | public static ToMessage STorgData(string storg_code, string storg_name) |
|---|
| | | { |
|---|
| | | var dynamicParams = new DynamicParameters(); |
|---|
| | | string search = ""; |
|---|
| | |
|---|
| | | search += "and T.torg_name like '%'+@storg_name+'%' "; |
|---|
| | | dynamicParams.Add("@storg_name", storg_name); |
|---|
| | | } |
|---|
| | | // --------------查询指定数据-------------- |
|---|
| | | var total = 0; //总条数 |
|---|
| | | var sql = @"select T.id,T.parent_id,T.torg_code,T.torg_name,T.status,T.leve,T.torg_seq, |
|---|
| | | T.lm_user as usercode,U.username,T.lm_date |
|---|
| | | from TOrganization T |
|---|
| | | left join TUser U on T.lm_user=U.usercode |
|---|
| | | where 1=1" + search + ""; |
|---|
| | | var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total); |
|---|
| | | where 1=1" + search + " order by T.lm_date desc"; |
|---|
| | | var data = DapperHelper.selectdata(sql, dynamicParams); |
|---|
| | | mes.code = "200"; |
|---|
| | | mes.Message = "查询成功!"; |
|---|
| | | mes.count = total; |
|---|
| | | mes.data = data.ToList(); |
|---|
| | | mes.count = data.Rows.Count; |
|---|
| | | mes.data = data; |
|---|
| | | } |
|---|
| | | catch (Exception e) |
|---|
| | | { |
|---|
