private void Process(ClientStoryGoal msg)
{
using (new MessageBlocker()) {
if (msg.key == "AuroraRadiationFixed")
{
var radiation = LeakingRadiation.main;
radiation.ReflectionCall("OnConsoleCommand_fixleaks");
radiation.ReflectionCall("OnConsoleCommand_decontaminate");
}
if (msg.key == "Infection_Progress5")
{
Player.main.infectedMixin.RemoveInfection();
}
// Story.StoryGoalManager.main.completedGoals.Add(msg.key);
Story.StoryGoalManager.main.OnGoalComplete(msg.key);
if (msg.goal == Story.GoalType.PDA)
{
var entries = PDALog.Serialize();
if (!entries.ContainsKey(msg.key))
{
PDALog.EntryData data;
if (PDALog.GetEntryData(msg.key, out data))
{
PDALog.Entry entry = new PDALog.Entry();
entry.data = data;
entry.timestamp = (float)msg.timestamp;
entries.Add(data.key, entry);
}
}
}
}
}
public override void Process(PDALogEntryAdd packet)
{
using (packetSender.Suppress <PDALogEntryAdd>())
{
PDALog.Add(packet.Key);
}
}
public RequestResult GetUpdateNewList(int Timestamp)
{
RequestResult result = new RequestResult();
try
{
List <C_Interface> CUser = C_User.Getusername(Timestamp);
List <Customer> CusList = new List <Customer>();
foreach (C_Interface user in CUser)
{
Customer cus = new Customer();
cus.CusNo = user.UserName;
cus.CusName = user.Name;
CusList.Add(cus);
}
result.data = CusList;
result.message = "成功";
result.success = true;
PDALog.Write("更新客户列表", "获取", "", PdaUser.PUserName + "-" + PdaUser.PRealName, string.Format("Timestamp:{0}", Timestamp), result.message);
}
catch (Exception ex)
{
result.code = 500;
result.message = "服务出错";
result.success = false;
DAL.Log.Instance.Write("获取最新客户列表出错：" + ex.Message, "PDA上传出错");
}
return(result);
}
/// <summary>
/// 生成盘点条码记录
/// </summary>
/// <param name="importDTOs"></param>
/// <param name="loginContext"></param>
public static void genCheckBarCodes(List <InvCheckBarCodeImportDTO> importDTOs, LoginContext loginContext)
{
UFSoft.UBF.Util.Context.ThreadContext context = GetContext(loginContext);
List <UFIDAU9CustJSDYBarCodeCheckBarCodeDTOData> list = new List <UFIDAU9CustJSDYBarCodeCheckBarCodeDTOData>();
UFIDAU9CustJSDYBarCodeCheckBarCodeDTOData dto = null;
foreach (InvCheckBarCodeImportDTO importDTO in importDTOs)
{
dto = new UFIDAU9CustJSDYBarCodeCheckBarCodeDTOData();
dto.m_orgID = importDTO.OrgID;
dto.m_itemID = importDTO.ItemID;
dto.m_actualLength = importDTO.Qty;
dto.m_barCode = importDTO.BarCode;
dto.m_checkedBy = importDTO.ScanPerson;
dto.m_checkedOn = importDTO.ScanDate;
list.Add(dto);
}
try
{
UFIDAU9CustJSDYBarCodeIGenCheckBarCodesClient client = new UFIDAU9CustJSDYBarCodeIGenCheckBarCodesClient();
client.Do(context, list.ToArray());
}
catch (System.Exception ex)
{
PDALog.Error(ex);
throw new System.Exception(ExceptionHelper.ParseError(ex));
}
}
/// <summary>
/// 根据完工申报单生成成品条码记录
/// </summary>
/// <param name="importDTOs"></param>
/// <param name="loginContext"></param>
public static void genProductBarCodeByCompleteApply(List <ProductBarCodeImportDTO> importDTOs, LoginContext loginContext)
{
UFSoft.UBF.Util.Context.ThreadContext context = GetContext(loginContext);
List <UFIDAU9CustJSDYBarCodeProductBarCodeByCompleteApplyDTOData> list = new List <UFIDAU9CustJSDYBarCodeProductBarCodeByCompleteApplyDTOData>();
UFIDAU9CustJSDYBarCodeProductBarCodeByCompleteApplyDTOData dto = null;
foreach (ProductBarCodeImportDTO importDTO in importDTOs)
{
dto = new UFIDAU9CustJSDYBarCodeProductBarCodeByCompleteApplyDTOData();
dto.m_orgID = importDTO.OrgID;
dto.m_itemID = importDTO.ItemID;
dto.m_actualLength = importDTO.Qty;
dto.m_barCode = importDTO.BarCode;
dto.m_qcOperator = importDTO.QcOperatorID;
dto.m_completeApplyDoc = importDTO.DocID;
dto.m_completeApplyDocLine = importDTO.DocLineID;
dto.m_scanBy = importDTO.ScanPerson;
dto.m_scanOn = importDTO.ScanDate;
list.Add(dto);
}
try
{
UFIDAU9CustJSDYBarCodeIGenProductBarCodesByCompleteApplyClient client = new UFIDAU9CustJSDYBarCodeIGenProductBarCodesByCompleteApplyClient();
client.Do(context, list.ToArray());
}
catch (System.Exception ex)
{
PDALog.Error(ex);
throw new System.Exception(ExceptionHelper.ParseError(ex));
}
}
public RequestResult GetAllList(int pageindex, int pagesize, string orderno = "")
{
RequestResult result = new RequestResult();
try
{
int totalCount = 0;
List <CustomerOrder> ListOrder = Order.GetHQPageNotOrderAll(pageindex, pagesize, orderno, out totalCount);
result.data = ListOrder;
result.pages = pageindex;
result.total = totalCount;
result.message = "成功";
result.success = true;
PDALog.Write("获取所有订单", "获取", "", PdaUser.PUserName + "-" + PdaUser.PRealName, string.Format("pageindex:{0},pagesize:{1},orderno:{2}", pageindex, pagesize, orderno), result.message);
}
catch (Exception ex)
{
result.code = 500;
result.message = "服务出错";
result.success = false;
DAL.Log.Instance.Write("客户查询出错：" + ex.Message, "PDA上传出错");
}
return(result);
}
private void SetPDALog(List <PDALogEntry> logEntries)
{
Log.Info($"Received initial sync packet with {logEntries.Count} pda log entries");
using (packetSender.Suppress <PDALogEntryAdd>())
{
Dictionary <string, PDALog.Entry> entries = PDALog.entries;
foreach (PDALogEntry logEntry in logEntries)
{
if (logEntry.Key != null && !entries.ContainsKey(logEntry.Key))
{
if (PDALog.GetEntryData(logEntry.Key, out PDALog.EntryData entryData))
{
PDALog.Entry entry = new PDALog.Entry();
entry.data = entryData;
entry.timestamp = logEntry.Timestamp;
entries.Add(entryData.key, entry);
if (entryData.key == "Story_AuroraWarning4")
{
CrashedShipExploder.main.SwapModels(true);
}
}
}
}
}
}
public RequestResult LoginOut()
{
RequestResult result = new RequestResult();
try
{
if (PDAUserMsg.RemoveUser(UserToken))
{
result.message = "登出成功";
result.success = true;
}
else
{
result.message = "登出失败";
result.success = false;
}
PDALog.Write("退出登录", "退出", "", PdaUser.PUserName + "-" + PdaUser.PRealName, "", result.message);
}
catch (Exception ex)
{
result.code = 500;
result.message = "服务出错";
result.success = false;
DAL.Log.Instance.Write("PDA用户退出出错：" + ex.Message, "PDA用户退出出错");
}
return(result);
}
public RequestResult RemoveBigCode(string code)
{
RequestResult result = new RequestResult();
try
{
List <Scale> scale = Scale.GetScaleForBig(code);
if (scale.Count > 0)
{
if (scale.Where(sca => sca.IsInto == false).Count() > 0)
{
result.message = "未入库";
result.success = false;
}
else if (scale.Where(sca => sca.IsOut == true).Count() > 0)
{
result.message = "已出货";
result.success = false;
}
else if (scale.Where(sca => sca.StateID == 9).Count() > 0)
{
result.message = "退货无法撤消";
result.success = false;
}
else
{
Scale scaleDeal = scale.Where(sca => sca.IsInto == true).FirstOrDefault();
scaleDeal.IsInto = false;
scaleDeal.IntoPDAUser = ""; // PdaUser.PUserName;
scaleDeal.IntoTime = 0; // CommonFunc.GetNowTimestamp();
scaleDeal.ProductNo = "";
//scaleDeal.IntoPDAUser = PdaUser.PUserName;
//scaleDeal.IntoTime = CommonFunc.GetNowTimestamp();
scaleDeal.StateID = scaleDeal.IsLinkBig ? 3 : scaleDeal.IsLinkMid ? 2 : 0;
scaleDeal.RemoveBigInto();
result.message = "成功";
result.success = true;
}
}
else
{
result.code = 304;
result.message = "条码不存在";
result.success = false;
}
PDALog.Write("撤消入库", "大标", code, PdaUser.PUserName + "-" + PdaUser.PRealName, string.Format("code:{0}", code), result.message);
}
catch (Exception ex)
{
result.code = 500;
result.message = "服务出错";
result.success = false;
DAL.Log.Instance.Write("撤消大标入库出错：" + ex.Message, "PDA上传出错");
}
return(result);
}
public RequestResult QueryList(string KeyWords)
{
RequestResult result = new RequestResult();
try
{
List <C_Interface> CUser = C_User.Getusername(KeyWords);
List <Customer> CusList = new List <Customer>();
foreach (C_Interface user in CUser)
{
Customer cus = new Customer();
cus.CusNo = user.UserName;
cus.CusName = user.Name;
CusList.Add(cus);
}
result.data = CusList;
result.message = "成功";
result.success = true;
PDALog.Write("查询客户", "查询", "", PdaUser.PUserName + "-" + PdaUser.PRealName, string.Format("KeyWords:{0}", KeyWords), result.message);
}
catch (Exception ex)
{
result.code = 500;
result.message = "服务出错";
result.success = false;
DAL.Log.Instance.Write("客户查询出错：" + ex.Message, "PDA上传出错");
}
return(result);
}
public UserInfoDTO QueryUserInfo(string userCode)
{
try
{
string sql = string.Format("select ID, Code, Name from Base_User where Code='{0}'", userCode);
DataSet dataSet = SQLHelper.ExecuteDataSet(sql);
if (dataSet == null || dataSet.Tables.Count == 0 || dataSet.Tables[0].Rows.Count == 0)
{
return(null);
}
DataRow dataRow = dataSet.Tables[0].Rows[0];
UserInfoDTO userInfoDTO = new UserInfoDTO();
userInfoDTO.UserID = TypeHelper.ConvertType <long>(dataRow["ID"], 0);
userInfoDTO.UserCode = TypeHelper.ConvertType <string>(dataRow["Code"], string.Empty);
userInfoDTO.UserName = TypeHelper.ConvertType <string>(dataRow["Name"], string.Empty);
return(userInfoDTO);
}
catch (Exception ex)
{
PDALog.Error(ex);
throw ExceptionHelper.CreateSoapException(ex.Message, ex.Source);
}
}
private void SetPDALog(List <PDALogEntry> logEntries)
{
Log.Info("Received initial sync packet with " + logEntries.Count + " pda log entries");
using (packetSender.Suppress <PDALogEntryAdd>())
{
Dictionary <string, PDALog.Entry> entries = (Dictionary <string, PDALog.Entry>)(typeof(PDALog).GetField("entries", BindingFlags.NonPublic | BindingFlags.Static).GetValue(null));
foreach (PDALogEntry logEntry in logEntries)
{
if (!entries.ContainsKey(logEntry.Key))
{
PDALog.EntryData entryData;
PDALog.GetEntryData(logEntry.Key, out entryData);
PDALog.Entry entry = new PDALog.Entry();
entry.data = entryData;
entry.timestamp = logEntry.Timestamp;
entries.Add(entryData.key, entry);
if (entryData.key == "Story_AuroraWarning4")
{
CrashedShipExploder.main.ReflectionCall("SwapModels", false, false, new object[] { true });
}
}
}
}
}
public List <ShipPlanDocDTO> QueryShipPlanDocInfo(long orgID, string barCode)
{
try
{
if (string.IsNullOrEmpty(barCode))
{
return(null);
}
string sql = string.Format(@"
select *, (case when a.SegLength=0 then 0 else a.TotalLength/a.SegLength end)-a.RcvCount as JCount
from(
select item.ID as ItemID,
item.Code as ItemCode,
item.Name as ItemName,
item.SPECS as ItemSPECS,
doc.ID as ShipPlanID,
line.ID as ShipPlanLineID,
convert(decimal(24,9), (case when line.DescFlexField_PubDescSeg1='' then '0' else line.DescFlexField_PubDescSeg1 end)) as SegLength,
line.PlanQtyTU*1000 as TotalLength,
convert(decimal(24,9), (case when line.DescFlexField_PrivateDescSeg2='' then '0' else line.DescFlexField_PrivateDescSeg2 end)) as RcvCount
from SM_ShipPlanLine as line
inner join CBO_ItemMaster as item on line.ItemInfo_ItemID=item.ID
inner join SM_ShipPlan as doc on line.ShipPlan=doc.ID
where doc.Org='{0}' and doc.DocNo='{1}'
) as a where a.SegLength>0 and a.RcvCount<(a.TotalLength/a.SegLength)", orgID, barCode);
DataSet dataSet = SQLHelper.ExecuteDataSet(sql);
if (dataSet == null || dataSet.Tables.Count == 0 || dataSet.Tables[0].Rows.Count == 0)
{
return(null);
}
List <ShipPlanDocDTO> resultList = new List <ShipPlanDocDTO>();
foreach (DataRow dataRow in dataSet.Tables[0].Rows)
{
ShipPlanDocDTO dto = new ShipPlanDocDTO();
dto.ItemID = TypeHelper.ConvertType <long>(dataRow["ItemID"], 0);
dto.ItemCode = TypeHelper.ConvertType <string>(dataRow["ItemCode"], string.Empty);
dto.ItemName = TypeHelper.ConvertType <string>(dataRow["ItemName"], string.Empty);
dto.ItemSPECS = TypeHelper.ConvertType <string>(dataRow["ItemSPECS"], string.Empty);
dto.ShipPlanID = TypeHelper.ConvertType <long>(dataRow["ShipPlanID"], 0);
dto.ShipPlanLineID = TypeHelper.ConvertType <long>(dataRow["ShipPlanLineID"], 0);
dto.SegLength = (int)TypeHelper.ConvertType <decimal>(dataRow["SegLength"], 0);
dto.Count = (int)TypeHelper.ConvertType <decimal>(dataRow["JCount"], 0);
dto.TotalLength = (int)TypeHelper.ConvertType <decimal>(dataRow["TotalLength"], 0);
resultList.Add(dto);
}
return(resultList);
}
catch (Exception ex)
{
PDALog.Error(ex);
throw ExceptionHelper.CreateSoapException(ex.Message, ex.Source);
}
}
public RequestResult BigCode(string code, string orderno = "")
{
RequestResult result = new RequestResult();
try
{
List <Scale> scale = Scale.GetScaleForBig(code);
if (scale.Count > 0)
{
Scale scaleDeal = scale.Where(sca => (sca.IsOut == true || sca.StateID == 9) && sca.OutWay == 3).FirstOrDefault();
if (scaleDeal != null)
{
if (scaleDeal.IsOut) // 是否已经出货
{
ScaleRtnStoke scaleRtn = new ScaleRtnStoke();
scaleRtn.BigCode = scaleDeal.BigCode;
scaleRtn.OrderNo = orderno;
scaleRtn.OperaUser = PdaUser.PUserName;
scaleRtn.IsPDAOpera = true;
scaleRtn.RtnWay = 3;
scaleDeal.BigReturnStock(scaleRtn);
result.message = "成功";
result.success = true;
}
else
{
result.message = "重复退货";
result.success = false;
}
}
else
{
result.message = "条码未出货";
result.success = false;
}
}
else
{
result.code = 304;
result.message = "条码不存在";
result.success = false;
}
PDALog.Write("大标退货", "大标", code, PdaUser.PUserName + "-" + PdaUser.PRealName, string.Format("code:{0},orderno:{1}", code, orderno), result.message);
}
catch (Exception ex)
{
result.code = 500;
result.message = "服务出错";
result.success = false;
DAL.Log.Instance.Write("大标退货出错：" + ex.Message, "PDA上传出错");
}
return(result);
}
public RequestResult SmallCode(string code, string orderno = "")
{
RequestResult result = new RequestResult();
try
{
Scale scale = Scale.GetScaleForSmall(code);
if (scale != null)
{
if (scale.IsOut) // 是否已经关联
{
scale.IsOut = false;
scale.StateID = 9;
scale.UpdateByID();
ScaleRtnStoke scaleRtn = new ScaleRtnStoke();
scaleRtn.SmallCode = scale.SmallCode;
scaleRtn.OrderNo = orderno;
scaleRtn.OperaUser = PdaUser.PUserName;
scaleRtn.IsPDAOpera = true;
scaleRtn.RtnWay = 1;
scale.SmallReturnStock(scaleRtn);
result.message = "成功";
result.success = true;
}
else if (scale.StateID == 9)
{
result.message = "重复退货";
result.success = false;
}
else
{
result.message = "条码未出货";
result.success = false;
}
}
else
{
result.code = 304;
result.message = "条码不存在";
result.success = false;
}
PDALog.Write("小标退货", "小标", code, PdaUser.PUserName + "-" + PdaUser.PRealName, string.Format("code:{0},orderno:{1}", code, orderno), result.message);
}
catch (Exception ex)
{
result.code = 500;
result.message = "服务出错";
result.success = false;
DAL.Log.Instance.Write("小标退货出错：" + ex.Message, "PDA上传出错");
}
return(result);
}
public RequestResult RemoveSmallCode(string code)
{
RequestResult result = new RequestResult();
try
{
Scale scale = Scale.GetScaleForSmall(code);
if (scale != null)
{
if (!scale.IsOut)
{
result.message = "未出货";
result.success = false;
}
else if (ScaleOutStoke.IsSubOutStock_Small(code))
{
result.message = "此条码下级已出货";
result.success = false;
}
else
{
scale.IsOut = false;
scale.OutPDAUser = ""; // PdaUser.PUserName;
scale.OutTime = 0; // CommonFunc.GetNowTimestamp();
scale.UserName = "";
scale.StateID = 6;
scale.UpdateByID();
ScaleOutStoke.DeleteOutScaleRtnState(code); // 移除出货表记录
result.message = "成功";
result.success = true;
}
}
else
{
result.code = 304;
result.message = "条码不存在";
result.success = false;
}
PDALog.Write("撤消出货", "小标", code, PdaUser.PUserName + "-" + PdaUser.PRealName, string.Format("code:{0}", code), result.message);
}
catch (Exception ex)
{
result.code = 500;
result.message = "服务出错";
result.success = false;
DAL.Log.Instance.Write("撤消小标出货出错：" + ex.Message, "PDA上传出错");
}
return(result);
}
public RequestResult RemoveBigCode(string code)
{
RequestResult result = new RequestResult();
try
{
List <Scale> scale = Scale.GetScaleForBig(code);
if (scale.Count > 0)
{
if (scale.Where(sca => sca.IsOut == true && sca.OutWay == 3).Count() == 0)
{
result.message = "未使用大标出货";
result.success = false;
}
else if (ScaleOutStoke.IsSubOutStock_BigCode(code))
{
result.message = "此条码下级已出货";
result.success = false;
}
else
{
Scale scaleDeal = scale.Where(sca => sca.IsOut == true && sca.OutWay == 3).FirstOrDefault();
scaleDeal.IsOut = false;
scaleDeal.OutPDAUser = ""; // PdaUser.PUserName;
scaleDeal.OutTime = 0; // CommonFunc.GetNowTimestamp();
scaleDeal.UserName = "";
scaleDeal.StateID = 6;
scaleDeal.RemoveBigOut();
result.message = "成功";
result.success = true;
}
}
else
{
result.code = 304;
result.message = "条码不存在";
result.success = false;
}
PDALog.Write("撤消出货", "大标", code, PdaUser.PUserName + "-" + PdaUser.PRealName, string.Format("code:{0}", code), result.message);
}
catch (Exception ex)
{
result.code = 500;
result.message = "服务出错";
result.success = false;
DAL.Log.Instance.Write("撤消大标出货出错：" + ex.Message, "PDA上传出错");
}
return(result);
}
public BarCodeInfoDTO QueryBarCodeInfo(long orgID, string barCode)
{
try
{
if (string.IsNullOrEmpty(barCode))
{
return(null);
}
string sql = string.Format(@"
select barcode.BarCode,
barcode.Item as ItemID,
item.Code as ItemCode,
item.Name as ItemName,
item.SPECS as ItemSPECS,
item.DescFlexField_PrivateDescSeg1 as ItemCheckStandard,
barcode.ActualLength,
ISNULL(op.ID, 0) as opID,
ISNULL(op.Code,'') as opCode
from Cust_CompleteApplyBarCode as barcode
left join CBO_ItemMaster as item on barcode.Item = item.ID
left join CBO_Operators as op on barcode.Operators = op.ID
where barcode.BarCode='{0}' and barcode.Org='{1}' ", barCode, orgID);
DataSet dataSet = SQLHelper.ExecuteDataSet(sql);
if (dataSet == null || dataSet.Tables.Count == 0 || dataSet.Tables[0].Rows.Count == 0)
{
return(null);
}
DataRow dataRow = dataSet.Tables[0].Rows[0];
BarCodeInfoDTO dto = new BarCodeInfoDTO();
dto.ItemID = TypeHelper.ConvertType <long>(dataRow["ItemID"], 0);
dto.ItemCode = TypeHelper.ConvertType <string>(dataRow["ItemCode"], string.Empty);
dto.ItemName = TypeHelper.ConvertType <string>(dataRow["ItemName"], string.Empty);
dto.ItemSPECS = TypeHelper.ConvertType <string>(dataRow["ItemSPECS"], string.Empty);
dto.BarCode = TypeHelper.ConvertType <string>(dataRow["BarCode"], string.Empty);
dto.ActualLength = TypeHelper.ConvertType <int>(dataRow["ActualLength"], 0);
dto.ItemCheckStandard = TypeHelper.ConvertType <string>(dataRow["ItemCheckStandard"], string.Empty);
dto.QcOperatorID = TypeHelper.ConvertType <long>(dataRow["opID"], 0);
dto.QcOperatorCode = TypeHelper.ConvertType <string>(dataRow["opCode"], string.Empty);
return(dto);
}
catch (Exception ex)
{
PDALog.Error(ex);
throw ExceptionHelper.CreateSoapException(ex.Message, ex.Source);
}
}
public void ChangePassword(string user, string newPassword)
{
try
{
if (string.IsNullOrEmpty(user))
{
return;
}
string sql = string.Format("update Base_User set Password='******' where Code='{1}'", MD5Encrypt(newPassword), user);
SQLHelper.ExecuteNonQuery(sql);
}
catch (Exception ex)
{
PDALog.Error(ex);
throw ExceptionHelper.CreateSoapException(ex.Message, ex.Source);
}
}
public List <long> AddProductBarCodesByShip(List <ProductBarCodeImportDTO> importDTOs, LoginContext context)
{
if (importDTOs == null || importDTOs.Count == 0)
{
return(null);
}
try
{
U9SVHandler.genProductBarCodeByShip(importDTOs, context);
return(null);
}
catch (Exception ex)
{
PDALog.Error(ex);
throw ExceptionHelper.CreateSoapException(ex.Message, ex.Source);
}
}
public bool LoginValidate(string user, string password)
{
try
{
if (string.IsNullOrEmpty(user))
{
return(false);
}
string sql = string.Format("select Password from Base_User where Code='{0}'", user);
string pwd = TypeHelper.ConvertType <string>(SQLHelper.ExecuteScalar(sql), string.Empty);
return(pwd == MD5Encrypt(password));
}
catch (Exception ex)
{
PDALog.Error(ex);
throw ExceptionHelper.CreateSoapException(ex.Message, ex.Source);
}
}
public List <OrgInfoDTO> QueryOrgInfo(string user)
{
try
{
string sql = string.Format(@"
select distinct org.ID as OrgID,
org.Code as OrgCode,
orgTrl.Name as OrgName
from Base_UserOrg as userOrg
inner join Base_User as users on users.ID=userOrg.[User]
inner join Base_Organization as org on userOrg.Org=org.ID
inner join Base_Organization_Trl as orgTrl on org.ID=orgTrl.ID and orgTrl.SysMLFlag='zh-CN'
where org.ID not in (101, 102)
and org.Effective_IsEffective=1
and org.Effective_EffectiveDate<='{0}'
and org.Effective_DisableDate>='{0}'
and users.Code='{1}'", DateTime.Now.Date, user);
DataSet dataSet = SQLHelper.ExecuteDataSet(sql);
if (dataSet == null || dataSet.Tables.Count == 0 || dataSet.Tables[0].Rows.Count == 0)
{
return(null);
}
List <OrgInfoDTO> orgInfoList = new List <OrgInfoDTO>();
OrgInfoDTO orgInfoDTO = null;
foreach (DataRow dataRow in dataSet.Tables[0].Rows)
{
orgInfoDTO = new OrgInfoDTO();
orgInfoDTO.OrgID = TypeHelper.ConvertType <long>(dataRow["OrgID"], 0);
orgInfoDTO.OrgCode = TypeHelper.ConvertType <string>(dataRow["OrgCode"], string.Empty);
orgInfoDTO.OrgName = TypeHelper.ConvertType <string>(dataRow["OrgName"], string.Empty);
orgInfoList.Add(orgInfoDTO);
}
return(orgInfoList);
}
catch (Exception ex)
{
PDALog.Error(ex);
throw ExceptionHelper.CreateSoapException(ex.Message, ex.Source);
}
}
public override void Process(PDALogEntryAdd packet)
{
using (packetSender.Suppress <PDALogEntryAddProcessor>())
{
Dictionary <string, PDALog.Entry> entries = PDALog.entries;
if (!entries.ContainsKey(packet.Key))
{
if (!PDALog.GetEntryData(packet.Key, out PDALog.EntryData entryData))
{
entryData = new PDALog.EntryData();
entryData.key = packet.Key;
entryData.type = PDALog.EntryType.Invalid;
}
PDALog.Entry entry = new PDALog.Entry();
entry.data = entryData;
entry.timestamp = packet.Timestamp;
entries.Add(entryData.key, entry);
}
}
}
public override void Process(PDALogEntryAdd packet)
{
using (packetSender.Suppress <PDALogEntryAddProcessor>())
{
Dictionary <string, PDALog.Entry> entries = (Dictionary <string, PDALog.Entry>)(typeof(PDALog).GetField("entries", BindingFlags.NonPublic | BindingFlags.Static).GetValue(null));
if (!entries.ContainsKey(packet.Key))
{
if (!PDALog.GetEntryData(packet.Key, out PDALog.EntryData entryData))
{
entryData = new PDALog.EntryData();
entryData.key = packet.Key;
entryData.type = PDALog.EntryType.Invalid;
}
PDALog.Entry entry = new PDALog.Entry();
entry.data = entryData;
entry.timestamp = packet.Timestamp;
entries.Add(entryData.key, entry);
}
}
}
public RequestResult GetUserInfo()
{
RequestResult result = new RequestResult();
try
{
result.data = PdaUser;
result.message = "成功";
result.success = true;
PDALog.Write("获取用户信息", "获取", "", PdaUser.PUserName + "-" + PdaUser.PRealName, "", result.message);
}
catch (Exception ex)
{
result.code = 500;
result.message = "服务出错";
result.success = false;
DAL.Log.Instance.Write("获取用户信息出错：" + ex.Message, "PDA上传出错");
}
return(result);
}
public RequestResult QueryList(string KeyWords)
{
RequestResult result = new RequestResult();
try
{
List <P_Interface> productlist = Product.GetProduct(KeyWords);
result.data = productlist;
result.message = "成功";
result.success = true;
PDALog.Write("查询产品", "查询", "", PdaUser.PUserName + "-" + PdaUser.PRealName, "", result.message);
}
catch (Exception ex)
{
result.code = 500;
result.message = "服务出错";
result.success = false;
DAL.Log.Instance.Write("查询产品列表出错：" + ex.Message, "PDA上传出错");
}
return(result);
}
public RequestResult GetUpdateNewList(int Timestamp)
{
RequestResult result = new RequestResult();
try
{
List <P_Interface> productlist = Product.GetProduct(Timestamp);
result.data = productlist;
result.message = "成功";
result.success = true;
PDALog.Write("更新产品列表", "更新", "", PdaUser.PUserName + "-" + PdaUser.PRealName, "", result.message);
}
catch (Exception ex)
{
result.code = 500;
result.message = "服务出错";
result.success = false;
DAL.Log.Instance.Write("获取最新产品列表出错：" + ex.Message, "PDA上传出错");
}
return(result);
}
public RequestResult RemoveSmallCode(string code)
{
RequestResult result = new RequestResult();
try
{
Scale scale = Scale.GetScaleForSmall(code);
if (scale != null)
{
if (!scale.IsInto)
{
result.message = "未入库";
result.success = false;
}
else if (scale.IsLinkMid || scale.IsLinkBig) // 是否已经关联
{
result.message = "已关联";
result.success = false;
}
else if (scale.IsOut)
{
result.message = "已出货";
result.success = false;
}
else if (scale.StateID == 9)
{
result.message = "退货无法撤消";
result.success = false;
}
else
{
scale.IsInto = false;
scale.IntoPDAUser = ""; // PdaUser.PUserName;
scale.IntoTime = 0; // CommonFunc.GetNowTimestamp();
scale.ProductNo = "";
scale.StateID = scale.IsLinkBig ? 3 : scale.IsLinkMid ? 2 : 0;
scale.UpdateByID();
result.message = "成功";
result.success = true;
}
}
else
{
result.code = 304;
result.message = "条码不存在";
result.success = false;
}
PDALog.Write("撤消入库", "小标", code, PdaUser.PUserName + "-" + PdaUser.PRealName, string.Format("code:{0}", code), result.message);
}
catch (Exception ex)
{
result.code = 500;
result.message = "服务出错";
result.success = false;
DAL.Log.Instance.Write("撤消小标入库出错：" + ex.Message, "PDA上传出错");
}
return(result);
}
public RequestResult BigCode(string code, string pno, string orderno = "", int supplierid = 0)
{
RequestResult result = new RequestResult();
try
{
if ((PDAUserMsg.Param.ScanProcess == 1 || PDAUserMsg.Param.ScanProcess == 2 || PDAUserMsg.Param.ScanProcess == 3 || PDAUserMsg.Param.ScanProcess == 4) && PDAUserMsg.Param.IsInto && PDAUserMsg.Param.BigInto)
{
if (supplierid == 0 && PDAUserMsg.Param.IsIntoSupplier)
{
result.message = "请选择供应商";
result.success = false;
}
else if (string.IsNullOrWhiteSpace(pno) && PDAUserMsg.Param.IsOutProduct)
{
result.message = "请选择产品";
result.success = false;
}
else if (Product.IsSysProduct(pno))
{
List <Scale> scale = Scale.GetScaleForBig(code);
if (scale.Count > 0)
{
if (scale.Where(sca => sca.IsInto == true).Count() > 0)
{
result.message = "重复入库";
result.success = false;
}
else
{
Scale scaleDeal = scale.Where(sca => sca.IsInto == false).FirstOrDefault();
scaleDeal.IsInto = true;
scaleDeal.IntoPDAUser = PdaUser.PUserName;
scaleDeal.ProductNo = pno;
scaleDeal.IntoOrderNo = orderno;
scaleDeal.SupplierId = supplierid;
scaleDeal.IntoTime = CommonFunc.GetNowTimestamp();
scaleDeal.StateID = 6;
scaleDeal.BigIntoStock();
result.message = "成功";
result.success = true;
}
}
else
{
result.code = 304;
result.message = "条码不存在";
result.success = false;
}
}
else
{
result.code = 504;
result.message = "产品错误";
result.success = false;
}
}
else
{
result.code = 704;
result.message = "此入库功能已被禁用，请在管理后台开启。";
result.success = false;
}
PDALog.Write("大标入库", "大标", code, PdaUser.PUserName + "-" + PdaUser.PRealName, string.Format("code:{0}, pno:{1}, orderno:{2},supplierid:{3}", code, pno, orderno, supplierid), result.message);
}
catch (Exception ex)
{
result.code = 500;
result.message = "服务出错";
result.success = false;
DAL.Log.Instance.Write("大标入库出错：" + ex.Message, "PDA上传出错");
}
return(result);
}
public RequestResult SmallCode(string code, string pno, string orderno = "", int supplierid = 0)
{
RequestResult result = new RequestResult();
try
{
// 权限功能控制
if ((PDAUserMsg.Param.ScanProcess == 1 || PDAUserMsg.Param.ScanProcess == 2 || PDAUserMsg.Param.ScanProcess == 3 || PDAUserMsg.Param.ScanProcess == 4) && PDAUserMsg.Param.IsInto && PDAUserMsg.Param.SmallInto)
{
if (supplierid == 0 && PDAUserMsg.Param.IsIntoSupplier)
{
result.message = "请选择供应商";
result.success = false;
}
else if (string.IsNullOrWhiteSpace(pno) && PDAUserMsg.Param.IsOutProduct)
{
result.message = "请选择产品";
result.success = false;
}
else if (Product.IsSysProduct(pno))
{
Scale scale = Scale.GetScaleForSmall(code);
if (scale != null)
{
if (scale.IsLinkMid || scale.IsLinkBig) // 是否已经关联
{
result.message = "已关联, 无法单标入货";
result.success = false;
}
else
{
if (scale.IsInto)
{
result.message = "重复入库";
result.success = false;
}
else
{
scale.IsInto = true;
scale.IntoPDAUser = PdaUser.PUserName;
scale.ProductNo = pno;
scale.IntoOrderNo = orderno;
scale.SupplierId = supplierid;
scale.IntoTime = CommonFunc.GetNowTimestamp();
scale.StateID = 6;
scale.UpdateByID();
result.message = "成功";
result.success = true;
}
}
}
else
{
result.code = 304;
result.message = "条码不存在";
result.success = false;
}
}
else
{
result.code = 504;
result.message = "产品错误";
result.success = false;
}
}
else
{
result.code = 704;
result.message = "此入库功能已被禁用，请在管理后台开启。";
result.success = false;
}
PDALog.Write("小标入库", "小标", code, PdaUser.PUserName + "-" + PdaUser.PRealName, string.Format("code:{0}, pno:{1}, orderno:{2},supplierid:{3}", code, pno, orderno, supplierid), result.message);
}
catch (Exception ex)
{
result.code = 500;
result.message = "服务出错";
result.success = false;
DAL.Log.Instance.Write("小标入库出错：" + ex.Message, "PDA上传出错");
}
return(result);
}
