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);
}
}
//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());
}
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);
}
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);
}
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);
}
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);
}
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);
}
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
}));
}
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
}));
}
