private void GetPinErpvoucherNo(ref List <T_OutStockInfo> outNewStockList, List <T_OutStockInfo> outStockList)
{
int bSucc = 0;
T_Box_DB _tdb = new T_Box_DB();
List <T_OutStockInfo> outStockListAdd = new List <T_OutStockInfo>();
List <T_BoxingInfo> lstFserialNo = _tdb.GetFserialNoByErpvoucherNo(outStockList);
//有父级序列号说明是拼箱，需要再次查找订单
if (lstFserialNo != null && lstFserialNo.Count > 0)
{
List <T_OutStockInfo> lstNewOutStock = _tdb.GetErpvoucherNoByFSerialNo(lstFserialNo);
foreach (var item in lstNewOutStock)
{
var lst = outStockList.FindAll(t => t.ErpVoucherNo == item.ErpVoucherNo);
if (lst == null || lst.Count == 0)
{
T_OutStockInfo outStock = new T_OutStockInfo();
outStock.ErpVoucherNo = item.ErpVoucherNo;
outNewStockList.Add(outStock);
bSucc += 1;
}
}
if (bSucc > 0)
{
outStockList.AddRange(outNewStockList);
GetPinErpvoucherNo(ref outNewStockList, outStockList);
}
}
}
//public JsonResult printBox(String ErpVoucherno)
//{
// T_OutStockDetail_Func func = new T_OutStockDetail_Func();
// string strError = "";
// List<T_PalletDetailInfo> palletModelList = new List<T_PalletDetailInfo>();
// bool isSuccess = func.CreatePalletByTaskTrans(ErpVoucherno, currentUser, ref palletModelList, ref strError);
// return Json(new { state = isSuccess, obj = strError }, JsonRequestBehavior.AllowGet);
//}
public JsonResult CheckPrint(String ErpVoucherno)
{
T_OutStock_Func func = new T_OutStock_Func();
T_OutStockInfo model = new T_OutStockInfo();
string strError = "";
bool isSuccess = func.GetOutStockDetailForPrint(ErpVoucherno, ref model, ref strError);
if (isSuccess)
{
string del = "";
var FYlist = from cust in model.lstDetail
where cust.StrongHoldCode == "FY2"
select cust;
var HMlist = from cust in model.lstDetail
where cust.StrongHoldCode == "HM1"
select cust;
if (FYlist.Count() == 0)
{
del += "F";
}
if (HMlist.Count() == 0)
{
del += "H";
}
return(Json(new { state = isSuccess, obj = strError, delobj = del }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { state = isSuccess, obj = strError }, JsonRequestBehavior.AllowGet));
}
}
public List <T_OutStockInfo> GetErpvoucherNoByFSerialNo(List <T_BoxingInfo> modelListFserialNo)
{
try
{
List <T_OutStockInfo> modelList = new List <T_OutStockInfo>();
string strFserialno = string.Empty;
foreach (var item in modelListFserialNo)
{
strFserialno += "\'" + item.FserialNo + "\'" + ",";
}
strFserialno = strFserialno.TrimEnd(',');
string strsql = "SELECT ISNULL(erpvoucherno,'') erpvoucherno from t_Boxing where fserialno IN(" + strFserialno + ") GROUP BY erpvoucherno";
using (IDataReader dr = dbFactory.ExecuteReader(System.Data.CommandType.Text, strsql))
{
while (dr.Read())
{
T_OutStockInfo boxmodel = new T_OutStockInfo();
boxmodel.ErpVoucherNo = dbFactory.ToModelValue(dr, "erpvoucherno").ToDBString();
modelList.Add(boxmodel);
}
}
return(modelList);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
// GET: Review
public ActionResult Review(string strCarNo)
{
T_OutStockInfo t_OutStockInfo = new T_OutStockInfo();
T_OutStock_Func func = new T_OutStock_Func();
string strError = "";
func.GetModelListByCar(strCarNo, ref t_OutStockInfo, ref strError);
ViewData["t_OutStockInfo"] = t_OutStockInfo;
ViewData["strError"] = strError;
return(View());
}
public bool CloseQualityDetailVoucherNo(int ID, UserModel user, ref string strError)
{
try
{
bool bSucc = false;
if (ID == 0)
{
strError = "客户端传入关闭ID为0！";
return(false);
}
T_QualityDetailInfo model = new T_QualityDetailInfo();
model.ID = ID;
bSucc = base.GetModelByID(ref model, ref strError);
if (bSucc == false)
{
return(false);
}
List <T_OutStockInfo> modelpost = new List <T_OutStockInfo>();
T_OutStockInfo TOutStockInfo = new T_OutStockInfo();
TOutStockInfo.VoucherType = 50;
TOutStockInfo.ErpVoucherNo = model.ErpVoucherNo;
TOutStockInfo.CompanyCode = model.StrongHoldCode;
TOutStockInfo.StrongHoldCode = model.StrongHoldCode;
TOutStockInfo.ERPVoucherType = model.ErpVoucherNo.Substring(4, 2);
modelpost.Add(TOutStockInfo);
bSucc = PostCloseOutStockVoucherNo(modelpost, ref strError);
if (bSucc == false)
{
return(false);
}
string strError1 = string.Empty;
//关闭WMS单据状态
bSucc = base.DeleteModelByModelSql(user, model, ref strError1);
//bSucc = base.DeleteModelByID(user, model.ID, ref strError1);
if (bSucc == false)
{
strError = strError + "\r\n" + strError1;
}
else
{
strError = strError + "\r\n" + "WMS单据删除成功！";
}
return(bSucc);
}
catch (Exception ex)
{
strError = ex.Message;
return(false);
}
}
private List <T_OutStockInfo> CreateNewOutStock(List <T_OutStockInfo> modelList)
{
List <T_OutStockInfo> lstModel = new List <T_OutStockInfo>();
foreach (var item in modelList)
{
T_OutStockInfo model = new T_OutStockInfo();
model.ErpVoucherNo = item.ErpVoucherNo;
lstModel.Add(model);
}
return(lstModel);
}
private void button12_Click(object sender, EventArgs e)
{
UserModel user = new UserModel();
user.UserNo = "admin";
user.UserName = "******";
string strError = string.Empty;
T_OutStockDetail_Func tfunc = new T_OutStockDetail_Func();
T_OutStockInfo model = new T_OutStockInfo();
tfunc.CreateOutStockByEmsLabel("7f21b00f-f24f-4d95-bed4-eca1bc45d2ff", "FY2-HH2-1908260002", 1, 1.444M, user, ref model, ref strError);
}
public bool CloseInStockVoucherNo(int ID, UserModel user, ref string strError)
{
try
{
bool bSucc = false;
if (ID == 0)
{
strError = "客户端传入关闭ID为0！";
return(false);
}
T_InStockInfo model = new T_InStockInfo();
model.ID = ID;
bSucc = base.GetModelByID(ref model, ref strError);
if (bSucc == false)
{
return(false);
}
if (model.Status != 1)
{
strError = "单据已经开始操作不能关闭！";
return(false);
}
List <T_OutStockInfo> modelpost = new List <T_OutStockInfo>();
T_OutStockInfo TOutStockInfo = new T_OutStockInfo();
TOutStockInfo.VoucherType = 50;
TOutStockInfo.ErpVoucherNo = model.ErpVoucherNo;
TOutStockInfo.CompanyCode = model.StrongHoldCode;
TOutStockInfo.StrongHoldCode = model.StrongHoldCode;
TOutStockInfo.ERPVoucherType = model.ERPVoucherType;
modelpost.Add(TOutStockInfo);
bSucc = PostCloseOutStockVoucherNo(modelpost, ref strError);
if (bSucc == false)
{
return(false);
}
string strError1 = string.Empty;
model.Status = 5;//5是关闭状态
//关闭WMS单据状态
bSucc = base.UpadteModelByModelSql(user, model, ref strError1);
if (bSucc == false)
{
strError = strError + "\r\n" + strError1;
}
else
{
strError = strError + "\r\n" + "WMS单据关闭成功！";
}
return(bSucc);
}
catch (Exception ex)
{
strError = ex.Message;
return(false);
}
}
public bool UpdateT_OutStockStatus(UserInfo user, ref T_OutStockInfo t_outstock, ref string strError)
{
T_OutStock_Func tfunc = new T_OutStock_Func();
return(tfunc.UpadteModelByModelSql(user, t_outstock, ref strError));
}
public bool GetT_OutStockListByPage(ref List <T_OutStockInfo> modelList, UserInfo user, T_OutStockInfo t_outstock, ref DividPage page, ref string strError)
{
T_OutStock_Func tfunc = new T_OutStock_Func();
return(tfunc.GetModelListByPage(ref modelList, user, t_outstock, ref page, ref strError));
}
public bool GetT_OutStockByID(ref T_OutStockInfo model, ref string strError)
{
T_OutStock_Func tfunc = new T_OutStock_Func();
return(tfunc.GetModelByID(ref model, ref strError));
}
public bool DeleteT_OutStockByModel(UserInfo user, T_OutStockInfo model, ref string strError)
{
T_OutStock_Func tfunc = new T_OutStock_Func();
return(tfunc.DeleteModelByModel(user, model, ref strError));
}
public bool SaveT_OutStock(UserInfo user, ref T_OutStockInfo t_outstock, ref string strError)
{
T_OutStock_Func tfunc = new T_OutStock_Func();
return(tfunc.SaveModelBySqlToDB(user, ref t_outstock, ref strError));
}
/// <summary>
/// 生成物流箱码
/// </summary>
/// <param name="user"></param>
/// <param name="lstErpVoucherNo"></param>
/// <param name="HeadName"></param>
/// <param name="strError"></param>
/// <returns></returns>
public bool CreatePrintBoxInfo(UserModel user, List <string> lstID, string HeadName, ref string strError)
{
try
{
List <T_BoxInfo> lstBox = new List <T_BoxInfo>();//存放需要提交的数据
List <T_BoxInfo> CreateLstBox = new List <T_BoxInfo>();
T_Box_DB _tdb = new T_Box_DB();
string strErpNote = string.Empty;
string strCustomerName = string.Empty;
string strErpNoteCat = string.Empty;
string strErpVoucherNoCat = string.Empty;
int iDelNo = 0;
bool bSucc = true;
List <T_OutStockInfo> outNewStockList = new List <T_OutStockInfo>();
if (lstID == null || lstID.Count == 0)
{
strError = "提交的生成箱子数据为空！";
return(false);
}
string strFilter = string.Empty;//"erpvoucherno = '" + ErpVoucherNo + "'";
T_OutStock_Func tfunc = new T_OutStock_Func();
List <T_OutStockInfo> outStockList = new List <T_OutStockInfo>();
foreach (var item in lstID)
{
T_OutStockInfo model = new T_OutStockInfo();
strFilter = "id = '" + item + "'";
tfunc.GetModelByFilter(ref model, strFilter, ref strError);
outStockList.Add(model);
}
if (outStockList == null || outStockList.Count == 0)
{
strError = "未能获取订单数据";
return(false);
}
GetPinErpvoucherNo(ref outNewStockList, CreateNewOutStock(outStockList));
if (outNewStockList != null && outNewStockList.Count > 0)
{
foreach (var item in outNewStockList)
{
T_OutStockInfo model1 = new T_OutStockInfo();
strFilter = "erpvoucherno = '" + item.ErpVoucherNo + "'";
tfunc.GetModelByFilter(ref model1, strFilter, ref strError);
outStockList.Add(model1);
}
}
if (CheckVoucherTypeIsSame(outStockList, ref strError) == false)
{
return(false);
}
foreach (var item in outStockList)
{
if (item.Status == 1)
{
strError += "订单号：" + item.ErpVoucherNo + "处于新建状态，不能生成物流标签！" + "\r\n";
bSucc = false;
}
}
if (bSucc == false)
{
return(false);
}
T_OutTaskDetails_DB tdb = new T_OutTaskDetails_DB();
List <T_OutStockTaskDetailsInfo> modelListTaskDetail = new List <T_OutStockTaskDetailsInfo>();
foreach (var item in outStockList)
{
if (tdb.GetOutTaskDetailByErpVoucherNo(item.ErpVoucherNo, ref modelListTaskDetail, ref strError) == false)
{
return(false);
}
if (modelListTaskDetail.Where(t => t.UnReviewQty > 0).Count() > 0)
{
strError = "订单：" + item.ErpVoucherNo + "没有全部复核完成，不能生成物流标签！";
bSucc = false;
break;
}
}
if (bSucc == false)
{
return(false);
}
T_Box_DB boxdb = new T_Box_DB();
foreach (var item in outStockList)
{
if (boxdb.GetErpVoucherNoIsPrint(item.ErpVoucherNo, ref strError) == false)
{
bSucc = false;
break;
}
}
if (bSucc == false)
{
return(false);
}
//其他出库单，需要判断客户是否相同
if (outStockList[0].VoucherType == 24)
{
if (CheckCustomerIsSame(outStockList, ref strError) == false)
{
return(false);
}
strCustomerName = outStockList[0].CustomerName;
}
else ///调拨出库单，验证调入仓库是否相同
{
T_OutStockDetail_Func tfuncd = new T_OutStockDetail_Func();
List <T_OutStockDetailInfo> lstOutStockDetail = new List <T_OutStockDetailInfo>();
List <T_OutStockDetailInfo> lstOutStockDetailSum = new List <T_OutStockDetailInfo>();
foreach (var item in lstID)
{
strFilter = "headerid = '" + item + "'";
tfuncd.GetModelListByFilter(ref lstOutStockDetail, ref strError, "", strFilter, "*");
lstOutStockDetailSum.AddRange(lstOutStockDetail);
}
if (CheckWarehouseIsSame(lstOutStockDetailSum, ref strError) == false)
{
return(false);
}
strCustomerName = lstOutStockDetailSum[0].ToErpWarehouseName;
}
foreach (var item in outStockList)
{
CreateLstBox.AddRange(GetNeBox(_tdb.GetPrintBoxInfo(item.ErpVoucherNo), item.ErpVoucherNo, strCustomerName, item.ERPNote, HeadName));
}
if (CreateLstBox == null || CreateLstBox.Count == 0)
{
strError = "可以生成箱子的数据为空！";
return(false);
}
List <T_BoxInfo> lstNewCreateBox = ModelListGroupBy(CreateLstBox);
List <T_BoxInfo> lstFserialNo = new List <T_BoxInfo>();
string strFserialNoCat = string.Empty;
foreach (var item in lstNewCreateBox)
{
lstFserialNo = _tdb.GetSerialNoByFserialNo(item.SerialNo);
if (lstFserialNo != null && lstFserialNo.Count > 0)
{
foreach (var item1 in lstFserialNo)
{
strFserialNoCat += item1.SerialNo + ",";
}
item.SerialNo = strFserialNoCat.TrimEnd(',');
}
}
foreach (var item in lstNewCreateBox)
{
iDelNo += 1;
item.DelNo = iDelNo.ToString().PadLeft(4, '0');
//item.Remark = strErpNoteCat;
//item.ErpVoucherNo = strErpVoucherNoCat;
}
//lstNewCreateBox.OrderBy(t => t.IsAmount);
return(_tdb.SaveBoxByModelList(user, lstNewCreateBox.OrderBy(t => t.IsAmount).ToList(), ref strError));
}
catch (Exception ex)
{
strError = ex.Message;
return(false);
}
}
