Ejemplo n.º 1
0
        public string GetSMSContentInfo(string sessionID)
        {
            DataSet       ds = new DataSet();
            PersistBroker b  = PersistBroker.Instance();

            try
            {
                if (sessionID != "")
                {
                    //验证用户是否已通过登录验证
                    DataSet dtUser = b.ExecuteSQLForDst("select USERID from secuser where USERITEM4 = '" + sessionID + "'");
                    if (dtUser.Tables[0].Rows.Count > 0)
                    {
                        DataSet   tempDS = new DataSet();
                        DataTable tempDT = new DataTable();
                        tempDS = b.ExecuteSQLForDst(@"
                                SELECT T_PICI FROM SMSCONTENT
                                WHERE S_STATE <> '2'  AND CELLPHONE IS NOT NULL
                                GROUP BY T_PICI
                                ");
                        if (tempDS != null && tempDS.Tables[0] != null)
                        {
                            int icount = tempDS.Tables[0].Rows.Count > 10 ? 10 : tempDS.Tables[0].Rows.Count;
                            for (int i = 0; i < tempDS.Tables[0].Rows.Count; i++)
                            {
                                if (i < 10)
                                {
                                    tempDT = new DataTable();
                                    tempDT.Merge(b.ExecuteSQLForDst(@"
                                    SELECT ID
                                        ,PERSONID
                                        ,EMPLOYEEID
                                        ,ENAME
                                        ,PCOMTENT
                                        ,PTIME
                                        ,CELLPHONE
                                        ,T_PICI
                                        ,P_SALARYMONTH
                                        ,BATCHID
                                        ,'" + icount + @"' AS COUNT
                                    FROM SMSCONTENT WHERE S_STATE = '1' AND CELLPHONE IS NOT NULL AND T_PICI = '" + tempDS.Tables[0].Rows[i]["T_PICI"].ToString() + @"'
                                ").Tables[0]);
                                    tempDT.TableName = (i + 1).ToString();
                                    ds.Tables.Add(tempDT);
                                }
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
            }
            finally
            {
                b.Close();
            }
            return(JsonConvert.SerializeObject(ds, new DataTableConverter()));
        }
Ejemplo n.º 2
0
 /// <summary>
 /// 0 and '' ZGAIA03358 待发送
 ///2 ZGAIA03355 发送成功
 ///? ZGAIA03354 发送失败
 /// </summary>
 /// <param name="con"></param>
 /// <returns></returns>
 public string UpdateSMSContentInfo(string con)
 {
     if (!string.IsNullOrEmpty(con))
     {
         DataSet       dt = new DataSet();
         PersistBroker b  = PersistBroker.Instance();
         try
         {
             SmsStatus s = (SmsStatus)JsonConvert.DeserializeObject(con, typeof(SmsStatus));
             if (s.SessionId != "")
             {
                 //验证用户是否已通过登录验证
                 DataSet dtUser = b.ExecuteSQLForDst("select USERID from secuser where USERITEM4 = '" + s.SessionId + "'");
                 if (dtUser.Tables[0].Rows.Count > 0)
                 {
                     List <SmsStatusList> n = s.StatusList;
                     b.BeginTrans();
                     foreach (SmsStatusList item in n)
                     {
                         dt = b.ExecuteSQLForDst(@"
                                 UPDATE SMSCONTENT
                                    SET S_STATE = '" + item.SendStatus + @"'
                                       ,STIME ='" + item.SendTime + @"'
                                  WHERE ID = '" + item.Id + @"'
                         ");
                     }
                     b.CommitTrans();
                 }
             }
         }
         catch (Exception ex)
         {
             b.RollbackTrans();
             return(JsonConvert.SerializeObject("The data is abnormal", new DataTableConverter()));
         }
         finally
         {
             b.Close();
             //Conn.Close();
         }
         return(JsonConvert.SerializeObject("The update is successful", new DataTableConverter()));
     }
     else
     {
         return(JsonConvert.SerializeObject("Data is empty", new DataTableConverter()));
     }
 }
Ejemplo n.º 3
0
        /// <summary>
        /// 校验用户帐号密码
        /// </summary>
        /// <param name="LoginAccount"></param>
        /// <param name="Password"></param>
        /// <param name="TimeOut"></param>
        /// <param name="BusinessCode"></param>
        /// <param name="msg"></param>
        /// <param name="SessionID"></param>
        /// <param name="um"></param>
        /// <returns></returns>
        public bool ValidateUser(string LoginAccount, string Password, int TimeOut,
                                 int BusinessCode, out string msg, out string SessionID, out UserModule um)
        {
            um        = new UserModule();
            msg       = "";
            SessionID = "";

            PersistBroker b = PersistBroker.Instance();

            b.TimeOut = TimeOut;

            try
            {
                DataTable dt = b.ExecuteSQLForDst(@"select LOGINNAME,TRUENAME,FIRSTNAME,d.NAMES as POSITIONNAME,
                        b.PERSONID,c.UNITNAME,a.ISLOCK,b.EMPLOYEEID,a.USERID,a.PASSWORD from secuser a 
                    left join psnaccount b on a.personid = b.PERSONID
                    left join ORGStdStruct c on c.unitid = b.branchid
                    left join cpcjobcode d on d.JOBCODEID = b.jobcode 
                    where b.PERSONID is not null AND LOGINNAME = '" + LoginAccount.Replace("'", "''") + "' ").Tables[0];

                if (dt.Rows.Count == 0)
                {
                    msg = "帐号不存在";
                    return(false);
                }

                if (dt.Rows[0]["ISLOCK"].ToString() == "1")
                {
                    msg = "帐号已禁用";
                    return(false);
                }

                string DBKey = dt.Rows[0]["PASSWORD"].ToString();
                if (MD5New(Password) == DBKey || MD5Old(Password) == DBKey)
                {
                    um.UserAccount        = dt.Rows[0]["LOGINNAME"].ToString();
                    um.IsLock             = false;
                    um.UserChineseName    = dt.Rows[0]["TRUENAME"].ToString();
                    um.UserEmployeeID     = dt.Rows[0]["EMPLOYEEID"].ToString();
                    um.UserEnglishName    = dt.Rows[0]["FIRSTNAME"].ToString();
                    um.UserDepartmentName = dt.Rows[0]["UNITNAME"].ToString();
                    um.UserID             = dt.Rows[0]["USERID"].ToString();
                    um.PersonID           = dt.Rows[0]["PERSONID"].ToString();
                    um.UserPosition       = dt.Rows[0]["POSITIONNAME"].ToString();

                    SessionID = Guid.NewGuid().ToString();

                    b.ExecuteSQL("update SECUSER set USERITEM4 = '" + SessionID + "' where USERID='" + um.UserID + "'");

                    return(true);
                }
                else
                {
                    msg = "密码不正确";
                    return(false);
                }
            }
            catch (Exception ex)
            {
                msg = ex.Message;
                return(false);
            }
            finally
            {
                b.Close();
            }
        }