/// <summary>
/// Thay Doi Pallete Cua Thung - M200
/// </summary>
/// <param name="boxes"></param>
/// <returns></returns>
public string ChangePalleteByBoxNo(List <string> boxes)
{
try
{
string palleteNo = string.Empty;
string palleteTypeNo = string.Empty;
int stBoxInfo;
foreach (string box in boxes)
{
if (!box.StartsWith("V"))
{
continue;
}
//01-Kiem tra item cua box duoc scan co phai ma hang can thay doi pallete hay khong.
DataTable dtWHPlan = uow.App200Repo.GetChangePalleteInfoByBoxNo(box);
if (dtWHPlan.Rows.Count == 0)
{
return(AppCommon.ShowOkMsg(1));
}
//Kiem tra box duoc scan co trong td_box_info khong.
DataTable dtBoxInfo = uow.App200Repo.GetBoxInfoByBoxNo(box);
if (dtBoxInfo.Rows.Count == 0)
{
return(AppCommon.ShowErrorMsg(8));
}
stBoxInfo = Convert.ToInt32(dtBoxInfo.Rows[0]["status"]);
if (stBoxInfo >= 3)
{
return(AppCommon.ShowErrorMsg(9));
}
palleteNo = dtWHPlan.Rows[0]["PALLETE_NO"] == null ? "" : dtWHPlan.Rows[0]["PALLETE_NO"].ToString().Trim();
if (string.IsNullOrEmpty(palleteNo))
{
return(AppCommon.ShowErrorMsg(2));
}
//Lay thong tin cua pallete
DataTable dtPallete = uow.App200Repo.GetPalleteInfoByPalleteNo(palleteNo);
if (dtPallete.Rows.Count == 0)
{
return(AppCommon.ShowErrorMsg(4, null, palleteNo));
}
palleteTypeNo = dtPallete.Rows[0]["PARENTPALLETE_NO"] == null ? "" : dtPallete.Rows[0]["PARENTPALLETE_NO"].ToString().Trim();
if (string.IsNullOrEmpty(palleteTypeNo))
{
return(AppCommon.ShowErrorMsg(6, null, palleteNo));
}
//Neu pallete trong box_info = pallete duoc scan => Box da duoc doi pallete.
string palleteTemp = dtBoxInfo.Rows[0]["PALLETE_NO"] == null ? "" : dtBoxInfo.Rows[0]["PALLETE_NO"].ToString().Trim();
if (string.IsNullOrEmpty(palleteTemp))
{
return(AppCommon.ShowErrorMsg(2, null, box));
}
if (palleteTemp.Equals(palleteNo))
{
return(AppCommon.ShowOkMsg(5, null, palleteNo));
}
if (uow.App200Repo.UpdatePalleteNoByBoxNo(box, palleteTypeNo, palleteNo) <= 0)
{
return(AppCommon.ShowErrorMsg(7, null, box));
}
uow.Commit();
string symSeq = (dtPallete.Rows[0]["SEQ_NO"].ToString().Trim() + " - " + dtPallete.Rows[0]["SYMBOL"].ToString().Trim()).PadRight(20);
//TcpConnection.DataToSend = AppCommon.ShowOkMsg(999, null, symSeq + palleteNo);
return(symSeq + palleteNo);
}
return(AppCommon.ShowErrorMsg(999, null, null, "No Data"));
}
catch (Exception ex)
{
using (StreamWriter sw = File.AppendText(Properties.Settings.Default.PATH_EXECUTE + "\\Log.txt"))
{
BcrServer_Helper.WriteLog.Instance.Write(ex.Message, "", sw);
}
uow.Rollback();
return(AppCommon.ShowErrorMsg(777, " "));
}
}
/// <summary>
/// Dua pallete len Container - M204
/// </summary>
/// <param name="location"></param>
/// <param name="userId"></param>
/// <param name="data"></param>
/// <returns></returns>
public string LoadPalleteToContainer(string location, string userId, List <string> data)
{
try
{
bool bret = false;
int ret = 0;
//Checking
string place = data[0].ToString().Substring(3).Trim();
string containerNo = data[1].ToString().Trim();
//string shippingSeq = data[2].ToString().Trim
string shippingSeq = string.Empty;
string containerDate = data[4].ToString().Trim();
string pallete = data[5].ToString().Trim();
//Kiem tra pallete da duoc scan ship hay chua
bret = uow.App200Repo.IsPalleteExists(pallete);
if (bret == false)
{
return(AppCommon.ShowErrorMsg(23));
}
bret = uow.App200Repo.IsPalleteCanExport(pallete);
if (!bret)
{
return(AppCommon.ShowErrorMsg(22));
}
if (containerNo.Length < 11)
{
return(AppCommon.ShowErrorMsg(19));
}
DataTable dt = uow.App200Repo.GetBoxInfoByContainerNoAndDate(containerNo, containerDate);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["container_lock_sign"].ToString().Trim() == "*")
{
return(AppCommon.ShowErrorMsg(26));
}
}
if (location.Equals("OR1"))
{
if (!place.ToUpper().Equals("NAGOYA"))
{
return(AppCommon.ShowErrorMsg(18));
}
shippingSeq = data[2].ToString().Trim();
}
if (location.Equals("OS1"))
{
if (!place.ToUpper().Equals("NAGOYA") && !place.ToUpper().Equals("YOKOHAMA"))
{
return(AppCommon.ShowErrorMsg(18));
}
string symbol = uow.App200Repo.GetSymbolOfPalleteNo(pallete);
if (symbol.Substring(0, 3).Equals("PAA"))
{
if (!place.ToUpper().Equals("YOKOHAMA"))
{
return(AppCommon.ShowErrorMsg(18));
}
}
else
{
if (!place.ToUpper().Equals("NAGOYA"))
{
return(AppCommon.ShowErrorMsg(18));
}
}
shippingSeq = data[3].ToString().Trim();
}
ret = uow.App200Repo.UpdateContainerByPallete(pallete, containerNo, shippingSeq, containerDate, location, userId, DateTime.Now.ToString("HHmmss"));
if (ret <= 0)
{
uow.Rollback();
}
uow.Commit();
//If check ok and update the data no problem.
return(AppCommon.ShowOkMsg(0));
}
catch (Exception ex)
{
using (StreamWriter sw = File.AppendText(Properties.Settings.Default.PATH_EXECUTE + "\\Log.txt"))
{
BcrServer_Helper.WriteLog.Instance.Write(ex.Message, "", sw);
}
uow.Rollback();
return(AppCommon.ShowErrorMsg(777, " "));
}
}