コード例 #1
0
        public CompanyUserResponse Create(CompanyUserViewModel companyUser)
        {
            CompanyUserResponse response = new CompanyUserResponse();

            using (SqliteConnection db = new SqliteConnection(SQLiteHelper.SqLiteTableName))
            {
                db.Open();

                SqliteCommand insertCommand = db.CreateCommand();
                insertCommand.CommandText = SqlCommandInsertPart;

                try
                {
                    insertCommand = AddCreateParameters(insertCommand, companyUser);
                    insertCommand.ExecuteNonQuery();
                }
                catch (SqliteException error)
                {
                    //MainWindow.ErrorMessage = error.Message;
                    response.Success = false;
                    response.Message = error.Message;
                    return(response);
                }
                db.Close();

                response.Success = true;
                return(response);
            }
        }
コード例 #2
0
ファイル: Class1.cs プロジェクト: liuwei0925/myPrj
        //9.1.3	查询集团用户
        public string QueryCompanyUser(QChat_Query qchat)
        {
            QchatQEDService qqs = new QchatQEDService();

            qqs = getQchatQEDService(qchat.username, qchat.password, qchat.deviceID, qchat.urlIp);

            //查询参数
            QueryRequest queryRequest = new QueryRequest();

            queryRequest.mainParam = qchat.mainParam; //"xghcnc933731"; //为管理员名称
            queryRequest.pageSize  = qchat.pageSize;  //10; //查询条数,默认为10
            queryRequest.startPos  = qchat.startPos;  //0; //起始位置
            QedRequest qedr = new QedRequest();

            qedr.queryRequest = queryRequest;

            QedResponse         response        = qqs.queryCompanyUser(qedr);
            CompanyUserResponse companyResponse = response.companyUserResponse;
            StringBuilder       sb = new StringBuilder();

            if (companyResponse != null && companyResponse.userInfo != null)
            {
                sb.AppendLine("count:" + companyResponse.count.ToString());
                sb.AppendLine("Response:" + companyResponse.response.description.ToString());
                sb.AppendLine("reserve:" + companyResponse.response.reserve);
                sb.AppendLine("returnCode:" + companyResponse.response.returnCode);

                sb.AppendLine("groupInfo:" + companyResponse.userInfo.ToString());
                for (int i = 0; i < companyResponse.userInfo.Length; i++)
                {
                    sb.AppendLine("用户" + i);
                    sb.AppendLine("domain:" + companyResponse.userInfo[i].domain);
                    sb.AppendLine("callRestriction:" + companyResponse.userInfo[i].callRestriction);
                    sb.AppendLine("imsi:" + companyResponse.userInfo[i].imsi);
                    sb.AppendLine("level:" + companyResponse.userInfo[i].level);
                    sb.AppendLine("name:" + companyResponse.userInfo[i].name);
                    sb.AppendLine("number:" + companyResponse.userInfo[i].number);
                    sb.AppendLine("password:"******"status:" + companyResponse.userInfo[i].status);
                }
            }
            else
            {
                sb.AppendLine("返回信息为null");
            }
            Console.WriteLine(sb);

            //Console.ReadKey();
            return(sb.ToString());
        }
コード例 #3
0
        public CompanyUserResponse Create(CompanyUserViewModel companyUser)
        {
            CompanyUserResponse response = new CompanyUserResponse();

            try
            {
                response = WpfApiHandler.SendToApi <CompanyUserViewModel, CompanyUserResponse>(companyUser, "Create");
            }
            catch (Exception ex)
            {
                response.CompanyUser = new CompanyUserViewModel();
                response.Success     = false;
                response.Message     = ex.Message;
            }

            return(response);
        }
コード例 #4
0
        public CompanyUserResponse GetCompanyUser(int companyId, int userId)
        {
            CompanyUserResponse  response = new CompanyUserResponse();
            CompanyUserViewModel user     = null;

            try
            {
                using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db"))
                {
                    db.Open();

                    SqliteCommand selectCommand = new SqliteCommand(
                        SqlCommandSelectPart +
                        "from CompanyUsers " +
                        "WHERE @CompanyId = CompanyId AND @UserId = UserId ", db);

                    selectCommand.Parameters.AddWithValue("@CompanyId", companyId);
                    selectCommand.Parameters.AddWithValue("@UserId", userId);

                    SqliteDataReader query = selectCommand.ExecuteReader();

                    while (query.Read())
                    {
                        user = Read(query);
                    }


                    db.Close();
                }
            }
            catch (SqliteException error)
            {
                response.Success     = false;
                response.Message     = error.Message;
                response.CompanyUser = new CompanyUserViewModel();
                //MainWindow.ErrorMessage = error.Message;
                return(response);
            }
            response.Success     = true;
            response.CompanyUser = user;
            return(response);
        }
コード例 #5
0
        public CompanyUserResponse Delete(Guid identifier)
        {
            CompanyUserResponse response = new CompanyUserResponse();

            try
            {
                response = WpfApiHandler.GetFromApi <CompanyUserViewModel, CompanyUserResponse>("Delete", new Dictionary <string, string>()
                {
                    { "identifier", identifier.ToString() }
                });
            }
            catch (Exception ex)
            {
                response.CompanyUser = new CompanyUserViewModel();
                response.Success     = false;
                response.Message     = ex.Message;
            }

            return(response);
        }
コード例 #6
0
        public CompanyUserResponse Delete(Guid identifier)
        {
            CompanyUserResponse response = new CompanyUserResponse();

            try
            {
                var deletedItem = unitOfWork.GetCompanyUserRepository().Delete(identifier);

                unitOfWork.Save();
                response.Success     = true;
                response.CompanyUser = deletedItem?.ConvertToCompanyUserViewModel();
            }
            catch (Exception ex)
            {
                response.Success     = false;
                response.Message     = ex.Message;
                response.CompanyUser = new CompanyUserViewModel();
            }
            return(response);
        }
コード例 #7
0
        public CompanyUserResponse Create(CompanyUserViewModel companyUser)
        {
            CompanyUserResponse response = new CompanyUserResponse();

            try
            {
                var savedItem = unitOfWork.GetCompanyUserRepository().Create(companyUser?.ConvertToCompanyUser());
                unitOfWork.Save();
                response.Success = true;

                response.CompanyUser = savedItem?.ConvertToCompanyUserViewModel();
            }
            catch (Exception ex)
            {
                response.Success     = false;
                response.Message     = ex.Message;
                response.CompanyUser = new CompanyUserViewModel();
            }
            return(response);
        }
コード例 #8
0
        public JsonResult Delete(Guid identifier)
        {
            CompanyUserResponse response = new CompanyUserResponse();

            try
            {
                response = this.userService.Delete(identifier);
            }
            catch (Exception ex)
            {
                response.Success = false;
                response.Message = ex.Message;
                Console.WriteLine(ex.Message);
            }

            return(Json(response, new Newtonsoft.Json.JsonSerializerSettings()
            {
                Formatting = Newtonsoft.Json.Formatting.Indented
            }));
        }
コード例 #9
0
        public JsonResult Create([FromBody] CompanyUserViewModel c)
        {
            CompanyUserResponse response = new CompanyUserResponse();

            try
            {
                response = this.userService.Create(c);
            }
            catch (Exception ex)
            {
                response.Success = false;
                response.Message = ex.Message;
                Console.WriteLine(ex.Message);
            }

            return(Json(response, new Newtonsoft.Json.JsonSerializerSettings()
            {
                Formatting = Newtonsoft.Json.Formatting.Indented
            }));
        }