| | |
|---|
| | | |
|---|
| | | objjson.code = "0"; |
|---|
| | | objjson.count = 0; |
|---|
| | | objjson.Message = "[0000-1-074]登录异常！" + e.Message; |
|---|
| | | objjson.Message = "[0000-1-074]登录异常！" + e; |
|---|
| | | objjson.data = null; |
|---|
| | | return objjson; ; |
|---|
| | | } |
|---|
| | |
|---|
| | | { |
|---|
| | | objjson.code = "0"; |
|---|
| | | objjson.count = 0; |
|---|
| | | objjson.Message = "获取失败" + ex.ToString(); |
|---|
| | | objjson.Message = "获取失败" + ex.Message.ToString(); |
|---|
| | | objjson.data = null; |
|---|
| | | return objjson; |
|---|
| | | } |
|---|
| | |
|---|
| | | |
|---|
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
|---|
| | | |
|---|
| | | ds = oCN.RunProcReturn("select ManagerFlag from gy_czygl where czymc='" + user.Trim() + "'", "gy_czygl"); |
|---|
| | | if (!(bool)ds.Tables[0].Rows[0]["ManagerFlag"]) //是否管理员 |
|---|
| | | { |
|---|
| | | //不是管理员 |
|---|
| | | sWhere += " and 制单人 = '" + user + "'"; |
|---|
| | | } |
|---|
| | | //ds = oCN.RunProcReturn("select ManagerFlag from gy_czygl where czymc='" + user.Trim() + "'", "gy_czygl"); |
|---|
| | | //if (!(bool)ds.Tables[0].Rows[0]["ManagerFlag"]) //是否管理员 |
|---|
| | | //{ |
|---|
| | | // //不是管理员 |
|---|
| | | // sWhere += " and 制单人 = '" + user + "'"; |
|---|
| | | //} |
|---|
| | | |
|---|
| | | |
|---|
| | | string sql = string.Format(@"select * from " + HView + " where 1 = 1 " + sWhere + " order by 日期 desc, hmainid desc"); |
|---|
