public async Task <MessageModel <sysUserInfo> > Get(string id)
{
var data = new MessageModel <sysUserInfo>();
if (string.IsNullOrEmpty(id))
{
data.success = false;
data.msg = "用户Id不能为空";
data.status = 404;
return(data);
}
var user = await _sysUserInfoServices.QueryById(id);
if (user == null || user.tdIsDelete)
{
data.success = false;
data.msg = $"不存在Id={id}的用户！";
data.status = 404;
return(data);
}
data.success = true;
data.msg = "获取成功！";
data.status = 200;
data.response = user;
return(data);
}
public async Task <ApiResponseModel <JwtTokenDto> > RefreshToken(string token)
{
if (token.IsNullOrEmpty())
{
return(ApiResponse.Error <JwtTokenDto>("token无效，请重新登录"));
}
var tokenModel = JwtHelper.SerializeJwt(token);
if (tokenModel != null && tokenModel.Uid > 0)
{
var user = await _sysUserInfoServices.QueryById(tokenModel.Uid);
if (user != null)
{
var userRoles = await _sysUserInfoServices.GetUserRoleByUserId(user.uID);
var claims = new List <Claim> {
new Claim(ClaimTypes.Name, user.uLoginName),
new Claim(JwtRegisteredClaimNames.Jti, tokenModel.Uid.ObjToString()),
new Claim(ClaimTypes.Expiration, DateTime.Now.AddSeconds(_requirement.Expiration.TotalSeconds).ToString())
};
claims.AddRange(userRoles.Select(s => new Claim(ClaimTypes.Role, s.Name)));
var identity = new ClaimsIdentity(JwtBearerDefaults.AuthenticationScheme);
identity.AddClaims(claims);
var refreshToken = JwtHelper.BuildJwtToken(claims, _requirement);
return(ApiResponse.Success <JwtTokenDto>(refreshToken));
}
}
return(ApiResponse.Error <JwtTokenDto>("token无效，请重新登录"));
}
public async Task <MessageModel <sysUserInfo> > GetInfoByToken(string token)
{
var data = new MessageModel <sysUserInfo>();
if (!string.IsNullOrEmpty(token))
{
var tokenModel = JwtHelper.SerializeJwt(token);
if (tokenModel != null && tokenModel.Uid > 0)
{
var userinfo = await _sysUserInfoServices.QueryById(tokenModel.Uid);
if (userinfo != null)
{
data.response = userinfo;
data.success = true;
data.msg = "获取成功";
}
}
}
return(data);
}
public async Task <MessageModel <TokenInfoViewModel> > RefreshToken(string token = "")
{
string jwtStr = string.Empty;
if (string.IsNullOrEmpty(token))
{
return(new MessageModel <TokenInfoViewModel>()
{
success = false,
msg = "token无效，请重新登录！",
});
}
var tokenModel = JwtHelper.SerializeJwt(token);
if (tokenModel != null && tokenModel.Uid > 0)
{
var user = await _sysUserInfoServices.QueryById(tokenModel.Uid);
if (user != null)
{
var userRoles = await _sysUserInfoServices.GetUserRoleNameStr(user.uLoginName, user.uLoginPWD);
//如果是基于用户的授权策略，这里要添加用户;如果是基于角色的授权策略，这里要添加角色
var claims = new List <Claim> {
new Claim(ClaimTypes.Name, user.uLoginName),
new Claim(JwtRegisteredClaimNames.Jti, tokenModel.Uid.ObjToString()),
new Claim(ClaimTypes.Expiration, DateTime.Now.AddSeconds(_requirement.Expiration.TotalSeconds).ToString())
};
claims.AddRange(userRoles.Split(',').Select(s => new Claim(ClaimTypes.Role, s)));
//用户标识
var identity = new ClaimsIdentity(JwtBearerDefaults.AuthenticationScheme);
identity.AddClaims(claims);
var refreshToken = JwtToken.BuildJwtToken(claims.ToArray(), _requirement);
return(new MessageModel <TokenInfoViewModel>()
{
success = true,
msg = "获取成功",
response = refreshToken
});
}
}
return(new MessageModel <TokenInfoViewModel>()
{
success = false,
msg = "认证失败！",
});
}
public async Task <MessageModel <PageModel <blogarticle_comments> > > Get(int bid, int page = 1, int intPageSize = 20, bool isRootComment = true)
{
Expression <Func <blogarticle_comments, bool> > whereExpression = a => a.Id > 0 && a.bBlogID == bid && a.isRootComment == isRootComment;
var res = await _blogarticle_commentsServices.QueryPage(whereExpression, page, intPageSize, " CreateTime desc ");
res.data.ForEach(item =>
{
item.Author = _sysUserInfoServices.QueryById(item.CreatorID).Result;
Expression <Func <blogarticle_comments, bool> > whereExpression1 = a => a.Id > 0 && a.ParentID == item.Id;
item.Children = _blogarticle_commentsServices.Query(whereExpression1, intPageSize, " CreateTime desc ").Result;
item.Children.ForEach(obj =>
{
obj.Author = _sysUserInfoServices.QueryById(obj.CreatorID).Result;
obj.CallbackUser = _sysUserInfoServices.QueryById(obj.CallBackTo).Result;
});
});
return(new MessageModel <PageModel <blogarticle_comments> >()
{
msg = "获取成功",
success = true,
response = res
});
}
public async Task <ApiResponseModel <SysUserInfo> > GetInfoByToken(string token)
{
if (token.IsNullOrEmpty())
{
return(ApiResponse.Error <SysUserInfo>("token 不能为空"));
}
var tokenModel = JwtHelper.SerializeJwt(token);
if (tokenModel == null || tokenModel.Uid == 0)
{
return(ApiResponse.Error <SysUserInfo>("token 无效"));
}
var userinfo = await _sysUserInfoServices.QueryById(tokenModel.Uid);
if (userinfo == null)
{
return(ApiResponse.Error <SysUserInfo>("找不到用户"));
}
return(ApiResponse.Success(userinfo));
}
public JObject GetPmInsPectByCode(int iUserId, string iCodeNum)
{
try
{
#region 参数检测
iCodeNum.NotAllowNullOrEmpty("抽查批次号");
int StringLength = iCodeNum.Length;
(iCodeNum.Length <= 4).ThrowException("抽查批次号格式不正确");
string mCode = iCodeNum.Substring(0, StringLength - 4).ToUpper();
string mNum = iCodeNum.Substring(StringLength - 4);
#endregion
#region 获取主表信息
var mPmPlanSubInfo = _dal.GetPmPlanSubByCode(mCode, mNum);
mPmPlanSubInfo.NotAllowNull("未查询到抽查任务单信息");
#endregion
#region 获得任务信息 ****查询NQI_LIMS********
ADD_SUPERVISEPLAN mAddSupervisePlan = null;
mAddSupervisePlan = _AddSuperviserPlanDal.GetSupervisePlanByCode(mCode);
#endregion
#region 获取用户部门信息****查询NQI_LIMS********
var mUserInfo = _SysUserInfoServices.QueryById(iUserId).Result;//用户信息
mUserInfo.addr.NotAllowNullOrEmpty("部门编号");
/*
* 20200801 没有组织架构，后期要增加，
* 临时在adress字段 里面配置用户的部门信息
* 格式： DEPT部门编号RY01
*/
DIVISIONS mDivisions = null;
DEPARTMENTS mDepartments = null;
mDepartments = _DepartmentsDal.GetDepartmentsByCode(mUserInfo.addr);
mDivisions = _DivisionsDal.GetDivisionsByCode(mDepartments.PARENTDIV);
#endregion
#region 任务表
PM_PLAN mPmPlanInfo = null;
if (!string.IsNullOrEmpty(mPmPlanSubInfo.PLAN_CODE))
{
mPmPlanInfo = _dal.GetPmPlanByCode(mPmPlanSubInfo.PLAN_CODE);
}
else
{
throw new MyException("为查询到对应编号的数据。", data: iCodeNum);
}
#endregion
#region 受检单位信息
PM_CARY mPmCaryInfo = null;
if (mPmPlanSubInfo.CARY_ID > 0)
{
mPmCaryInfo = _dal.GetPmCaryById(mPmPlanSubInfo.CARY_ID);
}
#endregion
#region 生产企业信息
PM_PRODUCE_UNIT mPmProduceUnit = null;
if (mPmPlanSubInfo.PRO_ID > 0)
{
mPmProduceUnit = _dal.GetPmProduceUnitById(mPmPlanSubInfo.PRO_ID);
}
#endregion
#region 抽样单位信息
PM_EXEC_UINT mPmExecUintInfo = null;
if (mPmPlanSubInfo.EXEC_ID > 0)
{
mPmExecUintInfo = _dal.GetPmExecUintById(mPmPlanSubInfo.EXEC_ID);
}
#endregion
#region 网店信息
PM_EC_PLATFORM mPmEcPlatFormInfo = null;
if (mPmPlanSubInfo.EC_ID > 0)
{
mPmEcPlatFormInfo = _dal.GetPmEcPlatFormById(mPmPlanSubInfo.EC_ID);
}
#endregion
#region 组装数据
return(new JObject()
{
{ "ID", mPmPlanSubInfo.ID },
{ "PLAN_CODE", mPmPlanSubInfo.PLAN_CODE },
{ "LOT_NUM", mPmPlanSubInfo.LOT_NUM },
//任务信息
{ "SupervisePlanInfo", JObject.Parse(JsonConvert.SerializeObject(mAddSupervisePlan)) },
//部门信息
{ "Department", JObject.Parse(JsonConvert.SerializeObject(mDepartments)) },
//中心信息
{ "Division", JObject.Parse(JsonConvert.SerializeObject(mDivisions)) },
//抽检数据库的相关表格：
{ "PmPlanSubInfo", JObject.Parse(JsonConvert.SerializeObject(mPmPlanSubInfo)) },
{ "PmPlanInfo", mPmPlanInfo != null?JObject.Parse(JsonConvert.SerializeObject(mPmPlanInfo)) : new JObject() },
{ "PmCaryInfo", mPmCaryInfo != null?JObject.Parse(JsonConvert.SerializeObject(mPmCaryInfo)) : new JObject() },
{ "PmProduceUnit", mPmProduceUnit != null?JObject.Parse(JsonConvert.SerializeObject(mPmProduceUnit)) : new JObject() },
{ "PmExecUintInfo", mPmExecUintInfo != null?JObject.Parse(JsonConvert.SerializeObject(mPmExecUintInfo)) : new JObject() },
{ "PmEcPlatFormInfo", mPmEcPlatFormInfo != null?JObject.Parse(JsonConvert.SerializeObject(mPmEcPlatFormInfo)) : new JObject() },
});
#endregion
}
catch (Exception ex)
{
SerilogServer.WriteErrorLog("GetPmInsPectByCode", ex.Message, ex);
throw ex;
}
}
public bool SaveInspectAcceptance(int iUserId, InputInsepectAcceptanceModel model)
{
try
{
model.PmPlanSubInfo.NotAllowNull("抽检信息");
#region 获取用户信息
var mUserInfo = _SysUserInfoServices.QueryById(iUserId).Result;//用户信息
#endregion
_UnitOfWork.BeginTran();
#region 查询或保存企业
// CHECK_TYPE : 1:现场抽样(生产) 2:市场买样 3：电商买样 4：其他来源
//生产单位
RASCLIENTS mScdwInfor = null;
if (model.PmPlanSubInfo.CHECK_TYPE == "1")
{
mScdwInfor = this.SaveRaseClient(model.PmProduceUnit.PRO_NAME, model.PmProduceUnit.PRO_ADDR, model.PmProduceUnit.PRO_TEL, mUserInfo.uRealName, model.Department.DEPTNAME, model.PmProduceUnit.PRO_BUS_LICENCE, model.Department.DEPT);
}
//受检单位
RASCLIENTS mSjdwInfor = null;
if (model.PmPlanSubInfo.CHECK_TYPE == "2")
{
mSjdwInfor = this.SaveRaseClient(model.PmCaryInfo.CARY_NAME, model.PmCaryInfo.CARY_ADDR, model.PmCaryInfo.CARY_TEL, mUserInfo.uRealName, model.Department.DEPTNAME, model.PmCaryInfo.UNIFIED_SOCIAL_CREDIT_CODE, model.Department.DEPT);
}
else if (model.PmPlanSubInfo.CHECK_TYPE == "3")
{
//网店信息
mSjdwInfor = this.SaveRaseClient(model.PmEcPlatFormInfo.ONLINE_STORE_NAME, model.PmEcPlatFormInfo.ONLINE_STORE_ADDR, model.PmEcPlatFormInfo.ONLINE_STORE_CONTACT, mUserInfo.uRealName, model.Department.DEPTNAME, "", model.Department.DEPT);
}
#endregion
#region 1. 受理单
FOLDERS folders = new FOLDERS();
folders.FOLDERNO = this.CreateFolderNo();//生成规则
folders.DEPT = model.Department.DEPT;
folders.REMARKS = model.PmPlanSubInfo.REMARKS;
folders.ORIGSTS = "N";
folders.FLDSTS = "Draft";
folders.DISPSTS = "新建";
folders.SAMPLECLASSFORCCC = "3C样品种类名称";
folders.CODEOFINSPECTIONORG = "承检机构代码";
folders.DETECTIONFORSPOTCHECK = model.SupervisePlanInfo.TASKCLASS;
folders.TESTORGREGFORM = model.Department.DEPTNAME;
folders.TESTPLACE = model.Department.LOCATION;
folders.TESTTYPE = "01";
folders.PLANNO = model.SupervisePlanInfo.PLANNO;
folders.TASKSOURCE = model.SupervisePlanInfo.TASKSOURCE;
folders.TESTTASKNOFORCCC = "委托单位协议编号";
//生产单位
folders.COMPANYNOOFPRODUCTIONORG = mScdwInfor == null ? null : mScdwInfor.RASCLIENTID;
folders.ADDRESSOFPRODUCTIONORG = mScdwInfor == null ? null : mScdwInfor.ADDRESS;
folders.PHONEOFPRODUCTIONORG = mScdwInfor == null ? null : mScdwInfor.PHONE;
folders.NAMEOFPRODUCTIONORG = mScdwInfor == null ? null : mScdwInfor.COMPNAME;
folders.PRODUCTIONOFBUSINESSLICENSE = mScdwInfor == null ? null : mScdwInfor.STAXCODE;
//受检单位
folders.ADDRESSOFORGBETESTED = mSjdwInfor == null? null: mSjdwInfor.ADRESS;
folders.PHONEOFORGBETESTED = mSjdwInfor == null ? null : mSjdwInfor.PHONE;
folders.NAMEOFORGBETESTED = mSjdwInfor == null ? null : mSjdwInfor.COMPNAME;
folders.ACCEPTER = mUserInfo.uRealName;
folders.ACCEPTDATE = DateTime.Now;
//委托单位
folders.NAMEOFENTRUSTORG = model.SupervisePlanInfo.TASKSOURCE;
folders.SAMPLESOURCEREGFORM = "抽样";
folders.DIVISIONCODE = model.Division.DIVISIONCODE;
folders.PAYSTS = "N";
folders.LOGDATE = DateTime.Now;
folders.ISSUBCONTRACT = "不同意";
folders.ISSUPPLIER = "N";
folders.CREATER = mUserInfo.uLoginName;
folders.EVALUATIONREQ = "评价";
var IsFolderExist = _FoldersDal.GeyFolderByNo(folders.FOLDERNO) != null ? true : false;
if (!IsFolderExist)
{
_FoldersDal.SaveFolders(folders);
}
else
{
return(false);
}
#endregion
#region 2. 样品单
PREORDERS preoders = new PREORDERS();
preoders.PREORDNO = this.CreatPreOrderNo("");//获取部门编号信息
preoders.FOLDERNO = folders.FOLDERNO;
preoders.STATUS = "Draft";
preoders.DISPSTS = "新建";
preoders.REMARKS = model.PmPlanSubInfo.REMARKS;
preoders.TESTCOSTSFORSAMPLE = 0;
preoders.TAKEREPORTMETHOD = "自取";
preoders.RECEIVEDATE = DateTime.Today;
preoders.STORAGEMETHOD = "常温";
preoders.TREATMENTFORSAMPLE = "销毁";
preoders.ARRIVDATEFORSAMPLE = DateTime.Today;
preoders.SPECMODEL = model.PmPlanSubInfo.GOODS_SCALE;
preoders.SAMPLENAME = model.PmPlanSubInfo.GOODS_NAME;
preoders.TOTALQUANTITY = model.PmPlanSubInfo.GOODS_CHECK_NUM;
preoders.SAMPLESTATE = "封样完好、符合检验要求";
preoders.REQUIREDCOMPLETIONDATE = DateTime.Today.AddDays(7);
preoders.DEPT = model.Department.DEPT;
preoders.DIVISIONCODE = model.Division.DIVISIONCODE;
preoders.ISRETURNSAMPLE = "N";
preoders.ISEMERGENCY = "0";
preoders.PAYSTS = "未缴费";
preoders.LOGDATE = DateTime.Now;
preoders.ISMAKESAMPLE = "N";
preoders.ISADD_G = "N";
preoders.INVOICEISSUEMETHOD = "自取";
preoders.TAKESAMPLINGPERSON = mUserInfo.uRealName;
preoders.STORAGECONDITION = 0;
preoders.OTHERSAMPLETYPE = 0;
preoders.OTHERRESTAURANTTACHE = 0;
preoders.OTHERCIRCULATIONTACHE = 0;
preoders.STRIPNUMBERANDSUM = 0;
preoders.SAMPLINGPRODUCTIMPLEMENTATION = "按文件要求";
preoders.SAMPLEDELIVERYMODE = "抽样";
preoders.REPORTRECYCLE = "Y";
preoders.SELFNUMBER = model.PmPlanSubInfo.PLAN_CODE + model.PmPlanSubInfo.LOT_NUM;
preoders.PRINTNUM = 0;
preoders.ZHENGSHUNO = model.PmPlanSubInfo.GOODS_CERT_CODE;
preoders.ISADD_FG = "N";
preoders.ALLOTTYPE = "CP";
preoders.PRINTBYNUMS = 0;
preoders.PRINTJYNUMS = 1;
preoders.ISNEEDCOVERING = "N";
preoders.TESTPERIOD = 7;
preoders.REALPAY2 = 0;
var IsPreExist = _PreOrdersDal.GetPreOrdersByNo(preoders.PREORDNO) != null ? true : false;
if (!IsPreExist)
{
_PreOrdersDal.SavePreOrders(preoders);
}
#endregion
#region 3. 子样单
ORDERS orders = new ORDERS();
orders.ORDNO = string.Format("{0}-001", preoders.PREORDNO);
orders.ORIGSTS = "N";
orders.STATUS = "Draft";
orders.DISPSTS = "新建";
orders.CREATETIME = DateTime.Now;
orders.SAMPLENAME = model.PmPlanSubInfo.GOODS_NAME;
orders.DEPT = model.Department.DEPT;
orders.DIVISIONCODE = model.Division.DIVISIONCODE;
orders.ISMAKESAMPLE = "N";
orders.ISPREPARE = "N";
orders.ISCHOICE = "N";
orders.FOLDERNO = folders.FOLDERNO;
orders.MAJORUSRNAM = mUserInfo.uLoginName;
orders.PREORDNO = preoders.PREORDNO;
var IsOrderExist = _OrderDal.GetOrdersByNo(orders.ORDNO) != null ? true : false;
if (!IsOrderExist)
{
_OrderDal.SaveOrders(orders);
}
#endregion
_UnitOfWork.CommitTran();
return(true);
}
catch (Exception ex)
{
_UnitOfWork.RollbackTran();
SerilogServer.WriteErrorLog("SaveInspectAcceptance", ex.Message, ex);
throw ex;
}
}