public string GetMessageForPrint(string filter, string flag)
{
BaseMessage_Model <List <T_BoxingInfo> > model = new BaseMessage_Model <List <T_BoxingInfo> >();
List <T_BoxingInfo> modelList = new List <T_BoxingInfo>();
try
{
if (string.IsNullOrEmpty(filter))
{
model.HeaderStatus = "E";
model.Message = "客户端传来的条码为空！";
return(JSONHelper.ObjectToJson <BaseMessage_Model <List <T_BoxingInfo> > >(model));
}
T_Box_DB db = new Box.T_Box_DB();
modelList = db.GetMessageForPrint(filter, flag);
model.HeaderStatus = "S";
model.ModelJson = modelList;
return(JSONHelper.ObjectToJson <BaseMessage_Model <List <T_BoxingInfo> > >(model));
}
catch (Exception ex)
{
model.HeaderStatus = "E";
model.Message = ex.Message;
return(JSONHelper.ObjectToJson <BaseMessage_Model <List <T_BoxingInfo> > >(model));
}
}
public string SaveTaskwithandmark(string ModelJson, string UserJson)
{
BaseMessage_Model <string> messageModel = new BaseMessage_Model <string>();
try
{
if (string.IsNullOrEmpty(ModelJson))
{
messageModel.HeaderStatus = "E";
messageModel.Message = "传入的信息为空！";
return(JSONHelper.ObjectToJson <BaseMessage_Model <string> >(messageModel));
}
UserModel user = JsonConvert.DeserializeObject <UserModel>(UserJson); //JSONUtil.JSONHelper.JsonToObject<User.UserModel>(UserJson);
T_LandMarkWithTaskInfo landMarkWithTaskInfo = JsonConvert.DeserializeObject <T_LandMarkWithTaskInfo>(ModelJson); //JSONUtil.JSONHelper.JsonToObject<User.UserModel>(UserJson);
T_LandMarkWithTask_DB tdb = new T_LandMarkWithTask_DB();
string strmsg = "";
if (!tdb.SaveTaskwithandmark(landMarkWithTaskInfo, user, ref strmsg))
{
messageModel.HeaderStatus = "E";
messageModel.Message = strmsg;
return(JSONHelper.ObjectToJson <BaseMessage_Model <string> >(messageModel));
}
messageModel.HeaderStatus = "S";
return(JSONHelper.ObjectToJson <BaseMessage_Model <string> >(messageModel));
}
catch (Exception ex)
{
messageModel.HeaderStatus = "E";
messageModel.Message = ex.Message;
return(JSONHelper.ObjectToJson <BaseMessage_Model <string> >(messageModel));
}
}
public string GetPalletnoForU9(string ErpVoucherNo)
{
BaseMessage_Model <string> messageModel = new BaseMessage_Model <string>();
try
{
T_OutTaskDetails_DB _db = new T_OutTaskDetails_DB();
string palletno = _db.GetPalletnoForU9(ErpVoucherNo);
if (palletno == "" || palletno == null)
{
messageModel.HeaderStatus = "E";
messageModel.Message = "没有找到对应的托盘号！";
return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <string> >(messageModel));
}
else
{
messageModel.HeaderStatus = "S";
messageModel.ModelJson = palletno;
return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <string> >(messageModel));
}
}
catch (Exception ex)
{
messageModel.HeaderStatus = "E";
messageModel.Message = ex.Message;
return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <string> >(messageModel));
}
}
public string CheckSerialNoInStock(string SerialNo)
{
BaseMessage_Model <T_SerialNoInfo> model = new BaseMessage_Model <T_SerialNoInfo>();
try
{
bool bSucc = false;
string strError = string.Empty;
T_SerialNo_DB db = new T_SerialNo_DB();
bSucc = db.CheckSerialNoInStock(SerialNo, ref strError);
if (bSucc == true)
{
model.HeaderStatus = "S";
}
else
{
model.HeaderStatus = "E";
model.Message = strError;
}
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_SerialNoInfo> >(model));
}
catch (Exception ex)
{
model.HeaderStatus = "E";
model.Message = ex.Message;
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_SerialNoInfo> >(model));
}
}
public string GetOffList(string ErpVoucherno)
{
LogNet.LogInfo("发货清单：" + ErpVoucherno);
BaseMessage_Model <List <OffList> > model = new BaseMessage_Model <List <OffList> >();
try
{
List <OffList> list = new List <OffList>();
T_OutBarcode_DB _db = new T_OutBarcode_DB();
if (!_db.GetOffList(ErpVoucherno, ref list))
{
model.HeaderStatus = "E";
model.Message = "获取数据失败！";
return(JSONHelper.ObjectToJson <BaseMessage_Model <List <OffList> > >(model));
}
model.HeaderStatus = "S";
model.ModelJson = list;
return(JSONHelper.ObjectToJson <BaseMessage_Model <List <OffList> > >(model));
}
catch (Exception ex)
{
model.HeaderStatus = "E";
model.Message = ex.Message;
return(JSONHelper.ObjectToJson <BaseMessage_Model <List <OffList> > >(model));
}
}
public string GetLandmark(string landmarkno, string UserJson)
{
BaseMessage_Model <T_LandMarkInfo> messageModel = new BaseMessage_Model <T_LandMarkInfo>();
try
{
if (string.IsNullOrEmpty(landmarkno))
{
messageModel.HeaderStatus = "E";
messageModel.Message = "传入的地标号为空！";
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_LandMarkInfo> >(messageModel));
}
T_LandMark_DB tdb = new T_LandMark_DB();
T_LandMarkInfo model = tdb.Getlandmark(landmarkno);
if (model == null)
{
messageModel.HeaderStatus = "E";
messageModel.Message = "获取信息失败！";
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_LandMarkInfo> >(messageModel));
}
messageModel.HeaderStatus = "S";
messageModel.ModelJson = model;
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_LandMarkInfo> >(messageModel));
}
catch (Exception ex)
{
messageModel.HeaderStatus = "E";
messageModel.Message = ex.Message;
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_LandMarkInfo> >(messageModel));
}
}
public string GetOutBarCodeForYS(string BarCode)
{
BaseMessage_Model <T_OutBarCodeInfo> model = new BaseMessage_Model <T_OutBarCodeInfo>();
try
{
string strError = string.Empty;
T_OutBarcode_DB _db = new T_OutBarcode_DB();
T_OutBarCodeInfo BarCodeInfomodel = _db.GetOutBarCodeForYS(BarCode);
if (BarCodeInfomodel == null)
{
model.HeaderStatus = "E";
model.Message = "您扫描的条码不存在！请确认是否已经打印！";
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_OutBarCodeInfo> >(model));
}
model.HeaderStatus = "S";
model.ModelJson = BarCodeInfomodel;
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_OutBarCodeInfo> >(model));
}
catch (Exception ex)
{
model.HeaderStatus = "E";
model.Message = ex.Message;
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_OutBarCodeInfo> >(model));
}
}
/// <summary>
///分配拣货任务对应拣货人
/// </summary>
/// <param name="UserJson"></param>
/// <param name="ModelJson"></param>
/// <returns></returns>
public string SavePickUserListADF(string UserJson, string ModelJson)
{
BaseMessage_Model <List <T_OutStockTaskInfo> > messageModel = new BaseMessage_Model <List <T_OutStockTaskInfo> >();
try
{
string strError = string.Empty;
if (string.IsNullOrEmpty(UserJson))
{
messageModel.HeaderStatus = "E";
messageModel.Message = "用户端传来用户JSON为空！";
return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <List <T_OutStockTaskInfo> > >(messageModel));
}
if (string.IsNullOrEmpty(ModelJson))
{
messageModel.HeaderStatus = "E";
messageModel.Message = "客户端传来拣货单JSON为空！";
return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <List <T_OutStockTaskInfo> > >(messageModel));
}
List <UserModel> UserList = JSONHelper.JsonToObject <List <UserModel> > (UserJson);
if (UserList == null || UserList.Count == 0)
{
messageModel.HeaderStatus = "E";
messageModel.Message = "用户JSON转换用户列表为空！";
return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <List <T_OutStockTaskInfo> > >(messageModel));
}
List <T_OutStockTaskInfo> modelList = JSONHelper.JsonToObject <List <T_OutStockTaskInfo> >(ModelJson);
if (modelList == null || modelList.Count == 0)
{
messageModel.HeaderStatus = "E";
messageModel.Message = "拣货单JSON转换拣货单列表为空！";
return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <List <T_OutStockTaskInfo> > >(messageModel));
}
T_OutStockTask_DB _db = new T_OutStockTask_DB();
if (_db.SavePickUserList(UserList, modelList, ref strError) == false)
{
messageModel.HeaderStatus = "E";
messageModel.Message = strError;
return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <List <T_OutStockTaskInfo> > >(messageModel));
}
else
{
messageModel.HeaderStatus = "S";
messageModel.Message = "拣货任务分配成功！";
return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <List <T_OutStockTaskInfo> > >(messageModel));
}
}
catch (Exception ex)
{
messageModel.HeaderStatus = "E";
messageModel.Message = ex.Message;
return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <List <T_OutStockTaskInfo> > >(messageModel));
}
}
public string YSPost(string UserJson, string ModelJson)
{
BaseMessage_Model <string> messageModel = new BaseMessage_Model <string>();
try
{
List <T_YSDetailInfo> modelList = JSONHelper.JsonToObject <List <T_YSDetailInfo> >(ModelJson);
UserModel user = JSONHelper.JsonToObject <UserModel>(UserJson);
string strError = "";
T_YSDetail_DB db = new T_YSDetail_DB();
if (db.YSPost(user, modelList, ref strError) == false)
{
messageModel.HeaderStatus = "E";
messageModel.Message = "原因：" + strError + "。保存失败！";
return(JSONHelper.ObjectToJson <BaseMessage_Model <string> >(messageModel));
}
messageModel.HeaderStatus = "S";
messageModel.Message = "保存成功！";
return(JSONHelper.ObjectToJson <BaseMessage_Model <string> >(messageModel));
}
catch (Exception ex)
{
messageModel.HeaderStatus = "E";
messageModel.Message = "原因：" + ex.ToString() + "。保存失败！";
return(JSONHelper.ObjectToJson <BaseMessage_Model <string> >(messageModel));
}
}
public string GetMaterialModelBySqlADF(string MaterialNo)
{
BaseMessage_Model <T_MaterialInfo> messageModel = new BaseMessage_Model <T_MaterialInfo>();
try
{
string strError = string.Empty;
T_MaterialInfo model = new T_MaterialInfo();
model.MaterialNo = MaterialNo;
bool bSucc = base.GetModelBySql(ref model, ref strError);
if (bSucc == false)
{
messageModel.HeaderStatus = "E";
messageModel.Message = strError;
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_MaterialInfo> >(messageModel));
}
messageModel.HeaderStatus = "S";
messageModel.ModelJson = model;
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_MaterialInfo> >(messageModel));
}
catch (Exception ex)
{
messageModel.HeaderStatus = "E";
messageModel.Message = ex.Message;
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_MaterialInfo> >(messageModel));
}
}
public string GetBarCodeFirst(string ReceiveTime)
{
BaseMessage_Model <List <T_OutBarCodeInfo> > model = new BaseMessage_Model <List <T_OutBarCodeInfo> >();
try
{
T_OutBarcode_DB _db = new T_OutBarcode_DB();
List <T_OutBarCodeInfo> list = new List <T_OutBarCodeInfo>();
if (!_db.GetBarCodeFirst(ReceiveTime, ref list))
{
model.HeaderStatus = "E";
model.Message = "获取数据失败！";
return(JSONHelper.ObjectToJson <BaseMessage_Model <List <T_OutBarCodeInfo> > >(model));
}
model.HeaderStatus = "S";
model.ModelJson = list;
return(JSONHelper.ObjectToJson <BaseMessage_Model <List <T_OutBarCodeInfo> > >(model));
}
catch (Exception ex)
{
model.HeaderStatus = "E";
model.Message = ex.Message;
return(JSONHelper.ObjectToJson <BaseMessage_Model <List <T_OutBarCodeInfo> > >(model));
}
}
public string GetBarCodeSerialno(string Serialno)
{
BaseMessage_Model <List <T_OutBarCodeInfo> > model = new BaseMessage_Model <List <T_OutBarCodeInfo> >();
try
{
List <T_OutBarCodeInfo> list = new List <T_OutBarCodeInfo>();
T_OutBarCodeInfo outbarcdemodel = new T_OutBarCodeInfo();
string strmsg = "";
if (!GetOutBarCodeInfoBySerialNo(Serialno, ref outbarcdemodel, ref strmsg))
{
model.HeaderStatus = "E";
model.Message = "获取数据失败！";
return(JSONHelper.ObjectToJson <BaseMessage_Model <List <T_OutBarCodeInfo> > >(model));
}
list.Add(outbarcdemodel);
model.HeaderStatus = "S";
model.ModelJson = list;
return(JSONHelper.ObjectToJson <BaseMessage_Model <List <T_OutBarCodeInfo> > >(model));
}
catch (Exception ex)
{
model.HeaderStatus = "E";
model.Message = ex.Message;
return(JSONHelper.ObjectToJson <BaseMessage_Model <List <T_OutBarCodeInfo> > >(model));
}
}
public string GetTransportSupplierDetailList(string Palletno)
{
BaseMessage_Model <List <T_TransportSupDetailInfo> > messageModel = new BaseMessage_Model <List <T_TransportSupDetailInfo> >();
try
{
T_TransportSupdetail_DB _db = new T_TransportSupdetail_DB();
List <T_TransportSupDetailInfo> modelList = _db.GetTransportSupplierDetailList(Palletno);
if (modelList == null || modelList.Count == 0)
{
messageModel.Message = "没有获取到装车信息！";
messageModel.HeaderStatus = "E";
return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <List <T_TransportSupDetailInfo> > >(messageModel));
}
messageModel.HeaderStatus = "S";
messageModel.ModelJson = modelList;
return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <List <T_TransportSupDetailInfo> > >(messageModel));
}
catch (Exception ex)
{
messageModel.Message = ex.Message;
messageModel.HeaderStatus = "E";
return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <List <T_TransportSupDetailInfo> > >(messageModel));
}
}
public string getMaterialsADF(T_MaterialInfo material)
{
BaseMessage_Model <List <T_MaterialInfo> > messageModel = new BaseMessage_Model <List <T_MaterialInfo> >();
T_Material_DB mdb = new T_Material_DB();
try
{
List <T_MaterialInfo> modelList = mdb.getListMaterial(material);
if (modelList == null || modelList.Count == 0)
{
messageModel.HeaderStatus = "E";
messageModel.Message = "获取物料数据列表为空！";
}
else
{
messageModel.HeaderStatus = "S";
messageModel.ModelJson = modelList;
}
return(JsonConvert.SerializeObject(messageModel));
}
catch (Exception ex)
{
messageModel.HeaderStatus = "E";
messageModel.Message = ex.Message;
messageModel.ModelJson = null;
return(JsonConvert.SerializeObject(messageModel));
}
}
public string GetStrongholdList()
{
BaseMessage_Model <U9BaseInfo> messageModel = new BaseMessage_Model <U9BaseInfo>();
try
{
T_Material_Batch_DB _db = new T_Material_Batch_DB();
U9BaseInfo BaseInfo = new U9BaseInfo();
BaseInfo = _db.GetStrongholdList();
if (BaseInfo == null)
{
messageModel.HeaderStatus = "E";
messageModel.Message = "获取失败";
return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <U9BaseInfo> >(messageModel));
}
else
{
messageModel.HeaderStatus = "S";
messageModel.ModelJson = BaseInfo;
return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <U9BaseInfo> >(messageModel));
}
}
catch (Exception ex)
{
messageModel.HeaderStatus = "E";
messageModel.Message = ex.Message;
return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <U9BaseInfo> >(messageModel));
}
}
public string CloseProduct(string ErpVoucherno)
{
BaseMessage_Model <string> messageModel = new BaseMessage_Model <string>();
try
{
T_Product_DB ProD = new T_Product_DB();
if (ProD.CloseProduct(ErpVoucherno))
{
messageModel.HeaderStatus = "S";
messageModel.Message = "成功！";
return(JsonConvert.SerializeObject(messageModel));
}
messageModel.HeaderStatus = "E";
messageModel.Message = "传入参数不能为空！";
return(JsonConvert.SerializeObject(messageModel));
}
catch (Exception ex)
{
messageModel.HeaderStatus = "E";
messageModel.Message = ex.ToString();
return(JsonConvert.SerializeObject(messageModel));
}
}
public string GetT_MaterialPackADF(string advInStockmodel)
{
T_AdvInStockInfo advInstock = JSONHelper.JsonToObject <T_AdvInStockInfo>(advInStockmodel);
T_AdvInStock_DB db = new T_AdvInStock_DB();
UserInfo user = new UserInfo();
user.UserNo = advInstock.Creater;
string errMsg = "";
BaseMessage_Model <List <T_AdvInStockInfo> > model = new BaseMessage_Model <List <T_AdvInStockInfo> >();
try
{
return("");
//if (db.SaveModelBySqlToDB2(user, advInstock, ref errMsg))
//{
// model.HeaderStatus = "S";
// model.Message = "保存成功！";
// return JSONHelper.ObjectToJson<BaseMessage_Model<List<T_AdvInStockInfo>>>(model);
//}
//else
//{
// model.HeaderStatus = "E";
// model.Message = errMsg;
// return JSONHelper.ObjectToJson<BaseMessage_Model<List<T_AdvInStockInfo>>>(model);
//}
}
catch (Exception ex)
{
model.HeaderStatus = "E";
model.Message = "保存异常！" + ex.ToString();
return(JSONHelper.ObjectToJson <BaseMessage_Model <List <T_AdvInStockInfo> > >(model));
}
}
public string GetTaskForLandmark(string barcode, string UserJson)
{
BaseMessage_Model <T_LandMarkWithTaskInfo> messageModel = new BaseMessage_Model <T_LandMarkWithTaskInfo>();
try
{
if (string.IsNullOrEmpty(barcode))
{
messageModel.HeaderStatus = "E";
messageModel.Message = "传入的条码为空！";
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_LandMarkWithTaskInfo> >(messageModel));
}
T_LandMarkWithTask_DB tdb = new T_LandMarkWithTask_DB();
T_LandMarkWithTaskInfo model = new T_LandMarkWithTaskInfo();
string strmsg = "";
if (!tdb.GetTaskForLandmark(barcode, ref model, ref strmsg))
{
messageModel.HeaderStatus = "E";
messageModel.Message = strmsg;
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_LandMarkWithTaskInfo> >(messageModel));
}
messageModel.HeaderStatus = "S";
messageModel.ModelJson = model;
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_LandMarkWithTaskInfo> >(messageModel));
}
catch (Exception ex)
{
messageModel.HeaderStatus = "E";
messageModel.Message = ex.Message;
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_LandMarkWithTaskInfo> >(messageModel));
}
}
/// <summary>
/// 质检扫描--------------add by cym 2017-12-14
/// </summary>
/// <param name="BarCode"></param>
/// <returns></returns>
public string GetOutBarCodeInfoForQuanADF_Product(string BarCode)
{
BaseMessage_Model <T_StockInfo> model = new BaseMessage_Model <T_StockInfo>();
try
{
string strError = string.Empty;
string SerialNo = string.Empty;
string BarCodeType = string.Empty;
T_OutBarCodeInfo BarCodeInfo = new T_OutBarCodeInfo();
T_OutBarCode_Func tfunc = new T_OutBarCode_Func();
//验证条码正确性
if (tfunc.GetSerialNoByBarCode(BarCode, ref SerialNo, ref BarCodeType, ref strError) == false)
{
model.HeaderStatus = "E";
model.Message = strError;
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_StockInfo> >(model));
}
if (BarCodeType == "2")
{
model.HeaderStatus = "E";
model.Message = "托盘条码不支持整托操作！";
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_StockInfo> >(model));
}
T_StockInfo stockModel = new T_StockInfo();
BarCodeInfo.SerialNo = SerialNo;
//读取条码库存数据
if (GetBarCodeIsStock(BarCodeInfo.SerialNo, ref stockModel, ref strError) == false)
{
model.HeaderStatus = "E";
model.Message = strError;
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_StockInfo> >(model));
}
//update by cym 2018-1-4
if (stockModel.Status != 1)
{
model.HeaderStatus = "E";
model.Message = "该条码不是待检状态，不能取样！";
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_StockInfo> >(model));
}
model.HeaderStatus = "S";
model.ModelJson = stockModel;
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_StockInfo> >(model));
}
catch (Exception ex)
{
model.HeaderStatus = "E";
model.Message = ex.Message;
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_StockInfo> >(model));
}
}
/// <summary>
/// android扫描并提交绑定拣选小车
/// </summary>
/// <param name="strCarNo"></param>
/// <param name="strTaskNo"></param>
/// <param name="strUserNo"></param>
/// <returns></returns>
public string GetCarModelADF(string strCarNo, string strTaskNo, string strUserNo)
{
BaseMessage_Model <T_OutStockTaskDetailsInfo> messageModel = new BaseMessage_Model <T_OutStockTaskDetailsInfo>();
try
{
string strError = string.Empty;
if (string.IsNullOrEmpty(strCarNo))
{
messageModel.HeaderStatus = "E";
messageModel.Message = "客户端传来小车编号为空！";
return(JsonConvert.SerializeObject(messageModel));
}
if (string.IsNullOrEmpty(strTaskNo))
{
messageModel.HeaderStatus = "E";
messageModel.Message = "客户端传来任务号为空！";
return(JsonConvert.SerializeObject(messageModel));
}
T_OutTaskDetails_DB db = new T_OutTaskDetails_DB();
if (db.GetCarNo(strCarNo) == 0)
{
messageModel.HeaderStatus = "E";
messageModel.Message = "小车编号不存在！";
return(JsonConvert.SerializeObject(messageModel));
}
string taskno = db.PostScanCar(strCarNo);
if (!string.IsNullOrEmpty(taskno) && taskno != strTaskNo)
{
messageModel.HeaderStatus = "E";
messageModel.Message = "拣货车被拣货单占用,拣货单号" + taskno;
return(JsonConvert.SerializeObject(messageModel));
}
if (db.PostBindCarTask(strCarNo, strTaskNo, strUserNo, ref strError) == false)
{
messageModel.HeaderStatus = "E";
messageModel.Message = strError;
return(JsonConvert.SerializeObject(messageModel));
}
messageModel.HeaderStatus = "S";
return(JsonConvert.SerializeObject(messageModel));
}
catch (Exception ex)
{
messageModel.HeaderStatus = "E";
messageModel.Message = ex.Message;
return(JsonConvert.SerializeObject(messageModel));
}
}
public string GetAreaModelBySqlADF(string UserJson, string AreaNo)
{
BaseMessage_Model <T_AreaInfo> messageModel = new BaseMessage_Model <T_AreaInfo>();
try
{
string strError = string.Empty;
T_AreaInfo model = new T_AreaInfo();
if (string.IsNullOrEmpty(UserJson))
{
messageModel.HeaderStatus = "E";
messageModel.Message = "客户端传来用户JSON为空！";
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_AreaInfo> >(messageModel));
}
if (string.IsNullOrEmpty(AreaNo))
{
messageModel.HeaderStatus = "E";
messageModel.Message = "客户端传来库位编码为空！";
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_AreaInfo> >(messageModel));
}
UserModel userModel = JSONHelper.JsonToObject <UserModel>(UserJson);
model.WarehouseID = userModel.WarehouseID;
model.AreaNo = AreaNo;
bool bSucc = base.GetModelBySql(ref model, ref strError);
if (bSucc == false)
{
messageModel.HeaderStatus = "E";
messageModel.Message = strError;
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_AreaInfo> >(messageModel));
}
if (model.AreaStatus == 2)
{
messageModel.HeaderStatus = "E";
messageModel.Message = "该库位已被锁定";
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_AreaInfo> >(messageModel));
}
messageModel.HeaderStatus = "S";
messageModel.ModelJson = model;
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_AreaInfo> >(messageModel));
}
catch (Exception ex)
{
messageModel.HeaderStatus = "E";
messageModel.Message = ex.Message;
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_AreaInfo> >(messageModel));
}
}
public string UnLockTaskOperUser(string TaskOutStockModelJson, string UserJson)
{
BaseMessage_Model <T_OutStockTaskInfo> messageModel = new BaseMessage_Model <T_OutStockTaskInfo>();
try
{
int iLock = 0;
string strUserName = string.Empty;
if (string.IsNullOrEmpty(TaskOutStockModelJson))
{
messageModel.HeaderStatus = "E";
messageModel.Message = "客户端传来业务JSON为空";
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_OutStockTaskInfo> >(messageModel));
}
T_OutStockTaskInfo taskDetailsModel = BILBasic.JSONUtil.JSONHelper.JsonToObject <T_OutStockTaskInfo>(TaskOutStockModelJson);
if (taskDetailsModel == null)
{
messageModel.HeaderStatus = "E";
messageModel.Message = "转换实体类为空！";
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_OutStockTaskInfo> >(messageModel));
}
UserModel user = JSONHelper.JsonToObject <UserModel>(UserJson);
if (user == null || string.IsNullOrEmpty(user.UserNo))
{
messageModel.HeaderStatus = "E";
messageModel.Message = "没有用户信息";
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_OutStockTaskInfo> >(messageModel));
}
T_OutStockTask_DB _db = new T_OutStockTask_DB();
iLock = _db.UnLockTaskOperUser(user, taskDetailsModel);
//if (iLock == 0)
//{
// messageModel.HeaderStatus = "E";
// messageModel.Message = "任务：" + taskDetailsModel.TaskNo + "解锁失败！";
// return JSONHelper.ObjectToJson<BaseMessage_Model<T_OutStockTaskInfo>>(messageModel);
//}
messageModel.HeaderStatus = "S";
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_OutStockTaskInfo> >(messageModel));
}
catch (Exception ex)
{
messageModel.HeaderStatus = "E";
messageModel.Message = ex.Message;
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_OutStockTaskInfo> >(messageModel));
}
}
public string LockTaskOperUser(string TaskDetailsJson, string UserJson)
{
BaseMessage_Model <T_InStockTaskDetailsInfo> messageModel = new BaseMessage_Model <T_InStockTaskDetailsInfo>();
try
{
int iLock = 0;
string strUserName = string.Empty;
T_InStockTaskDetailsInfo taskDetailsModel = BILBasic.JSONUtil.JSONHelper.JsonToObject <T_InStockTaskDetailsInfo>(TaskDetailsJson);
if (taskDetailsModel == null || (string.IsNullOrEmpty(taskDetailsModel.MaterialNo) && string.IsNullOrEmpty(taskDetailsModel.TMaterialNo)))
{
messageModel.HeaderStatus = "E";
messageModel.Message = "没有物料信息";
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_InStockTaskDetailsInfo> >(messageModel));
}
UserModel user = JSONHelper.JsonToObject <UserModel>(UserJson);
if (user == null || string.IsNullOrEmpty(user.UserNo))
{
messageModel.HeaderStatus = "E";
messageModel.Message = "没有用户信息";
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_InStockTaskDetailsInfo> >(messageModel));
}
T_InTaskDetails_DB _db = new T_InTaskDetails_DB();
strUserName = _db.QueryUserNameByTaskDetails(taskDetailsModel, user);
if (!string.IsNullOrEmpty(strUserName))
{
messageModel.HeaderStatus = "E";
messageModel.Message = "物料：" + taskDetailsModel.MaterialNo + taskDetailsModel.TMaterialNo + "\r\n" + "被：" + strUserName + "锁定！";
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_InStockTaskDetailsInfo> >(messageModel));
}
iLock = _db.LockTaskOperUser(user, taskDetailsModel);
if (iLock == 0)
{
messageModel.HeaderStatus = "E";
messageModel.Message = "物料：" + taskDetailsModel.MaterialNo + "锁定失败！";
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_InStockTaskDetailsInfo> >(messageModel));
}
messageModel.HeaderStatus = "S";
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_InStockTaskDetailsInfo> >(messageModel));
}
catch (Exception ex)
{
messageModel.HeaderStatus = "E";
messageModel.Message = ex.Message;
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_InStockTaskDetailsInfo> >(messageModel));
}
}
public bool PostQuality(UserModel userModel, List <T_StockInfo> modelList, ref string strError, ref string QualityNo)
{
try
{
BaseMessage_Model <List <T_StockInfo> > model = new BaseMessage_Model <List <T_StockInfo> >();
bool bSucc = false;
string strUserNo = string.Empty;
modelList = GroupInstockDetailList(modelList);
//if (TOOL.RegexMatch.isExists(userModel.UserNo) == true)
//{
// strUserNo = userModel.UserNo.Substring(0, userModel.UserNo.Length - 1);
//}
//else
//{
// strUserNo = userModel.UserNo;
//}
////确定过账人，根据登录账户以及操作的订单据点来确定
//User_DB _db = new User_DB();
//string strPostUser = _db.GetPostAccountByUserNo(strUserNo, modelList[0].StrongHoldCode);
modelList.ForEach(t => t.VoucherType = 20);
modelList.ForEach(t => t.PostUser = userModel.UserNo);//strPostUser
T_Interface_Func tfunc = new T_Interface_Func();
string ERPJson = BILBasic.JSONUtil.JSONHelper.ObjectToJson <List <T_StockInfo> >(modelList);
string interfaceJson = tfunc.PostModelListToInterface(ERPJson);
model = BILBasic.JSONUtil.JSONHelper.JsonToObject <BaseMessage_Model <List <T_StockInfo> > >(interfaceJson);
//过账失败直接返回
if (model.HeaderStatus == "E" && !string.IsNullOrEmpty(model.Message))
{
strError = "生成检验单失败！" + model.Message;
bSucc = false;
}
else if (model.HeaderStatus == "S" && !string.IsNullOrEmpty(model.MaterialDoc))
{
strError = "检验单生成成功！检验单号：" + model.MaterialDoc;
QualityNo = model.MaterialDoc;
bSucc = true;
}
return(bSucc);
}
catch (Exception ex)
{
strError = ex.Message;
return(false);
}
}
//获取盘点单号
public string GetPDNoAndroid()
{
string no = GetTableID("SEQ_CHECK_NO");
BaseMessage_Model <string> bm = new BaseMessage_Model <string>();
bm.HeaderStatus = "S";
bm.Message = "";
bm.ModelJson = no;
string j = Check_Func.SerializeObject(bm);
return(j);
}
private BaseMessage_Model <T_InStockDetailInfo> PostReceiveToERP(UserModel user, List <T_InStockDetailInfo> lstDetail)
{
T_InStockDetail_Func tfunc = new T_InStockDetail_Func();
string UserJson = JSONHelper.ObjectToJson <UserModel>(user);
string ModelJson = JSONHelper.ObjectToJson <List <T_InStockDetailInfo> >(lstDetail);
string Result = tfunc.SaveModelListSqlToDBADF(UserJson, ModelJson);
BaseMessage_Model <T_InStockDetailInfo> baseMessage = JSONHelper.JsonToObject <BaseMessage_Model <T_InStockDetailInfo> >(Result);
return(baseMessage);
}
/// <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));
}
public string PostZhMove(string UserJson, string List, string Order, string Type, string Guid)
{
BaseMessage_Model <string> messageModel = new BaseMessage_Model <string>();
string strMsg = "";
try
{
if (Guid != "")
{
if (!CheckGuid(Guid, ref strMsg))
{
messageModel.HeaderStatus = "E";
messageModel.Message = "GUID已经存在，不能重复提交-" + strMsg;
return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <string> >(messageModel));
}
}
if (string.IsNullOrEmpty(UserJson) || string.IsNullOrEmpty(List) || string.IsNullOrEmpty(Order) || string.IsNullOrEmpty(Type))
{
messageModel.HeaderStatus = "E";
messageModel.Message = "参数不能为空";
return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <string> >(messageModel));
}
List <T_StockInfo> modelList = JSONHelper.JsonToObject <List <T_StockInfo> >(List);
UserModel user = JSONHelper.JsonToObject <UserModel>(UserJson);
T_Material_Batch_DB _db = new T_Material_Batch_DB();
if (!_db.PostZhMove(user, modelList, Order, Type, ref strMsg))
{
messageModel.HeaderStatus = "E";
messageModel.Message = strMsg;
return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <string> >(messageModel));
}
else
{
messageModel.HeaderStatus = "S";
messageModel.Message = "操作成功！";
return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <string> >(messageModel));
}
}
catch (Exception ex)
{
messageModel.HeaderStatus = "E";
messageModel.Message = ex.Message;
return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <string> >(messageModel));
}
}
public bool SubmitMesStatus(string returnJson, ref string errMsg)
{
BILBasic.Interface.T_Interface_Func TIF = new BILBasic.Interface.T_Interface_Func();
string result = TIF.PostModelListToInterface(returnJson);
BaseMessage_Model <WOReturnModel> model = new BaseMessage_Model <WOReturnModel>();
model = JsonConvert.DeserializeObject <BaseMessage_Model <WOReturnModel> >(result);
if (model.HeaderStatus == "E" && !string.IsNullOrEmpty(model.Message))
{
errMsg = model.Message;
return(false);
}
return(true);
}
public bool PostCheckToTrans(List <T_TransportSupDetailInfo> modelList, ref string strError)
{
try
{
BaseMessage_Model <List <T_TransportSupDetailInfo> > model = new BaseMessage_Model <List <T_TransportSupDetailInfo> >();
bool bSucc = false;
string strUserNo = string.Empty;
string strPostUser = string.Empty;
string StrongHoldCode = string.Empty;
if (modelList[0].ErpVoucherNo.Contains("HH2"))
{
modelList.ForEach(t => t.gtype = "C");
}
else
{
modelList.ForEach(t => t.gtype = "A");
}
StrongHoldCode = modelList[0].ErpVoucherNo.Substring(0, 3);
modelList.ForEach(t => t.VoucherType = 9992);
modelList.ForEach(t => t.StrongHoldCode = StrongHoldCode);
T_Interface_Func tfunc = new T_Interface_Func();
string ERPJson = BILBasic.JSONUtil.JSONHelper.ObjectToJson <List <T_TransportSupDetailInfo> >(modelList);
string interfaceJson = tfunc.PostModelListToInterface(ERPJson);
model = BILBasic.JSONUtil.JSONHelper.JsonToObject <BaseMessage_Model <List <T_TransportSupDetailInfo> > >(interfaceJson);
LogNet.LogInfo("ERPJsonAfter:" + BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <List <T_TransportSupDetailInfo> > >(model));
//过账失败直接返回
if (model.HeaderStatus == "E" && !string.IsNullOrEmpty(model.Message))
{
strError = "回传T100费用失败！" + model.Message;
bSucc = false;
}
else if (model.HeaderStatus == "S" && !string.IsNullOrEmpty(model.MaterialDoc)) //过账成功，并且生成了凭证要记录数据库
{
strError = "回传T100费用成功！凭证号：" + model.MaterialDoc;
bSucc = true;
}
return(bSucc);
}
catch (Exception ex)
{
strError = ex.Message;
return(false);
}
}
