public static string SMSParameters_GetValueByCode(string code)
{
string sql = " select Value from Sys_SMS_Search_Condition where Code=" + code;
object o = SqlHelper.SqlHelper.ExecuteScalar(SqlHelper.SqlHelper.connstr, CommandType.Text, sql);
return(ConvertVal.GetValStr(o));
}
public UnitList(string unitName, string unitFrom, string unitTo, ConvertVal del)
{
this.UnitName = unitName;
this.UnitFrom = unitFrom;
this.UnitTo = unitTo;
this.convert = del;
}
/// <summary>
/// 审批
/// </summary>
/// <param name="F_OrderNo"></param>
/// <param name="TruckWeight"></param>
/// <param name="GrossWeight"></param>
/// <param name="NetWeight"></param>
/// <returns></returns>
public object AuditForm(string F_OrderNo, string TruckWeight, string GrossWeight, string NetWeight)
{
try
{
if (string.IsNullOrEmpty(F_OrderNo) || string.IsNullOrEmpty(TruckWeight) || string.IsNullOrEmpty(GrossWeight) || string.IsNullOrEmpty(NetWeight))
{
return(new { state = false, message = "参数不正确" });
}
var op = OperatorProvider.Provider.GetCurrent();
if (string.IsNullOrEmpty(op.UserCode))
{
return(new { state = false, message = "当前登录失效，请重新登录！" });
}
var result = ValidateData(TruckWeight, GrossWeight, NetWeight);
if (!result.Item1)
{
return(new { state = false, message = result.Item2 });
}
var order = _repository.FindEntity <T_Order>(p => p.F_OrderNo == F_OrderNo);
if (order == null)
{
return(new { state = false, message = "实体查询失败" });
}
TransactionOptions to = new TransactionOptions();
to.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, to))
{
order.F_OrderStatus = (int)OrderStatus.过毛重;
order.F_TruckWeight = ConvertVal.GetValFloat(TruckWeight);
order.F_GrossWeight = ConvertVal.GetValFloat(GrossWeight);
float?fNetWeight = order.F_GrossWeight - order.F_TruckWeight;
order.F_NetWeight = fNetWeight;
order.F_BillWeight = fNetWeight;
order.F_OBillStatus = (int)BillStatus.已通过;
order.F_LogoutTime = DateTime.Now;
order.F_OpOut = op.UserCode;
_repository.Update(order);
var approve = new T_Approve()
{
F_OrderNo = order.F_OrderNo,
F_WMSCode = order.F_WMSCode,
F_EnterpriseCode = order.F_EnterpriseCode,
F_UserID = op.UserCode,
F_TruckWeight = order.F_TruckWeight,
F_GrossWeight = order.F_GrossWeight,
F_NetWeight = order.F_NetWeight,
F_BillWeight = order.F_BillWeight,
F_DateTime = DateTime.Now
};
_repository.Insert(approve);
}
return(new { state = true });
}
catch (Exception ex)
{
return(new { state = false, message = "审批失败，原因：" + ex.ToString() });
}
}
/// <summary>
/// 获取实体
/// </summary>
/// <param name="keyValue"></param>
/// <returns></returns>
public object GetFormJsonOILType(string keyValue)
{
int fId = ConvertVal.GetValInt(keyValue);
var m = _repository.IQueryableAsNoTracking <T_OILType>(p => p.F_ID == fId).FirstOrDefault();
return(m);
}
public object DeleteOILType(string keyValue)
{
try
{
int fId = ConvertVal.GetValInt(keyValue);
if (_repository.Delete <T_OILType>(p => p.F_ID == fId) > 0)
{
return(new { state = true, message = "删除成功！" });
}
return(new { state = false, message = "删除失败！" });
}
catch (Exception ex)
{
return(new { state = false, message = "删除失败！" + ex.ToString() });
}
}
/// <summary>
/// 添加数据
/// </summary>
/// <param name="type"></param>
/// <param name="FileName"></param>
/// <param name="FilePath"></param>
/// <param name="F_Description"></param>
/// <returns></returns>
public object AddUploadContent(string type, string FileName, string FilePath, string F_Description, string f_date)
{
if (string.IsNullOrEmpty(type) || string.IsNullOrEmpty(FileName) || string.IsNullOrEmpty(FilePath) || string.IsNullOrEmpty(f_date))
{
return(new { state = false, msg = "缺少参数" });
}
try
{
var _date = DateTime.Parse(f_date);
var op = OperatorProvider.Provider.GetCurrent();
_repository.Insert(new T_UploadContent()
{
F_ID = Guid.NewGuid().ToString("N"),
F_Filename = FileName,
F_Description = F_Description,
F_Operator = op.UserCode,
F_DateTime = _date,
F_TypeID = ConvertVal.GetValInt(type),
F_Url = FilePath,
F_CreateTime = DateTime.Now
});
return(new { state = true });
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Code.Logger.LogHelper.Error(string.Format("Class: {0}, Property: {1}, Error: {2}", validationErrors.Entry.Entity.GetType().FullName,
validationError.PropertyName,
validationError.ErrorMessage), Code.Enum.OpType.Add);
}
}
return(new { state = false, msg = "操作失败" });
}
catch (Exception ex)
{
return(new { state = false, msg = ex.ToString() });
}
}
private Tuple <bool, string> ValidateData(string TruckWeight, string GrossWeight, string NetWeight)
{
float fTruckWeight = ConvertVal.GetValFloat(TruckWeight);
if (fTruckWeight <= 0.1)
{
return(new Tuple <bool, string>(false, "皮重输入有误，请重新输入!"));
}
float fGrossWeight = ConvertVal.GetValFloat(GrossWeight);
if (fGrossWeight <= 0.1)
{
return(new Tuple <bool, string>(false, "毛重输入有误，请重新输入!"));
}
if (string.IsNullOrEmpty(NetWeight.Trim()))
{
return(new Tuple <bool, string>(false, "净重数据有误，请重新输入!"));
}
return(new Tuple <bool, string>(true, ""));
}
/// <summary>
/// 管理员登陆
/// </summary>
/// <param name="UserName"></param>
/// <param name="pwd"></param>
/// <returns></returns>
public LoginContent CheckLogin(string UserName, string pwd)
{
OperatorProvider.Provider.RemoveCurrent();
OperatorModel operatorModel = new OperatorModel();
LoginContent content = new LoginContent()
{
IsSmsLogin = "******",
Msg = "用户名密码错误",
Success = false,
MoPhone = "",
LoginType = (int)LoginTypeEnum.ManageMember
};
var encodeUserName = Utility.EncodeStr(UserName);
string thisIp = Net.Ip;
//var location = Tool.GetIpLocation(thisIp);
//if (location.Trim() == "局域网" || thisIp == "127.0.0.1")
//{
// thisIp = "112.253.8.147";//山东省潍坊市联通
//}
thisIp = "112.253.8.147";//山东省潍坊市联通
operatorModel.CurrentIp = thisIp;
//获取平台管理员
string passWord = Md5.md5(pwd, 32);//将密码加密
#region 平台管理员
Sys_User userInfo = _repository.FindEntity <Sys_User>(a => a.F_Account == UserName);
if (userInfo != null)
{
if (userInfo.F_EnabledMark == false)
{
content.Success = false;
content.Msg = "该账号已被禁用，请联系管理员！";
return(content);
}
var userloginOn = _repository.FindEntity <Sys_UserLogOn>(a => a.F_UserId == userInfo.F_Id);
string dbPassword = Md5.md5(DESEncrypt.Encrypt(passWord.ToLower(), userloginOn.F_UserSecretkey).ToLower(), 32).ToLower();
if (dbPassword != userloginOn.F_UserPassword)
{
content.Success = false;
return(content);
}
content.LoginType = (int)LoginTypeEnum.ManageMember;
content.Success = true;
content.IsSmsLogin = "******";
content.Msg = "登录成功";
content.MoPhone = userInfo.F_MobilePhone;
Sys_Role roleInfo = _repository.FindEntity <Sys_Role>(p => p.F_Id == userInfo.F_RoleId);
operatorModel.LoginTime = DateTime.Now;
operatorModel.LastIp = thisIp;
int count = userloginOn.F_LogOnCount ?? 0 + 1;
userloginOn.F_LogOnCount = count;
userloginOn.F_LastVisitTime = DateTime.Now;
int flag = _repository.Update(userloginOn);
#region 存储session
operatorModel.UserId = userInfo.F_Id.ToString();
operatorModel.UserCode = userInfo.F_Account;
operatorModel.UserName = userInfo.F_RealName;
operatorModel.CompanyId = userInfo.F_OrganizeId;
operatorModel.DepartmentId = userInfo.F_DepartmentId;
operatorModel.RoleId = ConvertVal.GetValStr(userInfo.F_RoleId);
operatorModel.LoginIPAddress = Net.Ip;
operatorModel.LoginIPAddressName = Net.GetLocation(operatorModel.LoginIPAddress);
operatorModel.LoginTime = DateTime.Now;
operatorModel.LoginToken = userInfo.F_Account;
operatorModel.LoginFlag = Common.GuId();
operatorModel.OrganizeModel = GetOrganize(userInfo.F_OrganizeId);
operatorModel.Sex = userInfo.F_Gender;
operatorModel.DutyId = userInfo.F_DutyId;
operatorModel.F_Birthday = userInfo.F_Birthday;
operatorModel.F_BelongTo = userInfo.F_EntrCode;
operatorModel.Phone = Utility.DecodeStr(userInfo.F_MobilePhone);
operatorModel.Email = userInfo.F_Email;
operatorModel.IsSystem = false;
if (userInfo.F_Account == "admin")
{
operatorModel.IsSystem = true;
}
operatorModel.LoginType = LoginTypeEnum.ManageMember;
OperatorProvider.Provider.AddCurrent(operatorModel);
//var redis = new ContentCache(DBEnum.用户信息);
// redis.HSet<OperatorModel>("Login_ManagerUserInfo", operatorModel.UserCode, operatorModel);
LogHelper.Info("帐号：" + UserName + ",登录系统IP:" + thisIp, OpType.Login, null, "LoginApp-CheckLogin", "", ViewLevel.Admin);
#endregion
content.Success = true;
content.Msg = "登录成功";
return(content);
}
#endregion
#region 用户名密码错误，登录失败
LogHelper.Warn("帐号：" + UserName + ",登录系统失败IP:" + thisIp, OpType.Login, null, "LoginApp-CheckLogin", "", ViewLevel.Admin);
// Tool.InsertLogLogin(userName, userName, "帐号：" + userName + ",登录系统IP:" + thisIp + ",密码：" + pwd, OpType.Login, 0, 4, "SYS_Service--LoginPass", Tool.GetAddressBYIP(thisIp));
#endregion
return(content);
}
public object GetGridJson(Pagination pagination, string location, string d1, string d2, string strNo)
{
var op = OperatorProvider.Provider.GetCurrent();
int nOBillStatus = (int)BillStatus.已通过;
int nOrderStatus = (int)OrderStatus.过毛重;
var Query = _repository.IQueryableAsNoTracking <T_Order>(p => p.F_OrderStatus >= nOrderStatus && p.F_OBillStatus == nOBillStatus);
Query = Query.Where(p => p.F_WMSCode == location);
if (!string.IsNullOrEmpty(d1))
{
DateTime _d1 = ConvertVal.GetValDateTime(d1);
Query = Query.Where(p => p.F_LogoutTime >= _d1);
}
if (!string.IsNullOrEmpty(d2))
{
DateTime _d2 = ConvertVal.GetValDateTime(d2);
Query = Query.Where(p => p.F_LogoutTime <= _d2);
}
if (!string.IsNullOrEmpty(strNo))
{
Query = Query.Where(p => p.F_OrderNo.Contains(strNo));
}
var q1 = _repository.IQueryableAsNoTracking <T_WMS>();
var q2 = _repository.IQueryableAsNoTracking <T_Enterprise>();
var query1 = from t1 in Query
join t2 in q1 on t1.F_WMSCode equals t2.F_Code
join t3 in q2 on t1.F_EnterpriseCode equals t3.F_Code
select new OrderEntity
{
F_OrderNo = t1.F_OrderNo,
F_WMSCode = t1.F_WMSCode,
F_EnterpriseCode = t1.F_EnterpriseCode,
F_OrderType = t1.F_OrderType,
F_ICCard = t1.F_ICCard,
F_Company = t1.F_Company,
F_TruckNo = t1.F_TruckNo,
F_DriverName = t1.F_DriverName,
F_DriverIDNo = t1.F_DriverIDNo,
F_OILDefine = t1.F_OILDefine,
F_Unit = t1.F_Unit,
F_OILName = t1.F_OILName,
F_MaterialID = t1.F_MaterialID,
F_ActualPrice = t1.F_ActualPrice,
F_OrderTime = t1.F_OrderTime,
F_OpOrder = t1.F_OpOrder,
F_CraneName = t1.F_CraneName,
F_StartTime = t1.F_StartTime,
F_EndTime = t1.F_EndTime,
F_OILValue = t1.F_OILValue,
F_TruckWeight = t1.F_TruckWeight,
F_LoginTime = t1.F_LoginTime,
F_OpIn = t1.F_OpIn,
F_GrossWeight = t1.F_GrossWeight,
F_NetWeight = t1.F_NetWeight,
F_BillWeight = t1.F_BillWeight,
F_LogoutTime = t1.F_LogoutTime,
F_OpOut = t1.F_OpOut,
F_OrderStatus = t1.F_OrderStatus,
F_TransCompany = t1.F_TransCompany,
F_SendCompany = t1.F_SendCompany,
F_OMeterID = t1.F_OMeterID,
F_Priority = t1.F_Priority,
F_SuperCargoIDNo = t1.F_SuperCargoIDNo,
F_Upload = t1.F_Upload,
F_Download = t1.F_Download,
F_OBillStatus = t1.F_OBillStatus,
F_OBillImage = t1.F_OBillImage,
F_OrderInfo = t1.F_OrderInfo,
F_WMSName = t2.F_Name,
F_EnterpriseName = t3.F_Name
};
return(query1.ToList());
}
