/// <summary>
/// 根据任务ID获取任务数据
/// </summary>
/// <param name="TaskNo"></param>
/// <returns></returns>
public BaseMessage_Model <T_InStockTaskDetailsInfo> GetInTaskDetailListByHeaderID(string TaskNo, UserModel user, List <T_InStockDetailInfo> lstModel)
{
int HeadID = 0;
bool bSucc = false;
string strErrMsg = string.Empty;
BaseMessage_Model <T_InStockTaskDetailsInfo> baseMessage = new BaseMessage_Model <T_InStockTaskDetailsInfo>();
T_InTaskDetails_DB tdb = new T_InTaskDetails_DB();
T_InTaskDetails_Func tfunc = new T_InTaskDetails_Func();
T_AreaInfo areaModel = new T_AreaInfo();
T_Area_Func areaFunc = new T_Area_Func();
HeadID = tdb.GetIDByTaskNo(TaskNo);
List <T_InStockTaskDetailsInfo> lstTaskDetail = new List <T_InStockTaskDetailsInfo>();
bSucc = tfunc.GetModelListByHeaderID(ref lstTaskDetail, HeadID, ref strErrMsg);
if (bSucc == false)
{
baseMessage.HeaderStatus = "E";
baseMessage.Message = strErrMsg;
return(baseMessage);
}
//任务表体数据
foreach (var item in lstTaskDetail)
{
item.lstStockInfo = new List <T_StockInfo>();
//根据任务表体数据查找收货数据，存在多行
var lstInDetail = lstModel.FindAll(t => t.MaterialNo == item.MaterialNo);
foreach (var itemInDetail in lstInDetail)
{
areaFunc.GetAreaModelBySql(0, itemInDetail.lstSerialNo.FirstOrDefault().AreaNo, ref areaModel, ref strErrMsg);
foreach (var itemSerialNo in itemInDetail.lstSerialNo)
{
T_StockInfo stock = new T_StockInfo();
stock.SerialNo = itemSerialNo.SerialNo;
item.lstStockInfo.Add(stock);
}
}
item.AreaID = areaModel.ID;
item.WarehouseID = areaModel.WarehouseID;
item.HouseID = areaModel.HouseID;
item.ScanQty = item.lstStockInfo.Count;
}
string Result = tfunc.SaveModelListSqlToDBADF(JSONHelper.ObjectToJson <UserModel>(user), JSONHelper.ObjectToJson <List <T_InStockTaskDetailsInfo> >(lstTaskDetail));
return(JSONHelper.JsonToObject <BaseMessage_Model <T_InStockTaskDetailsInfo> >(Result));
}
/// <summary>
/// 上架扫描库位
/// </summary>
/// <param name="AreaNo"></param>
/// <returns></returns>
public string GetAreaModelADF(string UserJson, string AreaNo)
{
T_Area_Func tfunc = new T_Area_Func();
return(tfunc.GetAreaModelBySqlADF(UserJson, AreaNo));
}
/// <summary>
/// 获取指定仓库货位信息
/// </summary>
/// <param name="UserJson"></param>
/// <param name="areaNO"></param>
/// <returns></returns>
public string GetT_AreaInfoADF(string UserJson, string areaNO)
{
T_Area_Func func = new T_Area_Func();
return(func.GetAreaModelBySqlADF(UserJson, areaNO));
}
/// <summary>
/// 获取库位信息
/// </summary>
/// <param name="areaNO"></param>
/// <returns></returns>
public string GetT_AreaNOInfoADF(string areaNO)
{
T_Area_Func func = new T_Area_Func();
return(func.GetAreaModelBySql(areaNO));
}
public string UserLoginADF(string UserJson)
{
BaseMessage_Model <UserInfo> messageModel = new BaseMessage_Model <UserInfo>();
try
{
UserInfo model;
User_DB _db = new User_DB();
DateTime CurrentTime;
LogNet.LogInfo("UserLoginADF---" + UserJson);
UserInfo user = BILBasic.JSONUtil.JSONHelper.JsonToObject <UserInfo>(UserJson);
//UserInfo user = JsonConvert.DeserializeObject<UserInfo>(UserJson);
model = _db.GetModelBySql(user);
if (model == null)
{
int iSucc = _db.GetScalarBySql(user);
if (iSucc <= 0)
{
messageModel.Message = "该用户不存在,请检查大小写是否输入正确!";
messageModel.HeaderStatus = "E";
return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <UserInfo> >(messageModel));
}
else
{
messageModel.Message = "密码输入错误,忘记密码请联系管理员重置!";
messageModel.HeaderStatus = "E";
return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <UserInfo> >(messageModel));
}
}
CurrentTime = model.CurrentTime;
if (user.WarehouseID != -100)
{
if (!model.WarehouseCode.Contains(user.WarehouseID.ToString()))
{
messageModel.Message = "登录账户与所选仓库不一致！";
messageModel.HeaderStatus = "E";
return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <UserInfo> >(messageModel));
}
}
if (model.UserStatus == 2)
{
messageModel.Message = string.Format("用户【{0}】已停用", model.UserName);
messageModel.HeaderStatus = "E";
return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <UserInfo> >(messageModel));
}
if (model.IsDel == 2)
{
messageModel.Message = string.Format("用户【{0}】已删除", model.UserName);
messageModel.HeaderStatus = "E";
return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <UserInfo> >(messageModel));
}
model.WarehouseID = user.WarehouseID;
user = model;
T_UserGroup_Func ugf = new T_UserGroup_Func();
List <T_UserGroupInfo> lstGroup = new List <T_UserGroupInfo>();
if (ugf.GetModelListBySql(user, ref lstGroup))
{
user.lstUserGroup = lstGroup;
}
//暂时屏蔽
T_MENU_Func tmfun = new T_MENU_Func();
List <T_MenuInfo> lstMenu = new List <T_MenuInfo>();
if (tmfun.GetModelListBySql(user, ref lstMenu, false))
{
user.lstMenu = lstMenu.Where(t => t.MenuType == 4).ToList();
}
//根据用户配置的仓库ID，获取对应的收货，发货库位
T_Area_Func tafun = new T_Area_Func();
List <T_AreaInfo> lstArea = new List <T_AreaInfo>();
if (tafun.GetModelListBySql(user.WarehouseID, ref lstArea))
{
T_AreaInfo areaInfo = new T_AreaInfo();
//查找收货待检库位
areaInfo = lstArea.Find(t => t.AreaType == 2);
if (areaInfo != null)
{
user.ReceiveHouseID = areaInfo.HouseID;
user.ReceiveAreaID = areaInfo.ID;
user.ReceiveAreaNo = areaInfo.AreaNo;
user.ReceiveWareHouseNo = areaInfo.WarehouseNo;
user.ReceiveHouseNo = areaInfo.HouseNo;
user.ReceiveWareHouseName = areaInfo.WarehouseName;
user.QuanUserNo = areaInfo.QuanUserNo;
user.QuanUserName = areaInfo.QuanUserName;
//user.lstQuanUser = _db.GetQuanUser(user.QuanUserNo);
}
//查找拣货临时库位
areaInfo = lstArea.Find(t => t.AreaType == 3);
if (areaInfo != null)
{
user.PickHouseID = areaInfo.HouseID;
user.PickAreaID = areaInfo.ID;
user.PickWareHouseID = areaInfo.WarehouseID;
user.PickAreaNo = areaInfo.AreaNo;
user.PickWareHouseNo = areaInfo.WarehouseNo;
user.PickHouseNo = areaInfo.HouseNo;
user.PickWareHouseName = areaInfo.WarehouseName;
}
areaInfo = lstArea.Find(t => t.AreaType == 4);
if (areaInfo != null)
{
user.ToSampWareHouseNo = areaInfo.WarehouseNo;
user.ToSampAreaNo = areaInfo.AreaNo;
}
}
//T_WareHouse_Func twfun = new T_WareHouse_Func();
//List<T_WareHouseInfo> lstWarehouse = new List<T_WareHouseInfo>();
//if (twfun.GetModelListBySql(user, ref lstWarehouse))
//{
// user.lstWarehouse = lstWarehouse;
//}
messageModel.Message = "登录成功！";
messageModel.HeaderStatus = "S";
messageModel.ModelJson = user;
return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <UserInfo> >(messageModel));
//return JsonConvert.SerializeObject(messageModel);
}
catch (Exception ex)
{
messageModel.Message = ex.Message;
messageModel.HeaderStatus = "E";
return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <UserInfo> >(messageModel));
}
}
public bool UpdateT_AreaStatus(UserInfo user, ref T_AreaInfo t_area, int NewStatus, ref string strError)
{
T_Area_Func tfunc = new T_Area_Func();
return(tfunc.UpdateModelStatus(user, ref t_area, NewStatus, ref strError));
}
public bool GetAllT_AreaByHeaderID(ref List <T_AreaInfo> modelList, int headerID, ref string strError)
{
T_Area_Func tfunc = new T_Area_Func();
return(tfunc.GetModelListByHeaderID(ref modelList, headerID, ref strError));
}
public bool GetT_AreaListByPage(ref List <T_AreaInfo> modelList, UserInfo user, T_AreaInfo t_area, ref DividPage page, ref string strError)
{
T_Area_Func tfunc = new T_Area_Func();
return(tfunc.GetModelListByPage(ref modelList, user, t_area, ref page, ref strError));
}
public bool GetT_AreaByID(ref T_AreaInfo model, ref string strError)
{
T_Area_Func tfunc = new T_Area_Func();
return(tfunc.GetModelByID(ref model, ref strError));
}
public bool DeleteT_AreaByModel(UserInfo user, T_AreaInfo model, ref string strError)
{
T_Area_Func tfunc = new T_Area_Func();
return(tfunc.DeleteModelByModel(user, model, ref strError));
}
public bool SaveT_Area(UserInfo user, ref T_AreaInfo t_area, ref string strError)
{
T_Area_Func tfunc = new T_Area_Func();
return(tfunc.SaveModelToDB(user, ref t_area, ref strError));
}
