| | |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | //判断用户数是否大于客户账号数 |
| | | DataSet ds1 = oCN.RunProcReturn("Exec h_p_Xt_BaseInfo ", "h_p_Xt_BaseInfo"); |
| | | if (DBUtility.ClsPub.isStrNull(ds1.Tables[0].Rows[0]["HBack"]) != "0") |
| | | { |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = ds1.Tables[0].Rows[0]["HBackRemark"].ToString(); |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | string sql = string.Format(@" select a.* from Gy_UserByOrgRelation a |
| | | where a.HUserID = '{0}' and a.HOrgID = '{1}'", UserName, HOrgName); |
| | | DataSet _ds = oCnLoc.RunProcReturn(sql, "h_p_Xt_UserRelationOrg_Check"); |