| | |
| | | } |
| | | |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 获取登录页组织列 |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("GetOrganizations")] |
| | | [HttpGet] |
| | | public object GetOrganizations() |
| | | { |
| | | try |
| | | { |
| | | ClsCN oCn = new ClsCN(); |
| | | DataSet oDs = new DataSet(); |
| | | //========== |
| | | oDs = oCn.RunProcReturn("select HItemID ID,Hname Name,HStopflag Stopflag from Xt_ORGANIZATIONS", "Xt_ORGANIZATIONS"); |
| | | objjson.code = "1"; |
| | | objjson.count = 1; |
| | | objjson.Message = "获取成功!"; |
| | | objjson.data = oDs.Tables[0]; |
| | | return objjson; ; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "获取失败!异常" + e.ToString(); |
| | | objjson.data = null; |
| | | return objjson; ; |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 登录 |
| | | /// </summary> |
| | |
| | | DataSet ds = null; |
| | | ClsCNSRM oCnLoc = new ClsCNSRM(); |
| | | DAL.ClsUser oUser = new DAL.ClsUser(); |
| | | ds = oUser.CheckCzymc(UserName.Trim(), DBUtility.ClsPub.StrToPsd(PassWord.Trim())); |
| | | Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); |
| | | //LogService.Write("测试1:"+ DBUtility.ClsPub.sExeReturnInfo); |
| | | string FCusName = oSystemParameter.GetSingleSystemParameter("WMS_CampanyName", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //LogService.Write("测试2:" + DBUtility.ClsPub.sExeReturnInfo); |
| | | //LogService.Write(FCusName); |
| | | if (FCusName == "夏宝电器") |
| | | ds = oUser.CheckMainID(UserName.Trim(), DBUtility.ClsPub.StrToPsd(PassWord.Trim())); |
| | | else |
| | | ds = oUser.CheckCzymc(UserName.Trim(), DBUtility.ClsPub.StrToPsd(PassWord.Trim())); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | return objJsonResult; ; |
| | | } |
| | | //=========== |
| | | oDs = oCn.RunProcReturn("select Czmm from Gy_Czygl where Czybm='" + UserName + "'", "Gy_Czygl"); |
| | | //LogService.Write("select Czmm from Gy_Czygl where Czymc='" + UserName + "' and Czmm = '" + DBUtility.ClsPub.StrToPsd(oldPassword.Trim()) + "'"); |
| | | oDs = oCn.RunProcReturn("select Czmm from Gy_Czygl where Czymc='" + UserName + "' and Czmm = '" + DBUtility.ClsPub.StrToPsd(oldPassword.Trim()) + "'", "Gy_Czygl"); |
| | | if (oDs == null || oDs.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "没有这个用户,不能修改密码!"; |
| | | objJsonResult.Message = "原密码错误!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; ; |
| | | } |
| | | else |
| | | { |
| | | oCn.RunProc("update Gy_Czygl set Czmm='" + DBUtility.ClsPub.StrToPsd(PassWord.Trim()) + "' where Czybm='" + UserName.Trim() + "'"); |
| | | oCn.RunProc("update Gy_Czygl set Czmm='" + DBUtility.ClsPub.StrToPsd(PassWord.Trim()) + "' where Czymc='" + UserName.Trim() + "'"); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "* 密码修改成功!"; |
| | |
| | | objJsonResult.Message = "返回数据成功!"; |
| | | objJsonResult.data = oDs; |
| | | } |
| | | else { |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "返回数据失败!"; |
| | |
| | | #region[更改公告状态] |
| | | [Route("UpdateMessage")] |
| | | [HttpGet] |
| | | public object UpdateMessage(string UserName, string HInterID,string HEntryID) |
| | | public object UpdateMessage(string UserName, string HInterID, string HEntryID) |
| | | { |
| | | ClsCNSRM oCn = new ClsCNSRM(); |
| | | oCn.BeginTran(); |
| | | oCn.RunProc("Update OA_InformBillSub set HReadFlag=1 HUpDater='"+ UserName + "',HUpDateDate=getdate() where HInterID='" + HInterID + "' and HEntryID='"+ HEntryID + "'", ref ClsPub.sExeReturnInfo); |
| | | oCn.RunProc("Update OA_InformBillSub set HReadFlag=1 HUpDater='" + UserName + "',HUpDateDate=getdate() where HInterID='" + HInterID + "' and HEntryID='" + HEntryID + "'", ref ClsPub.sExeReturnInfo); |
| | | oCn.Commit(); |
| | | objjson.code = "1"; |
| | | objjson.count = 1; |
| | | objjson.Message =ClsPub.sExeReturnInfo; |
| | | objjson.Message = ClsPub.sExeReturnInfo; |
| | | objjson.data = null; |
| | | return objjson;; |
| | | return objjson; ; |
| | | } |
| | | #endregion |
| | | } |