/// <summary>
/// Update by providing a populated data row container
/// </summary>
/// <param name="row">The table row data to use</param>
/// <returns>The number of rows affected.</returns>
public virtual int Update(OrganizationContract row)
{
var rowCount = 0;
VotingInfoDb.ConnectThen(x =>
{
using (
var cmd = new SqlCommand("[Data].[Organization_Update]", x)
{
CommandType = CommandType.StoredProcedure,
CommandTimeout = DefaultCommandTimeout
})
{
cmd.Parameters.AddRange(new[] {
new SqlParameter("@OrganizationId", row.OrganizationId)
,
new SqlParameter("@ContentInspectionId", row.ContentInspectionId)
,
new SqlParameter("@OrganizationName", row.OrganizationName)
});
rowCount = cmd.ExecuteNonQuery();
}
});
return(rowCount);
}
/// <summary>
/// Insert by providing a populated data row container
/// </summary>
/// <param name="row">The table row data to use</param>
/// <returns>1, if insert was successful</returns>
public int Insert(OrganizationContract row)
{
int?result = null;
VotingInfoDb.ConnectThen(x =>
{
using (
var cmd = new SqlCommand("[Data].[Organization_Insert]", x)
{
CommandType = CommandType.StoredProcedure,
CommandTimeout = DefaultCommandTimeout
})
{
cmd.Parameters.AddRange(new[] {
new SqlParameter("@ContentInspectionId", row.ContentInspectionId)
,
new SqlParameter("@OrganizationName", row.OrganizationName)
});
result = (int?)cmd.ExecuteScalar();
row.OrganizationId = result;
}
});
return(result != null ? 1 : 0);
}
public static List<Organization> Convert(OrganizationContract[] organizations)
{
List<Organization> result = new List<Organization>();
for (int i = 0; i <= organizations.Length - 1; ++i)
{
result.Add(new Organization(organizations[i]));
}
return result;
}
/// <summary>
/// Saves the row, either by inserting (when the identity key is null) or by updating (identity key has value).
/// </summary>
/// <param name="row">The data to save</param>
/// <param name="connection">The SqlConnection to use</param>
/// <param name="transaction">The SqlTransaction to use</param>
/// <returns>The number of rows affected.</returns>
public static int SaveNow(OrganizationContract row, SqlConnection connection, SqlTransaction transaction)
{
if (row.OrganizationId == null)
{
return(InsertNow(row, connection, transaction));
}
else
{
return(UpdateNow(row, connection, transaction));
}
}
/// <summary>
/// Saves the row, either by inserting (when the identity key is null) or by updating (identity key has value).
/// </summary>
/// <param name="row">The data to save</param>
/// <returns>The number of rows affected.</returns>
public static int SaveNow(OrganizationContract row)
{
if (row.OrganizationId == null)
{
return(InsertNow(row));
}
else
{
return(UpdateNow(row));
}
}
/// <summary>
/// 更改机构
/// </summary>
/// <param name="organizationContract"></param>
/// <returns></returns>
public ResultContract <bool> UpdateOrganization(OrganizationContract organizationContract)
{
var result = new ResultContract <bool>()
{
Code = 0, Msg = "", Data = true
};
var organizationEntity = organizationContract.MapTo <OrganizationEntity>();
this._dbContext.Organization.Update(organizationEntity);
this._dbContext.SaveChanges();
return(result);
}
/// <summary>
/// Saves the row, either by inserting (when the identity key is null) or by updating (identity key has value).
/// </summary>
/// <param name="row">The data to save</param>
/// <param name="connection">The SqlConnection to use</param>
/// <param name="transaction">The SqlTransaction to use</param>
/// <returns>The number of rows affected.</returns>
public virtual int Save(OrganizationContract row, SqlConnection connection, SqlTransaction transaction)
{
if (row == null)
{
return(0);
}
if (row.OrganizationId != null)
{
return(Update(row, connection, transaction));
}
return(Insert(row, connection, transaction));
}
/// <summary>
/// Saves the row, either by inserting (when the identity key is null) or by updating (identity key has value).
/// </summary>
/// <param name="row">The data to save</param>
/// <returns>The number of rows affected.</returns>
public virtual int Save(OrganizationContract row)
{
if (row == null)
{
return(0);
}
if (row.OrganizationId != null)
{
return(Update(row));
}
return(Insert(row));
}
public async Task <Contracts.ResultContract <bool> > AddOrganization([FromBody] OrganizationContract organization)
{
try
{
return(_organizationService.AddOrganization(organization));
}
catch (Exception)
{
return(new Contracts.ResultContract <bool>()
{
Code = -1, Msg = "服务异常"
});
}
}
/// <summary>
/// 增加机构
/// </summary>
/// <param name="organizationContract"></param>
/// <returns></returns>
public ResultContract <bool> AddOrganization(OrganizationContract organizationContract)
{
var result = new ResultContract <bool>()
{
Code = 0, Msg = "", Data = true
};
var organizationEntity = organizationContract.MapTo <OrganizationEntity>();
organizationEntity.OrganizationId = Guid.NewGuid();
organizationEntity.CreateTime = DateTime.Now;
this._dbContext.Organization.Add(organizationEntity);
this._dbContext.SaveChanges();
return(result);
}
/// <summary>
/// Delete by providing a populated data contract
/// </summary>
/// <param name="row">The table row data to use</param>
/// <param name="connection">The SqlConnection to use</param>
/// <param name="transaction">The SqlTransaction to use</param>
/// <returns>The number of rows affected.</returns>
public virtual int Delete(OrganizationContract row, SqlConnection connection, SqlTransaction transaction)
{
var rowCount = 0;
using (
var cmd = new SqlCommand("[Data].[Organization_Delete]", connection)
{
CommandType = CommandType.StoredProcedure, Transaction = transaction
})
{
cmd.Parameters.AddRange(new[] {
new SqlParameter("@OrganizationId", row.OrganizationId)
});
rowCount = cmd.ExecuteNonQuery();
}
return(rowCount);
}
/// <summary>
/// Insert by providing a populated data contract
/// </summary>
/// <param name="row">The table row data to use</param>
/// <param name="connection">The SqlConnection to use</param>
/// <param name="transaction">The SqlTransaction to use</param>
/// <returns>1, if insert was successful</returns>
public int Insert(OrganizationContract row, SqlConnection connection, SqlTransaction transaction)
{
int?result = null;
using (
var cmd = new SqlCommand("[Data].[Organization_Insert]", connection)
{
CommandType = CommandType.StoredProcedure, Transaction = transaction
})
{
cmd.Parameters.AddRange(new[] {
new SqlParameter("@ContentInspectionId", row.ContentInspectionId)
,
new SqlParameter("@OrganizationName", row.OrganizationName)
});
result = (int?)cmd.ExecuteScalar();
row.OrganizationId = result;
}
return(result != null ? 1 : 0);
}
/// <summary>
/// Insert by providing a populated data row container
/// </summary>
/// <param name="row">The table row data to use</param>
/// <returns>The number of rows affected.</returns>
public static int InsertNow(OrganizationContract row)
{
return((new OrganizationLogic()).Insert(row));
}
/// <summary>
/// Insert by providing a populated data contract
/// </summary>
/// <param name="row">The table row data to use</param>
/// <param name="connection">The SqlConnection to use</param>
/// <param name="transaction">The SqlTransaction to use</param>
/// <returns>The number of rows affected.</returns>
public static int InsertNow(OrganizationContract row, SqlConnection connection, SqlTransaction transaction)
{
return((new OrganizationLogic()).Insert(row, connection, transaction));
}
public Organization(OrganizationContract group)
{
this.ID = group.ID;
this.Name = group.Name;
}
/// <summary>
/// 验证参数
/// </summary>
/// <param name="data"></param>
/// <param name="result"></param>
private void CheckParameter(BaseUploadContract data, ref ResultContract <string> result, ref OrganizationContract orgInfo)
{
//验证appid
if (string.IsNullOrWhiteSpace(data.AppId) || !_uploadHandService.CheckAppId(data.AppId))
{
result.Code = -1;
result.Msg = "系统没有注册！";
}
//验证组织机构id
if (data.OrgId == null)
{
result.Code = -1;
result.Msg = "请输入组织机构id！";
}
orgInfo = _uploadHandService.CheckOrgInfo(data.OrgId.GetValueOrDefault());
if (orgInfo == null)
{
result.Code = -1;
result.Msg = "组织机构输入错误！";
}
//验证资源类型
if (data.ThemeType != ThemeTypeEnum.ThemeEvent.GetIntValue() && data.ThemeType != ThemeTypeEnum.ThemeResource.GetIntValue())
{
result.Code = -1;
result.Msg = "资源类型错误！";
}
}
/// <summary>
/// Delete by providing a populated data contract
/// </summary>
/// <param name="row">The table row data to use</param>
/// <param name="connection">The SqlConnection to use</param>
/// <param name="transaction">The SqlTransaction to use</param>
/// <returns>The number of rows affected.</returns>
public static int DeleteNow(OrganizationContract row, SqlConnection connection, SqlTransaction transaction)
{
return((new OrganizationLogic()).Delete(row, connection, transaction));
}
/// <summary>
/// Delete by providing a populated data row container
/// </summary>
/// <param name="row">The table row data to use</param>
/// <returns>The number of rows affected.</returns>
public static int DeleteNow(OrganizationContract row)
{
return((new OrganizationLogic()).Delete(row));
}
public async Task <ResultContract <string> > UploadFile(BaseUploadContract data)
{
var result = new ResultContract <string>()
{
Code = 0, Msg = "上传成功"
};
try
{
//验证参数
var orgInfo = new OrganizationContract();
this.CheckParameter(data, ref result, ref orgInfo);
if (result.Code == -1)
{
return(result);
}
List <UploadContract> fileList = new List <UploadContract>();
var files = Request.Form.Files;
var groupId = Guid.NewGuid().ToString();
int order = 1;
foreach (var file in files)
{
var fileModel = new UploadContract()
{
UserId = data.UserId,
OrgId = data.OrgId,
AppId = data.AppId,
Tags = data.Tags,
UploadTime = DateTime.Now,
DisplayName = data.DisplayName,
Remark = data.Remark,
OrgName = orgInfo.OrganizationName,
Order = order,
ThemeType = data.ThemeType
};
//分组id
fileModel.GroupId = groupId;
var fileData = new MultipartFormDataContent();
//判断文件夹是否存在
if (!Directory.Exists(uploadFilePath))
{
Directory.CreateDirectory(uploadFilePath);
}
var imgPath = AppDomain.CurrentDomain.BaseDirectory + ConfigHelper.ReadConfigByName("ImgsPath");
if (!Directory.Exists(imgPath))
{
Directory.CreateDirectory(imgPath);
}
fileModel.FileName = file.FileName;
var lastName = file.FileName.Substring(file.FileName.LastIndexOf(".") + 1, (file.FileName.Length - file.FileName.LastIndexOf(".") - 1)); //扩展名
fileModel.FileId = Guid.NewGuid();
fileModel.NewFileName = fileModel.FileId + "." + lastName;
var fileLocalFullName = uploadFilePath + Path.DirectorySeparatorChar + fileModel.NewFileName;
var stream = file.OpenReadStream();
//文件保存到本地
double fileSize = 0;
//保存文件
FileHelper.SavaFile(fileLocalFullName, stream, ref fileSize);
//文件上传成功 修改model
fileModel.IsUpload = false;
fileModel.Url = fileLocalFullName;
fileModel.FileType = lastName;
//组织名称。后期加上
//判断文件大小
double uploadLimitSize = 0;
double.TryParse(ConfigHelper.ReadConfigByName("UploadLimitSizeM"), out uploadLimitSize);
//如果是视频截取封面
if (CommonDictionary.GetInstance().VideoType.Count(d => d.ToLower() == lastName.ToLower()) > 0)
{
var thumbnailPath = AliyunOSSHepler.GetInstance().GetPicFromVideo(fileLocalFullName, imgPath + Path.DirectorySeparatorChar + fileModel.FileId + ".jpg", "1");
var thumbnailUrl = "";
var isUpload = AliyunOSSHepler.GetInstance().UploadFiles(imgPath, fileModel.FileId + ".jpg", ref
thumbnailUrl, true);
fileModel.ThumbnailUrl = thumbnailPath;
if (isUpload && !string.IsNullOrWhiteSpace(thumbnailUrl))
{
fileModel.ThumbnailUrl = thumbnailUrl;
}
else
{
fileModel.IsFailure = true;
this._uploadHandService.SavaTagsFile(fileModel);
//把文件 移动到错误文件 文件夹
System.IO.File.Move(uploadFilePath + Path.DirectorySeparatorChar + fileModel.NewFileName, FailurePath + Path.DirectorySeparatorChar + fileModel.NewFileName);
result.Code = -1;
result.Msg = "截图失败";
return(result);
}
}
//如果断网把标签和文件都存到本地
if (!CommonDictionary.GetInstance().KafkaIsOnline)
{
this._uploadHandService.SavaTagsFile(fileModel);
}
else
{
//如果文件大小比预设大小 小 直接上云
if (fileSize < uploadLimitSize)
{
var url = "";
fileModel.IsUpload = AliyunOSSHepler.GetInstance().UploadFiles(uploadFilePath, fileModel.NewFileName, ref
url, false);
//如果上传失败 标签存本地
if (!fileModel.IsUpload)
{
fileModel.IsFailure = true;
this._uploadHandService.SavaTagsFile(fileModel);
//把文件 移动到错误文件 文件夹
System.IO.File.Move(uploadFilePath + Path.DirectorySeparatorChar + fileModel.NewFileName, FailurePath + Path.DirectorySeparatorChar + fileModel.NewFileName);
}
else
{
fileModel.Url = url;
}
}
fileList.Add(fileModel);
order++;
}
}
////把标签 推送到总署
KafKaContract kafkaModel = new KafKaContract();
if (fileList.Count > 1) //批量添加
{
kafkaModel.MsgCode = KafkaMsgCodeEnum.AddList;
kafkaModel.Msg = SerializeHelper.serializeToString(fileList);
KafKaLogic.GetInstance().Push(kafkaModel, KafkaTopic);
}
else if (fileList.Count() == 1) //单个文件添加
{
kafkaModel.MsgCode = KafkaMsgCodeEnum.Add;
fileList[0].GroupId = Guid.NewGuid().ToString();
kafkaModel.Msg = SerializeHelper.serializeToString(fileList[0]);
KafKaLogic.GetInstance().Push(kafkaModel, KafkaTopic);
}
}
catch (Exception e)
{
LogHelper.logError("上传文件失败：" + e.StackTrace);
result.Code = -1;
result.Msg = e.Message;
}
return(result);
}
