public IHttpActionResult Post(ApiDeductUploadContracts entity)
{
bool state = this.code.InsertDeductIns(entity);
var result = ApiBackParameter <bool> .Get((api) =>
{
api.StatusCode = StatusCodeEnum.成功.GetIntValue();
api.Data = state;
});
return(Ok(result));
}
public IHttpActionResult Put(string deducInsId, ApiDeductUploadContracts entity)
{
string data = code.UpdateDeductIns(deducInsId, entity);
var result = ApiBackParameter <string> .Get((api) =>
{
api.StatusCode = StatusCodeEnum.成功.GetIntValue();
api.Data = data;
});
return(Ok(result));
}
public IHttpActionResult oldPost(ApiDeductUploadContracts entity)
{
string data = code.oudInsertDeductIns(entity);
var result = ApiBackParameter <string> .Get((api) =>
{
api.StatusCode = StatusCodeEnum.成功.GetIntValue();
api.Data = data;
});
return(Ok(result));
}
/// <summary>
/// 上传添加扣分记录
/// </summary>
/// <param name="deductsInsEntity"></param>
/// <returns></returns>
public string oudInsertDeductIns(ApiDeductUploadContracts deductsInsEntity)
{
using (var db = new RepositoryBase().BeginTrans())
{
var sNormEntity = db.IQueryable <ProfileScireCriteria_NormEntity>().FirstOrDefault(d => d.SNormId == deductsInsEntity.SCNorm_Id);
var sClassifyEntiy = db.IQueryable <ProfileScoreCriteria_ClassifyEntity>().FirstOrDefault(d => d.SClassifyId == sNormEntity.SClassifyId);
var sTypeEntiy = db.IQueryable <ProfileScoreCriteria_TypeEntity>().FirstOrDefault(d => d.STypeId == sClassifyEntiy.STypeId);
var sEntiyEntity = db.IQueryable <ProfileScoreCriteria_EntryEntity>().FirstOrDefault(d => d.SEntryId == sTypeEntiy.SEntryId);
var userEntity = db.IQueryable <UserEntity>().FirstOrDefault(d => d.F_Id == deductsInsEntity.CreatorUserId);
if (sNormEntity == null)
{
throw new Exception("未找到对应扣分标准!");
}
ProfileDeducInsEntity dbDeductIndesEntry = new ProfileDeducInsEntity()
{
DeducIns_Id = Guid.NewGuid().ToString(),
TaskEntry_Id = deductsInsEntity.TaskEntry_Id,
SCNorm_Id = deductsInsEntity.SCNorm_Id,
SCEntryName = sEntiyEntity.Name,
SCTypeName = sTypeEntiy.Name,
SCClassifyName = sClassifyEntiy.SClassifyName,
SCNormProjectName = sNormEntity.SNormProjectName,
SCNormStandardName = sNormEntity.SNormStandardName,
DeductionSeveral = deductsInsEntity.DeductionSeveral,
DeductionScore = deductsInsEntity.DeductionScore,
DeductionDescribe = deductsInsEntity.DeductionDescribe,
CreateTime = DateTime.Now,
CreatorUserId = deductsInsEntity.CreatorUserId,
CreatorUserName = userEntity.F_RealName,
SCNormIsDeduct = sNormEntity.IsDeduct
};
db.Insert <ProfileDeducInsEntity>(dbDeductIndesEntry);
try
{
db.Commit();
return(dbDeductIndesEntry.DeducIns_Id);
}
catch
{
return("-1");
}
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="deducIns_Id">要修改的Id</param>
/// <param name="deductsInsEntity">model</param>
/// <returns></returns>
public string UpdateDeductIns(string deducIns_Id, ApiDeductUploadContracts deductsInsEntity)
{
using (var db = new RepositoryBase().BeginTrans())
{
var UpdateDeductIns = db.FindEntity <ProfileDeducInsEntity>(deducIns_Id);
var sNormEntity = db.IQueryable <ProfileScireCriteria_NormEntity>().FirstOrDefault(d => d.SNormId == deductsInsEntity.SCNorm_Id);
var sClassifyEntiy = db.IQueryable <ProfileScoreCriteria_ClassifyEntity>().FirstOrDefault(d => d.SClassifyId == sNormEntity.SClassifyId);
var sTypeEntiy = db.IQueryable <ProfileScoreCriteria_TypeEntity>().FirstOrDefault(d => d.STypeId == sClassifyEntiy.STypeId);
var sEntiyEntity = db.IQueryable <ProfileScoreCriteria_EntryEntity>().FirstOrDefault(d => d.SEntryId == sTypeEntiy.SEntryId);
var userEntity = db.IQueryable <UserEntity>().FirstOrDefault(d => d.F_Id == deductsInsEntity.CreatorUserId);
if (sNormEntity == null)
{
throw new Exception("未找到对应扣分标准!");
}
UpdateDeductIns.SCNorm_Id = deductsInsEntity.SCNorm_Id;
UpdateDeductIns.SCEntryName = sEntiyEntity.Name;
UpdateDeductIns.SCTypeName = sTypeEntiy.Name;
UpdateDeductIns.SCClassifyName = sClassifyEntiy.SClassifyName;
UpdateDeductIns.SCNormProjectName = sNormEntity.SNormProjectName;
UpdateDeductIns.SCNormStandardName = sNormEntity.SNormStandardName;
UpdateDeductIns.DeductionSeveral = deductsInsEntity.DeductionSeveral;
UpdateDeductIns.DeductionScore = deductsInsEntity.DeductionScore;
UpdateDeductIns.DeductionDescribe = deductsInsEntity.DeductionDescribe;
UpdateDeductIns.LastModifyTime = DateTime.Now;
UpdateDeductIns.LastModifyUserId = deductsInsEntity.CreatorUserId;
UpdateDeductIns.LastModifyUserName = userEntity.F_RealName;
UpdateDeductIns.SCNormIsDeduct = sNormEntity.IsDeduct;
db.Update(UpdateDeductIns);
}
return(deducIns_Id);
}
public bool InsertDeductIns(ApiDeductUploadContracts deductsInsEntity)
{
using (var db = new RepositoryBase().BeginTrans())
{
var sNormEntity = db.IQueryable <ProfileScireCriteria_NormEntity>().FirstOrDefault(d => d.SNormId == deductsInsEntity.SCNorm_Id);
var sClassifyEntiy = db.IQueryable <ProfileScoreCriteria_ClassifyEntity>().FirstOrDefault(d => d.SClassifyId == sNormEntity.SClassifyId);
var sTypeEntiy = db.IQueryable <ProfileScoreCriteria_TypeEntity>().FirstOrDefault(d => d.STypeId == sClassifyEntiy.STypeId);
var sEntiyEntity = db.IQueryable <ProfileScoreCriteria_EntryEntity>().FirstOrDefault(d => d.SEntryId == sTypeEntiy.SEntryId);
var userEntity = db.IQueryable <UserEntity>().FirstOrDefault(d => d.F_Id == deductsInsEntity.CreatorUserId);
if (sNormEntity == null)
{
throw new Exception("未找到对应扣分标准!");
}
if (userEntity == null)
{
throw new Exception("未找到上传用户!");
}
//验证判断还能不能扣分
//查询当前所有的扣分
ProfileDeducInsEntity dbDeductIndesEntry = new ProfileDeducInsEntity()
{
DeducIns_Id = Guid.NewGuid().ToString(),
TaskEntry_Id = deductsInsEntity.TaskEntry_Id,
SCNorm_Id = deductsInsEntity.SCNorm_Id,
SCEntryName = sEntiyEntity.Name,
SCTypeName = sTypeEntiy.Name,
SCClassifyName = sClassifyEntiy.SClassifyName,
SCNormProjectName = sNormEntity.SNormProjectName,
SCNormStandardName = sNormEntity.SNormStandardName,
DeductionSeveral = deductsInsEntity.DeductionSeveral,
DeductionScore = deductsInsEntity.DeductionScore,
DeductionDescribe = deductsInsEntity.DeductionDescribe,
CreateTime = DateTime.Now,
CreatorUserId = deductsInsEntity.CreatorUserId,
CreatorUserName = userEntity.F_RealName,
SCNormIsDeduct = sNormEntity.IsDeduct
};
db.Insert <ProfileDeducInsEntity>(dbDeductIndesEntry);
deductsInsEntity.images = js.Deserialize <string[]>(deductsInsEntity.imagesStr);
//上传图片
if (deductsInsEntity.images != null)
{
string imageId = string.Empty;
string uploadDate = DateTime.Now.ToString("yyyyddMM");
string filePath = string.Empty;
foreach (var item in deductsInsEntity.images)
{
filePath = string.Format(@"{0}\{1}{2}", uploadDate, Guid.NewGuid().ToString(), ".png");
string path = imageFolderPath + filePath;
string directoryPath = Path.GetDirectoryName(path);
Directory.CreateDirectory(directoryPath);
if (!File.Exists(path))
{
byte[] b = Convert.FromBase64String(item);
MemoryStream m = new MemoryStream(b);
using (FileStream fs = File.Open(path, System.IO.FileMode.Create))
{
m.WriteTo(fs);
m.Close();
fs.Close();
}
}
var deduimgEnity = new ProfileDeducImgEntiy()
{
DeducImg_Id = Guid.NewGuid().ToString(),
DeducIns_Id = dbDeductIndesEntry.DeducIns_Id,
DeducImgPath = filePath
};
db.Insert <ProfileDeducImgEntiy>(deduimgEnity);
}
}
try
{
db.Commit();
}
catch
{
return(false);
}
}
return(true);
}
