/// <summary>
/// 更新支付历史
/// </summary>
/// <param name="paymentHistoryInfo">实体信息</param>
/// <returns>返回成功与否</returns>
public bool UpdatePaymentHistory(Business_Personnel_Information personInfo, Business_PaymentHistory_Information paymentHistoryInfo, Business_PaymentHistory_Information paymentHistoryInfoOld)
{
using (var db = SugarDao_MsSql.GetInstance())
{
db.BeginTran();
try
{
var configInfo = db.Queryable <Master_Configuration>().Where(i => i.ID == 15).SingleOrDefault();
paymentHistoryInfo.CreateDate = paymentHistoryInfoOld.CreateDate;
paymentHistoryInfo.CreateUser = paymentHistoryInfoOld.CreateUser;
paymentHistoryInfo.ChangeDate = DateTime.Now;
paymentHistoryInfo.ChangeUser = "******";
//插入操作日志表中
string logData = JsonHelper.ModelToJson(paymentHistoryInfo);
_logLogic.SaveLog(18, 46, personInfo.UserID + " " + personInfo.Name, "大众出租租赁营收费用", logData);
int revenueStauts = 2;
if (paymentHistoryInfo.PaymentStatus == "1")
{
paymentHistoryInfo.PaymentAmount = paymentHistoryInfoOld.PaymentAmount;
paymentHistoryInfo.RevenueReceivable = paymentHistoryInfoOld.RevenueReceivable;
}
paymentHistoryInfo.RevenueStatus = revenueStauts;
db.DisableUpdateColumns = new[] { "RevenueType", "WeChatPush_VGUID" };
db.Update <Business_PaymentHistory_Information>(paymentHistoryInfo, i => i.Remarks == paymentHistoryInfoOld.Remarks);
db.CommitTran();
return(true);
}
catch (Exception ex)
{
LogHelper.WriteLog(ex.ToString());
db.RollbackTran();
return(false);
}
}
}
public ActionResult Index(string code)
{
U_WeChatUserID userInfo = new U_WeChatUserID();
string accessToken = Common.WeChatPush.WeChatTools.GetAccessoken();
string userInfoStr = Common.WeChatPush.WeChatTools.GetUserInfoByCode(accessToken, code);
userInfo = Common.JsonHelper.JsonToModel <U_WeChatUserID>(userInfoStr);//用户ID
//userInfo.UserId = "13524338060";
DateTime currentDate = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd"));
Business_Personnel_Information personInfoModel = _logic.GetUserInfo(userInfo.UserId);
//Business_VehicleRepairComplaints vrc = _bvrc.GetVehicleRepairComplaint(userInfo.UserId, currentDate);
Business_VehicleRepairComplaints vrc = null;
if (vrc == null)
{
vrc = new Business_VehicleRepairComplaints();
vrc.ReflectJobNumber = personInfoModel.JobNumber;
//vrc.CarNumber = personInfoModel.LicensePlate;
vrc.ContactNumber = personInfoModel.PhoneNumber;
vrc.ReflectName = personInfoModel != null ? personInfoModel.Name : "";
vrc.ReflectDate = currentDate;
vrc.CreateUser = userInfo.UserId;
}
return(View(vrc));
}
/// <summary>
/// 获取司机的服务号、车牌号以及公司代码
/// </summary>
/// <param name="personInfo"></param>
/// <returns></returns>
public U_DriverInfo GetDriverInfo(Business_Personnel_Information personInfo)
{
U_DriverInfo uDriverInfo = null;
using (var dbDriver = SugarDao_DriverRevenueSql.GetInstance())
{
var driverInfo = dbDriver.Queryable <Driver>().Where(i => i.IdCard == personInfo.IDNumber && i.Status == 1).SingleOrDefault();
if (driverInfo == null || driverInfo.CabID == null)
{
return(new U_DriverInfo());
}
var cabInfo = dbDriver.Queryable <Cab>().Where(i => i.Id == driverInfo.CabID).SingleOrDefault();
if (cabInfo == null || cabInfo.License == null)
{
return(new U_DriverInfo());
}
var organizationInfo = dbDriver.Queryable <Organization>().Where(i => i.ID == driverInfo.OrganizationID).SingleOrDefault();
uDriverInfo = new U_DriverInfo
{
OperationNo = driverInfo.OperationNo,
License = cabInfo.License,
UnitCode = organizationInfo.UnitCode
};
}
return(uDriverInfo);
}
public ActionResult Index(string code)
{
string accessToken = WeChatTools.GetAccessoken();
U_WeChatUserID userInfo = new U_WeChatUserID();
string userInfoStr = WeChatTools.GetUserInfoByCode(accessToken, code);
userInfo = Common.JsonHelper.JsonToModel <U_WeChatUserID>(userInfoStr);//用户ID
//userInfo.UserId = "13671595340";//合伙人
//userInfo.UserId = "18936495119";//司机
Business_Personnel_Information personInfoModel = GetUserInfo(userInfo.UserId);//获取人员表信息
var key = PubGet.GetUserKey + personInfoModel.Vguid;
var csche = CacheManager <Business_Personnel_Information> .GetInstance().Get(key);
if (csche != null)
{
CacheManager <Business_Personnel_Information> .GetInstance().Remove(key);
}
CacheManager <Business_Personnel_Information> .GetInstance().Add(key, personInfoModel, 8 * 60 * 60 * 1000);
ViewBag.UserVGUID = personInfoModel.Vguid;
ViewBag.UserID = userInfo.UserId;
ViewBag.PhoneNumber = personInfoModel.PhoneNumber;
ViewBag.Key = "lZagKrU56xPBvyNRZjym7jrdJPwOT1Z0W+HpZaTrvUobpwSQEAue7j0iWs/b0cu2";
return(View());
}
public ActionResult Index(string code)
{
U_WeChatUserID userInfo = new U_WeChatUserID();
string accessToken = Common.WeChatPush.WeChatTools.GetAccessoken();
string userInfoStr = Common.WeChatPush.WeChatTools.GetUserInfoByCode(accessToken, code);
userInfo = Common.JsonHelper.JsonToModel <U_WeChatUserID>(userInfoStr);//用户ID
//userInfo.UserId = "18936495119";
Business_Personnel_Information personInfoModel = _logic.GetUserInfo(userInfo.UserId);
Personnel_Info Personnel = getPersonnelInfo(personInfoModel);
Master_Organization organizationDetail = new Master_Organization();
organizationDetail = _ol.GetOrganizationDetail(personInfoModel.OwnedFleet.ToString());
Business_HomecomingSurvey bhs = _hsl.GetHomecomingSurvey(userInfo.UserId, DateTime.Now.Year.ToString());
if (bhs == null)
{
bhs = new Business_HomecomingSurvey();
bhs.Name = personInfoModel != null ? personInfoModel.Name : "";
bhs.Year = DateTime.Now.Year.ToString();
bhs.CreatedUser = userInfo.UserId;
}
bhs.OrganizationName = organizationDetail.OrganizationName;
if (Personnel != null)
{
bhs.Fleet = Personnel.MotorcadeName;
bhs.LicensePlate = Personnel.CabLicense;
}
return(View(bhs));
}
public void getPartnerInfo(Business_Personnel_Information personInfoModel)
{
Master_Organization organizationDetail = new Master_Organization();
organizationDetail = _ol.GetOrganizationDetail(personInfoModel.OwnedFleet.ToString());
var ownedCompany = personInfoModel.OwnedCompany;
if (ownedCompany == "全部")
{
ownedCompany = getAllOwnedCompany(organizationDetail.Description, "11");
}
Personnel_Info Personnel = new Personnel_Info();
Personnel.IdCard = personInfoModel.IDNumber;
Personnel.OldMotorcadeName = personInfoModel.OwnedFleet; //公司
Personnel.OldOrganization = ownedCompany; //车队
Personnel.Organization = organizationDetail.Description;
//Personnel.Organization = "第一服务中心";
Personnel.MotorcadeName = ownedCompany;//车队
var key = PubGet.GetUserKey + personInfoModel.Vguid + "K";
var csche = CacheManager <Personnel_Info> .GetInstance().Get(key);
if (csche != null)
{
CacheManager <Personnel_Info> .GetInstance().Remove(key);
}
CacheManager <Personnel_Info> .GetInstance().Add(key, Personnel, 8 * 60 * 60 * 1000);
var newfleet = Personnel.MotorcadeName;//现车队
ViewBag.MotorcadeName = newfleet;
//ViewBag.Date = getTaxiSummary();
ViewBag.Validate = true;
ViewBag.Code = personInfoModel.Vguid;
}
/// <summary>
/// 获取人员详细信息
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public Business_Personnel_Information GetUserInfo(string userID)
{
Business_Personnel_Information personModel = new Business_Personnel_Information();
personModel = _wl.GetUserInfo(userID);
return(personModel);
}
/// <summary>
/// 获取人员姓名以及工号
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public Business_Personnel_Information GetUserNameAndJobNum(string userID)
{
Business_Personnel_Information personModel = new Business_Personnel_Information();
personModel = _sl.GetUserNameAndJobNum(userID);
return(personModel);
}
/// <summary>
/// 获取司机ID和车辆ID
/// </summary>
/// <param name="personModel"></param>
/// <returns></returns>
public Driver GetDriverMsg(Business_Personnel_Information personModel)
{
Driver driverModel = new Driver();
driverModel = _sl.GetDriverMsg(personModel);
return(driverModel);
}
/// <summary>
/// 判断营收信息是否是0
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public bool isRevenueZero(string userID)
{
bool result = false;
//获取人员姓名和工号
Business_Personnel_Information personModel = new Business_Personnel_Information();
personModel = GetUserNameAndJobNum(userID);
if (personModel.DepartmenManager == 1)
{
//获取司机ID和车辆ID
Driver driverModel = new Driver();
driverModel = GetDriverMsg(personModel);
//获取营收信息
API_PaymentMonthly paymentModel = new API_PaymentMonthly();
paymentModel = GetRevenueAPI_PaymentMonthlyData(driverModel);
if (paymentModel == null)
{
result = true;
}
else if (paymentModel.DebtAmount == 0 && paymentModel.DueAmount == 0 && paymentModel.PaidAmount == 0)
{
result = true;
}
}
return(result);
}
public ActionResult Index(string code)
{
U_WeChatUserID userInfo = new U_WeChatUserID();
string accessToken = Common.WeChatPush.WeChatTools.GetAccessoken();
string userInfoStr = Common.WeChatPush.WeChatTools.GetUserInfoByCode(accessToken, code);
userInfo = Common.JsonHelper.JsonToModel <U_WeChatUserID>(userInfoStr);//用户ID
//userInfo.UserId = "18936495119";
Business_Personnel_Information personInfoModel = _logic.GetUserInfo(userInfo.UserId);
Personnel_Info Personnel = getPersonnelInfo(personInfoModel);
Master_Organization organizationDetail = new Master_Organization();
organizationDetail = _ol.GetOrganizationDetail(personInfoModel.OwnedFleet.ToString());
Business_SurveyVaccination bsv = GetSurveyVaccination(userInfo.UserId);
if (bsv == null)
{
bsv = new Business_SurveyVaccination();
bsv.Name = personInfoModel != null ? personInfoModel.Name : "";
bsv.UserID = userInfo.UserId;
}
//if (Personnel != null)
//{
// bhs.Fleet = Personnel.MotorcadeName;
// bhs.LicensePlate = Personnel.CabLicense;
//}
return(View(bsv));
}
/// <summary>
/// 重新生成二维码
/// </summary>
public string ReGenerate()
{
try
{
var personInfoModel = new Business_Personnel_Information()
{
Vguid = Guid.Parse("726B4C9F-0B5A-4D5B-A8EE-5BA95C38C4C7")
};
// var personInfoModel = CurrentUser.GetCurrentUser();
string filename = personInfoModel.Vguid + ".jpg";
string url = "/UploadFile/QRCode";
string filePath = Server.MapPath(url + "/" + filename);
System.IO.File.Delete(filePath);
var configStr = _codeGenerateLogic.GetPersonConfiguration(personInfoModel);
var img = Create_ImgCode(configStr, personInfoModel.Vguid.ToString());
MemoryStream ms = new MemoryStream();
img.Save(ms, ImageFormat.Jpeg);
byte[] arr = new byte[ms.Length];
ms.Position = 0;
ms.Read(arr, 0, (int)ms.Length);
ms.Close();
return(Convert.ToBase64String(arr));
}
catch (Exception ex)
{
LogHelper.WriteLog(ex.ToString());
return("0");
}
}
/// <summary>
/// 根据具体人员替换二维码生成配置中具体的参数
/// </summary>
/// <param name="personnelInfo"></param>
/// <returns></returns>
public string GetPersonConfiguration(Business_Personnel_Information personnelInfo, string sysConfigId)
{
using (var db = SugarDao_MsSql.GetInstance())
{
var configurations = db.Queryable <Master_Configuration>().Where(i => i.CreateUser == "QRCode" && i.ModifyUser == sysConfigId).OrderBy(i => i.ID).ToList();
var configParas = new List <string>();
foreach (var configuration in configurations)
{
string configStr = string.Empty;
Match match = Regex.Match(configuration.ConfigDescription, "{DB:(.+)}");
if (match.Groups[1].Value == "")
{
configStr = string.Format("{0}={1}", configuration.ConfigValue, configuration.ConfigDescription);
}
else
{
var configParam = db.SqlQuery <string>(string.Format("select {0} from v_Business_PersonnelDepartmentDetail_Information where Vguid=@vguid", match.Groups[1].Value), new { vguid = personnelInfo.Vguid }).SingleOrDefault();
if (configParam != null)
{
configStr = string.Format("{0}={1}", configuration.ConfigValue, configParam);
}
}
configParas.Add(configStr);
}
return(string.Join("&", configParas));
}
}
public ActionResult History(string code)
{
string accessToken = Common.WeChatPush.WeChatTools.GetAccessoken();
string userInfoStr = Common.WeChatPush.WeChatTools.GetUserInfoByCode(accessToken, code);
var userInfo = Common.JsonHelper.JsonToModel <U_WeChatUserID>(userInfoStr); //用户ID
Business_Personnel_Information personInfoModel = _wl.GetUserInfo(userInfo.UserId); //获取人员表信息
ViewBag.PersonInfo = personInfoModel;
return(View());
}
/// <summary>
/// 根据配置的系统参数结合具体人员形成最后的url地址加参数的形式
/// </summary>
/// <param name="personnelInfo"></param>
/// <returns></returns>
public string GetSysConfiguration(Business_Personnel_Information personnelInfo)
{
using (var db = SugarDao_MsSql.GetInstance())
{
var configurations = db.Queryable <Master_Configuration>().Where(i => i.CreateUser == "QRCode" && i.ModifyUser == null).OrderBy(i => i.ID).ToList();
string symbol = ConfigSugar.GetAppString("Symbol") ?? "^";
var configParas = configurations.Select(configuration => configuration.ConfigValue + symbol + configuration.ConfigDescription.Trim() + "?" + GetPersonConfiguration(personnelInfo, configuration.ID.ToString())).ToList();
return(string.Join("|", configParas));
}
}
public Business_Personnel_Information GetPersonByPhoneNumber(string phoneNumber)
{
Business_Personnel_Information user = null;
using (SqlSugarClient dbMsSql = SugarDao_MsSql.GetInstance())
{
user = dbMsSql.Queryable <Business_Personnel_Information>().Where(i => i.PhoneNumber == phoneNumber && i.UserID != "" && i.UserID != null).SingleOrDefault();
}
return(user);
}
public Business_Personnel_Information GetPerson(string idNumber)
{
Business_Personnel_Information user = null;
using (SqlSugarClient dbMsSql = SugarDao_MsSql.GetInstance())
{
user = dbMsSql.Queryable <Business_Personnel_Information>().Where(i => i.IDNumber == idNumber).SingleOrDefault();
}
return(user);
}
private void InsertMyRights(SqlSugarClient _db, Business_EquityAllocation equity, string PushObject)
{
List <Business_MyRights> myRightsList = new List <Business_MyRights>();
string[] userID = null;
var userData = _db.SqlQuery <Business_Personnel_Information>(@"select * from Business_Personnel_Information where DepartmenManager in ('1','2','3')").ToList();
if (PushObject.Contains("-"))
{
//部门
Guid pushObject = Guid.Parse(PushObject);
userData = userData.Where(x => x.OwnedFleet == pushObject).ToList();
}
else if (PushObject.Contains("|") || !PushObject.Contains("-"))
{
//一个或多人司机
List <Business_Personnel_Information> newDataLsit = new List <Business_Personnel_Information>();
userID = PushObject.Split(new char[1] {
'|'
});
foreach (var item in userID)
{
Business_Personnel_Information newData = new Business_Personnel_Information();
newData = userData.Where(x => x.UserID == item).FirstOrDefault();
newDataLsit.Add(newData);
}
userData = newDataLsit;
}
if (equity.ValidType == "周期")
{
getPeriodDate(equity, equity.Period);
}
foreach (var item in userData)
{
Business_MyRights myRights = new Business_MyRights();
myRights.RightsName = equity.RightsName;
myRights.Description = equity.Description;
myRights.Type = equity.Type;
myRights.StartValidity = equity.StartValidity;
myRights.EndValidity = equity.EndValidity;
myRights.UsageTime = null;
myRights.UserVGUID = item.Vguid.ToString();
myRights.Status = "草稿";
myRights.CreatedUser = CurrentUser.GetCurrentUser().LoginName;
myRights.CreatedDate = DateTime.Now;
myRights.ChangeDate = DateTime.Now;
myRights.ChangeUser = CurrentUser.GetCurrentUser().LoginName;
myRights.EquityVGUID = equity.VGUID.ToString();
myRights.VGUID = Guid.NewGuid();
myRightsList.Add(myRights);
}
_db.InsertRange(myRightsList, false);
}
public DriverInfo getDriverInfo(Business_Personnel_Information personInfoModel)
{
DriverInfo pi = new DriverInfo();
using (SqlSugarClient _dbMsSql = SugarDao_MsSql.GetInstance2())
{
pi = _dbMsSql.SqlQuery <DriverInfo>(@"select DriverId,OrganizationId from [DZ_DW].[dbo].[Visionet_DriverInfo_View] where IdCard=@IDNumber
and status='1'"
, new { IDNumber = personInfoModel.IDNumber }).ToList().FirstOrDefault();
}
return(pi);
}
public Personnel_Info getPersonnelInfo(Business_Personnel_Information personInfoModel)
{
Personnel_Info pi = new Personnel_Info();
using (SqlSugarClient _dbMsSql = SugarDao_MsSql.GetInstance2())
{
pi = _dbMsSql.SqlQuery <Personnel_Info>(@"select Name,IdCard,CabLicense,CabVMLicense,MotorcadeName,Organization from [DZ_DW].[dbo].[Visionet_DriverInfo_View] where IdCard=@IDNumber
and status='1'"
, new { IDNumber = personInfoModel.IDNumber }).ToList().FirstOrDefault();
}
return(pi);
}
public ActionResult Index(string code)
{
bool isValid = false;
string vguidStr = Request.QueryString["questionVguid"];
string pushContentVguid = string.Empty;
string questionVguid = vguidStr.Split(',')[0]; //"A5EF3FB4-96E7-4DF3-9BDD-1D172D338149";
var effectiveDate = _wl.GetQuestionInfo(questionVguid).EffectiveDate;
if (effectiveDate < DateTime.Now)
{
isValid = true;
}
ViewData["isValid"] = isValid;
string wechatMain = string.Empty;
ViewData["isHistory"] = "0";
if (vguidStr.Split(',').Count() == 2)
{
pushContentVguid = vguidStr.Split(',')[1];//Request.QueryString["pushContentVguid"];
ViewData["isHistory"] = "0";
}
else if (vguidStr.Split(',').Count() == 3)
{
ViewData["isHistory"] = "1"; //从消息历史界面跳转而来
wechatMain = vguidStr.Split(',')[2];
}
string accessToken = Common.WeChatPush.WeChatTools.GetAccessoken();
U_WeChatUserID userInfo = new U_WeChatUserID();
string userInfoStr = Common.WeChatPush.WeChatTools.GetUserInfoByCode(accessToken, code);
userInfo = Common.JsonHelper.JsonToModel <U_WeChatUserID>(userInfoStr);//用户ID
string userid = userInfo.UserId;
//string userid = "WangCunBiao";
string answerCount = _wl.GetAnswerCount();
//8f3d8ccc-82d9-4a76-b0c7-2dc585d86b64
//userInfo.UserId = "13774418547";
Business_Personnel_Information personInfoModel = GetUserInfo(userid);//获取人员表信息
bool isRead = false;
if (pushContentVguid != string.Empty)
{
isRead = UpdateIsRead(pushContentVguid, userid);//更新是否查看推送
}
ViewData["wechatMain"] = wechatMain;
ViewBag.answerCount = answerCount;
ViewBag.pushContentVguid = pushContentVguid;
ViewBag.questionVguid = questionVguid;
ViewBag.PersonInfo = personInfoModel;
ViewBag.code = code;
return(View());
}
/// <summary>
/// 获取正式知识库的列表信息
/// </summary>
/// <param name="pageIndex">当前页</param>
/// <param name="personVguid">浏览人主键</param>
/// <returns></returns>
public List <V_Business_KnowledgeBase_Information> GetKnowledgeList(int pageIndex, Guid personVguid, string type = "1")
{
using (var db = SugarDao_MsSql.GetInstance())
{
Business_Personnel_Information personInfo = new Business_Personnel_Information();
personInfo = db.Queryable <Business_Personnel_Information>().Where(i => i.Vguid == personVguid).SingleOrDefault();
var query = db.Queryable <V_Business_KnowledgeBase_Information>().Where(i => i.Status == "2" && i.Type == type).Select("Title,CreatedDate,Vguid");
query.OrderBy("CreatedDate desc");
var list = query.ToPageList(pageIndex, 10);
//存入操作日志表
string logData = JsonHelper.ModelToJson(list);
_ll.SaveLog(3, 43, personInfo.ID + personInfo.Name, "正式列表", logData);
return(list);
}
}
/// <summary>
/// 保存用户信息至Person表
/// </summary>
/// <param name="personInfo"></param>
/// <returns></returns>
public bool SavePersonInfo(Business_Personnel_Information personInfo)
{
using (SqlSugarClient _dbMsSql = SugarDao.SugarDao_MsSql.GetInstance())
{
bool result = false;
try
{
_dbMsSql.BeginTran();
_dbMsSql.DisableInsertColumns = new[] { "TranslationOwnedFleet" };
Business_Personnel_Information personInfoDetail = new Business_Personnel_Information();
personInfoDetail = _dbMsSql.Queryable <Business_Personnel_Information>().Where(i => i.IDNumber == personInfo.IDNumber).SingleOrDefault();
if (personInfoDetail != null)//更新
{
var model = new
{
UserID = personInfo.UserID,
IDNumber = personInfo.IDNumber,
Name = personInfo.Name,
Age = personInfo.Age,
Sex = personInfo.Sex,
ID = personInfo.ID,
JobNumber = personInfo.JobNumber,
ServiceNumber = personInfo.ServiceNumber,
OwnedFleet = personInfo.OwnedFleet,
LicensePlate = personInfo.LicensePlate,
PhoneNumber = personInfo.PhoneNumber,
DepartmenManager = personInfo.DepartmenManager,
ChangeDate = DateTime.Now
};
result = _dbMsSql.Update <Business_Personnel_Information>(model, i => i.Vguid == personInfoDetail.Vguid);
}
else//新增
{
var rtn = _dbMsSql.Insert(personInfo);
if (rtn != null && rtn.ToString() == "true")
{
result = true;
}
}
}
catch (Exception ex)
{
_dbMsSql.RollbackTran();
Common.LogHelper.LogHelper.WriteLog("注册时保存用户信息" + ex.ToString());
}
return(result);
}
}
/// <summary>
/// 获取用户详细信息
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public Business_Personnel_Information GetUserInfo(string userID)
{
using (SqlSugarClient dbMsSql = SugarDao_MsSql.GetInstance())
{
Business_Personnel_Information personModel = new Business_Personnel_Information();
try
{
personModel = dbMsSql.Queryable <Business_Personnel_Information>().Where(i => i.UserID == userID).SingleOrDefault();
}
catch (Exception ex)
{
LogHelper.WriteLog(ex.Message);
_ll.SaveLog(5, 34, "", userID + personModel.Name, ex.Message);
}
return(personModel);
}
}
/// <summary>
/// 根据人员信息获取营收信息
/// </summary>
/// <param name="personModel"></param>
/// <returns></returns>
public U_Revenue GetRevenueMsgByPersonInfo(Business_Personnel_Information personModel)
{
//获取司机ID和车辆ID
var driverModel = _rl.GetDriverMsg(personModel);
//driverModel.OrganizationID = 55;
//driverModel.Id = 21033;
//获取营收信息
var paymentModel = _rl.GetRevenueAPI_PaymentMonthlyData(driverModel);
U_Revenue revenue = new U_Revenue();
if (paymentModel == null)
{
revenue.HistoricalArrears = "0";
revenue.TheBalance = "0";
revenue.AmountDue = "0";
revenue.CurrentPayment = "0";
revenue.CurrentAccountBalance = "0";
}
else
{
//revenue.TheBalance = (paymentModel.DebtAmount * -1).ToString("F2"); //上期结余
//revenue.HistoricalArrears = (paymentModel.DebtAmount * -1) >= 0 ? "0.00" : paymentModel.DebtAmount.ToString("F2"); //历史欠款
//revenue.AmountDue = paymentModel.DueAmount.ToString("F2"); //应缴金额
//revenue.CurrentPayment = paymentModel.PaidAmount.ToString("F2"); //本期缴款
//revenue.CurrentAccountBalance = (paymentModel.PaidAmount - paymentModel.DueAmount + (paymentModel.DebtAmount * -1)).ToString("F2"); //本期结余
revenue.HistoricalArrears = "0";
revenue.TheBalance = paymentModel.DebtAmount.ToString("F2"); //历史欠款
//revenue.TheBalance = paymentModel.DebtAmount.ToString("F2");
revenue.AmountDue = paymentModel.DueAmount.ToString("F2"); //应缴金额
revenue.CurrentPayment = paymentModel.PaidAmount.ToString("F2"); //本期缴款
//revenue.CurrentAccountBalance = (paymentModel.PayDebtAmount * -1).ToString("F2"); //本期欠款
revenue.CurrentAccountBalance = (paymentModel.PayDebtAmount).ToString("F2"); //本期欠款
revenue.Fee = paymentModel.fee;
revenue.FeeMoney = paymentModel.feeMoney.ToString("F2");
revenue.TotalAmount = (paymentModel.totalAmount * -1).ToString("F2");
//revenue.Fee_CurrentAccountBalance = paymentModel.PayDebtAmount >= 0 ? paymentModel.PayDebtAmount.ToString("f2") : (paymentModel.PayDebtAmount * -1).ToString("F2"); //本期欠款
revenue.Fee_CurrentAccountBalance = paymentModel.PayDebtAmount >= 0 ? "0" : (paymentModel.PayDebtAmount * -1).ToString("F2"); //本期欠款
revenue.Fee_TotalAmount = paymentModel.totalAmount >= 0 ? paymentModel.totalAmount.ToString("F2") : (paymentModel.totalAmount * -1).ToString("F2");
revenue.PaymentInfoList = paymentModel.PaymentInfoList;
revenue.PaidAmountInfoList = paymentModel.PaidAmountInfoList;
}
return(revenue);
}
/// <summary>
/// 手机端分页获取消息历史记录
/// </summary>
/// <param name="pageIndex">当前页码</param>
/// <param name="personVguid">当前浏览人的vguid</param>
/// <returns></returns>
public List <TempWeChatMain> GetWeChatPushList(int pageIndex, Guid personVguid)
{
using (var db = SugarDao_MsSql.GetInstance())
{
var personModel = new Business_Personnel_Information();
try
{
personModel = db.Queryable <Business_Personnel_Information>().Where(i => i.Vguid == personVguid).SingleOrDefault();
#region 使用程序查询
//var pushMainInfos = db.Queryable<V_Business_WeChatPushMain_Information>().Where(i => i.Status == 4 && i.History == "1" && i.PushType == 1).OrderBy(i => i.CreatedDate, OrderByType.Desc).ToList();
//var historys = pushMainInfos.Select(i => new TempWeChatMain
//{
// Title = i.Title,
// PushDate = i.PushDate,
// MessageType = i.MessageType,
// ExercisesVGUID = i.ExercisesVGUID,
// VGUID = i.VGUID,
// IsShow = GetPeopleByDepartmentAndLabel(i, personModel)
//}).Where(i => i.IsShow).Skip((pageIndex - 1) * 10).Take(10).ToList();
//var ss = db.SqlQuery<TempWeChatMain>("usp_Show_Business_WeChatPushMain_Information @vguid ",
// new { vguid = personModel.Vguid }).Where(i => i.ShowTYPE == 1).ToList();
#endregion
//使用存储过程查询
var historys = db.SqlQuery <TempWeChatMain>("usp_Show_Business_WeChatPushMain_Information @vguid,@Start,@End", new
{
vguid = personModel.Vguid,
Start = (pageIndex - 1) * 10 + 1,
End = pageIndex * 10
}).ToList();
var jsonResult = JsonHelper.ModelToJson(historys);
_ll.SaveLog(3, 37, personModel.ID + personModel.Name, "查看消息历史", jsonResult);
return(historys);
}
catch (Exception ex)
{
Common.LogHelper.LogHelper.WriteLog(ex.ToString());
_ll.SaveLog(5, 37, "查看消息历史:", personModel.ID + personModel.Name, ex.Message);
return(null);
}
}
}
/// <summary>
/// 获取人员姓名以及工号
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public Business_Personnel_Information GetUserNameAndJobNum(string userID)
{
using (SqlSugarClient _dbMsSql = SugarDao.SugarDao_MsSql.GetInstance())
{
Business_Personnel_Information personModel = new Business_Personnel_Information();
try
{
personModel = _dbMsSql.Queryable <Business_Personnel_Information>().Where(i => i.UserID == userID).SingleOrDefault();
}
catch (Exception ex)
{
Common.LogHelper.LogHelper.WriteLog(ex.Message);
}
finally
{
}
return(personModel);
}
}
/// <summary>
/// 获取司机ID和车辆ID
/// </summary>
/// <param name="personModel"></param>
/// <returns></returns>
public Driver GetDriverMsg(Business_Personnel_Information personModel)
{
using (SqlSugarClient _dbDriverSql = SugarDao.SugarDao_DriverRevenueSql.GetInstance())
{
Driver driverModel = new Driver();
try
{
driverModel = _dbDriverSql.Queryable <Driver>().Where(i => i.IdCard == personModel.IDNumber && i.Status == 1).SingleOrDefault();
}
catch (Exception ex)
{
Common.LogHelper.LogHelper.WriteLog(ex.Message);
}
finally
{
}
return(driverModel);
}
}
/// <summary>
/// 删除用户信息
/// </summary>
/// <param name="vguid"></param>
/// <returns></returns>
public bool DeleteUserInfo(string vguid)
{
using (SqlSugarClient dbMsSql = SugarDao_MsSql.GetInstance())
{
bool result = false;
Guid Vguid = Guid.Parse(vguid);
Business_Personnel_Information userInfo = dbMsSql.Queryable <Business_Personnel_Information>().Where(i => i.Vguid == Vguid).SingleOrDefault();
try
{
dbMsSql.BeginTran();
string weChatJson = JsonHelper.ModelToJson(userInfo);
//从微信中删除
string accessToken = Common.WeChatPush.WeChatTools.GetAccessoken();
string focusResult = Common.WeChatPush.WeChatTools.DisableWeChatData(accessToken, userInfo.UserID);//禁用微信通讯录人员
U_FocusResult resultMsg = new U_FocusResult();
resultMsg = JsonHelper.JsonToModel <U_FocusResult>(focusResult);
result = dbMsSql.Update <Business_Personnel_Information>(new { ApprovalStatus = 4 }, i => i.Vguid == Vguid);
if (resultMsg.errcode == 0)//删除成功
{
result = true;
}
else
{
LogHelper.WriteLog("人员:" + userInfo.UserID + "离职失败：错误码为-" + resultMsg.errcode + ",错误消息为_" + resultMsg.errmsg);
result = false;
}
//存入操作日志表
_ll.SaveLog(2, 5, CurrentUser.GetCurrentUser().LoginName, userInfo.Name, weChatJson);
dbMsSql.CommitTran();
return(result);
}
catch (Exception ex)
{
dbMsSql.RollbackTran();
LogHelper.WriteLog("人员:" + userInfo.UserID + "离职异常：异常信息为_" + ex.Message + "/n" + ex.ToString() + "/n" + ex.StackTrace);
}
return(result);
}
}
/// <summary>
/// 新增支付历史
/// </summary>
/// <param name="paymentHistoryInfo">实体信息</param>
/// <returns>返回成功与否</returns>
public bool UpdatePaymentHistory(Business_Personnel_Information personInfoModel, Business_PaymentHistory_Information paymentHistoryInfo, WxPayData notifyData)
{
paymentHistoryInfo.PaymentBrokers = "微信";
paymentHistoryInfo.Beneficiary = "大众出租汽车分公司";
paymentHistoryInfo.Description = WxPayConfig.BODY;
paymentHistoryInfo.Remarks = notifyData.GetValue("out_trade_no").ToString(); //商户单号
var paymentHistoryInfoOld = _weChatRevenueServer.GetPaymentHistory(paymentHistoryInfo.Remarks);
if (notifyData.GetValue("return_code").ToString() == "SUCCESS" && notifyData.GetValue("result_code").ToString() == "SUCCESS")
{
paymentHistoryInfo.ReceiptAccount = notifyData.GetValue("mch_id").ToString(); //商户号
paymentHistoryInfo.TransactionID = notifyData.GetValue("transaction_id").ToString(); //微信支付订单号
paymentHistoryInfo.ActualAmount = decimal.Parse(notifyData.GetValue("total_fee").ToString()) / 100; //实际付款
string timeEnd = notifyData.GetValue("time_end").ToString();
string year = timeEnd.Substring(0, 4);
string month = timeEnd.Substring(4, 2);
string day = timeEnd.Substring(6, 2);
string hour = timeEnd.Substring(8, 2);
string minute = timeEnd.Substring(10, 2);
string second = timeEnd.Substring(12, 2);
paymentHistoryInfo.PayDate = DateTime.Parse(year + "-" + month + "-" + day + " " + hour + ":" + minute + ":" + second); //付款时间
paymentHistoryInfo.PaymentStatus = "1"; //支付成功
SynchronousReceivableSystem(personInfoModel, paymentHistoryInfo, paymentHistoryInfoOld);
}
else
{
paymentHistoryInfo.TransactionID = notifyData.GetValue("out_trade_no").ToString(); //商户单号
paymentHistoryInfo.PaymentAmount = 0;
paymentHistoryInfo.PayDate = DateTime.Now;
paymentHistoryInfo.PaymentStatus = "2"; //支付失败
paymentHistoryInfo.ErrorCode = notifyData.GetValue("result_code").ToString();
paymentHistoryInfo.ErrorDescription = notifyData.GetValue("return_msg").ToString();
}
return(_weChatRevenueServer.UpdatePaymentHistory(personInfoModel, paymentHistoryInfo, paymentHistoryInfoOld));
}
