/// <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));
}
protected override List <string> GetSaveModelListSql(UserModel user, List <T_InStockTaskDetailsInfo> modelList)
{
string strSql1 = string.Empty;
string strSql2 = string.Empty;
string strSql3 = string.Empty;
string strSql4 = string.Empty;
string strSql5 = string.Empty;
List <string> lstSql = new List <string>();
T_Stock_DB stockDB = new T_Stock_DB();
Area.T_Area_DB areaDB = new Area.T_Area_DB();
int transID = 0;
foreach (var item in modelList)
{
strSql1 = string.Format("update t_taskdetails set remainqty = remainqty-{0}, shelveqty = isnull( shelveqty,0)+{1}," +
" toareano = '{2}', operatoruserno = '{3}', operatordatetime = getdate() where id = '{4}'", item.ScanQty, item.ScanQty, item.AreaID, user.UserNo, item.ID);
lstSql.Add(strSql1);
//strSql2 = string.Format("update t_taskdetails set linestatus =(case when isnull( remainqty,0)< isnull( taskqty,0) and isnull( remainqty,0)<>0 then 2 when isnull( remainqty,0) = 0 then 3 end )," +
strSql2 = string.Format("update t_taskdetails set linestatus =(case when isnull( remainqty,0)>0 and isnull( shelveqty,0)>0 then 2 when isnull( remainqty,0) = 0 then 3 end )," +
" Toerpareano ='{1}',Toerpwarehouse='{2}' where id = '{0}'", item.ID, item.AreaNo, item.ToErpWarehouse);
lstSql.Add(strSql2);
if (item.lstStockInfo != null && item.lstStockInfo.Count > 0)
{
foreach (var itemStock in item.lstStockInfo)
{
Area.T_AreaInfo areaInfo = new T_AreaInfo();
string NewSerialNo = "";
areaInfo.AreaNo = item.AreaNo;
areaInfo.WarehouseID = item.WarehouseID;
areaInfo = areaDB.GetModelBySql(areaInfo);
if (itemStock.BarCodeType != 5)
{
itemStock.AmountQty = itemStock.Qty;
}
itemStock.Status = 3;
itemStock.ReceiveStatus = 2;//是否已上架
itemStock.IsLimitStock = 2;
itemStock.IsQuality = 3;
lstSql.AddRange(stockDB.saveSplitBarCode(user, itemStock, areaInfo, out NewSerialNo));
//itemStock.AmountQty = itemStock.Qty;
//if (item.ScanQty != itemStock.Qty)
//{
// itemStock.AmountQty = item.ScanQty;
// string NewSerialNo = "";
// var value = base.GetScalarBySql("select serialno from t_stock where Areaid =" + item.AreaID + " and materialno ='" + itemStock.MaterialNo + "' and edate=to_date('" + itemStock.EDate.ToString("yyyy-MM-dd") + "','yyyy-mm-dd') and batchno ='" + itemStock.BatchNo + "' and strongholdcode='" + itemStock.StrongHoldCode + "' ");
// if (value == null || value.ToString() == "")
// {
// lstSql.Add(GetAmountQtySql(itemStock, ref NewSerialNo));
// itemStock.AreaID = item.AreaID;
// itemStock.HouseID = item.HouseID;
// itemStock.WareHouseID = item.WarehouseID;
// itemStock.Status = 3;
// itemStock.ReceiveStatus = 2;
// itemStock.IsLimitStock = 2;
// itemStock.IsQuality = 3;
// lstSql.Add(GetAmountQtyInsertStockSql(itemStock, user, NewSerialNo));
// lstSql.Add("update t_stock a set Qty = Qty - '" + itemStock.AmountQty + "' where serialno = '" + itemStock.SerialNo + "'");
// }
// else
// {
// lstSql.Add("update t_stock a set Qty = Qty - '" + itemStock.AmountQty + "' where serialno = '" + itemStock.SerialNo + "'");
// lstSql.Add("update t_stock a set Qty = Qty + '" + itemStock.AmountQty + "' where serialno = '" + value + "'");
// }
//}
//else
//{
// strSql3 = string.Format("update t_Stock a set Receivestatus = '2' , islimitstock = '2', Warehouseid = '{0}', Houseid = '{1}', Areaid = '{2}' where serialno = '{3}'", item.WarehouseID, item.HouseID, item.AreaID, itemStock.SerialNo);
// lstSql.Add(strSql3);
//}
//transID = base.GetTableID("seq_tasktrans_id");
transID = base.GetTableIDBySqlServerTaskTrans("t_tasktrans");
strSql5 = "SET IDENTITY_INSERT t_tasktrans on ;insert into t_tasktrans(id, Serialno, Materialno, Materialdesc, Supcuscode, " +
"Supcusname, Qty, Tasktype, Vouchertype, Creater, Createtime,TaskdetailsId, Unit, Unitname,partno,materialnoid,erpvoucherno,voucherno," +
"Strongholdcode,Strongholdname,Companycode,Supprdbatch,Edate,taskno,Batchno,Barcode,FromWarehouseNo,FromWarehouseName,FromHouseNo,FromAreaNo,ToWarehouseNo,ToWarehouseName,ToHouseNo,ToAreaNo,PalletNo,IsPalletOrBox)" +
" values ('" + transID + "','" + itemStock.SerialNo + "'," +
" '" + item.MaterialNo + "','" + item.MaterialDesc + "','" + item.SupCusCode + "','" + item.SupCusName + "','" + itemStock.AmountQty + "','1'," +
" (select vouchertype from t_task where id = '" + item.HeaderID + "') ,'" + user.UserName + "',getdate(),'" + item.ID + "', " +
"'" + item.Unit + "','" + item.UnitName + "','" + item.PartNo + "','" + item.MaterialNoID + "','" + item.ErpVoucherNo + "'," +
" '" + item.VoucherNo + "','" + itemStock.StrongHoldCode + "','" + itemStock.StrongHoldName + "','" + itemStock.CompanyCode + "'," +
" '" + itemStock.SupPrdBatch + "','" + itemStock.EDate + "' ,'" + item.TaskNo + "','" + itemStock.BatchNo + "','" + itemStock.Barcode + "'," +
" (select WAREHOUSENO from T_WAREHOUSE where id = (select WAREHOUSEID from T_STOCK where SERIALNO = '" + itemStock.SerialNo + "'))," +
" (select WAREHOUSENAME from T_WAREHOUSE where id = (select WAREHOUSEID from T_STOCK where SERIALNO = '" + itemStock.SerialNo + "'))," +
" (select HOUSENO from T_HOUSE where id = (select HOUSEID from T_STOCK where SERIALNO = '" + itemStock.SerialNo + "'))," +
" (select AREANO from T_AREA where id = (select AREAID from T_STOCK where SERIALNO = '" + itemStock.SerialNo + "'))," +
" '" + item.WareHouseNo + "',(select WAREHOUSENAME from T_WAREHOUSE where warehouseno = '" + item.WareHouseNo + "'),(SELECT HOUSENO from v_area where WAREHOUSENO = '" + item.WareHouseNo + "' AND AREANO = '" + item.AreaNo + "'),'" + item.AreaNo + "','" + itemStock.PalletNo + "','" + itemStock.IsPalletOrBox + "') SET IDENTITY_INSERT t_tasktrans off ";
lstSql.Add(strSql5);
}
}
}
strSql3 = "update t_task set Status = 2 where id = '" + modelList[0].HeaderID + "'";
lstSql.Add(strSql3);
strSql4 = string.Format(" update t_task set status = 3 where id in(select HeaderID from t_taskdetails group by HeaderID having(max(isnull(linestatus,1)) = 3 and min(isnull(linestatus,1))=3) and HeaderID = '{0}')" +
"and id = '{1}'", modelList[0].HeaderID, modelList[0].HeaderID);
lstSql.Add(strSql4);
return(lstSql);
}
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 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));
}
