/// <summary>
/// 展示数据
/// </summary>
/// <param name="id">记录Id</param>
private void ShowInfo(int id)
{
BTallyBillBB tallyBillBB = new BTallyBillBB();
vBTallyBillData model = new vBTallyBillData();
BTallyBillDetailBB detailBB=new BTallyBillDetailBB();
try
{
//获取理货单实例
model = tallyBillBB.GetVModel(id);
this.palletNo.Text = model.palletNo;
this.wareLocatorNm.Text = model.wareLocatorNm;
this.wareNm.Text = model.wareNm;
this.isInStock.Text = model.isInStock ? "已入库" : "未入库";
this.instantState.Text = model.instantState == "01" ? "理货中" : model.instantState == "02" ? "理货已完成" : "已入库";
DataSet ds = detailBB.GetVList(" mainid=" + id);
this.grid.DataSource = ds;
this.grid.DataBind();
}
finally
{
tallyBillBB.Dispose();
}
}
public bool CheckTallyBox(int tallyBillId, int region, string strBoxNo, out string strOldPalletNo, out string strMsg)
{
BTallyBillDetailBB tallyBillDetailBB = new BTallyBillDetailBB();
BArrangeBillBoxBB arrangeBillBox = new BArrangeBillBoxBB();
try
{
strMsg = "";
strOldPalletNo = "";
string strPreMaterialNo = "", strCurrMaterialNo = "";
bool isExistsBox = false, isBoxAllowTally = false;
DataTable dt = new DataTable();
//判断箱号是否存在
isExistsBox = this.IsExistsBox(strBoxNo);
if (isExistsBox == false)
{
strMsg = "当前箱号不存在！";
return false;
}
//判断当前箱子是否已经理货
isBoxAllowTally = this.IsBoxAllowTally(strBoxNo);
if (!isBoxAllowTally)
{
strMsg = "当前箱子已经理货！";
return false;
}
//根据箱号，查找所在的托盘条码号
strOldPalletNo = this.GetPalletNoByBoxNo(strBoxNo);
if (strOldPalletNo == "")
{
strMsg = "当前箱子不属于任何托盘！";
return false;
}
//判断同一区域箱数是否超过5个
dt = tallyBillDetailBB.GetVList("mainId='" + tallyBillId.ToString() + "' and region='" + region.ToString() + "'").Tables[0];
if (dt.Rows.Count >= 5)
{
strMsg = "";
return false;
}
//判断同一托内区域，物料是否相同
//根据箱号，查找物料是否符合排托规范
//
return true;
}
finally
{
tallyBillDetailBB.Dispose();
arrangeBillBox.Dispose();
}
}
public DataTable GetTallyBillDetail(string strPalletNo)
{
BTallyBillDetailBB tallyBillDetailBB = new BTallyBillDetailBB();
try
{
DataTable dt = new DataTable();
dt = tallyBillDetailBB.GetVList("palletNo='" + strPalletNo + "' and isInStock=0").Tables[0];
return dt;
}
finally
{
tallyBillDetailBB.Dispose();
}
}
public bool IsBoxAllowTally(string strBoxNo)
{
BTallyBillDetailBB tallyBillDetailBB = new BTallyBillDetailBB();
try
{
DataTable dt = new DataTable();
dt = tallyBillDetailBB.GetList("boxNo='" + strBoxNo + "'").Tables[0];
return dt.Rows.Count > 0 ? false : true;
}
finally
{
tallyBillDetailBB.Dispose();
}
}
public int GetBoxSuggestRegin_Tally(int tallyBillId, string strMaterialNo)
{
SCommBB commBB = new SCommBB();
BTallyBillDetailBB tallyBillDetailBB = new BTallyBillDetailBB();
try
{
DataTable dtTallyBillDetail = new DataTable();
DataRow[] myDataRowArray = null;
StringBuilder strSql = new StringBuilder();
int region = 0;
//汇总托盘区域内物料箱数
strSql.Append("select region,materialNo,count(1) as boxNum ");
strSql.Append("from dbo.vBTallyBillDetail ");
strSql.Append("where mainId=" + tallyBillId.ToString() + " ");
strSql.Append("group by region,materialNo ");
strSql.Append("order by region");
dtTallyBillDetail = commBB.Query(strSql.ToString()).Tables[0];
if (dtTallyBillDetail.Rows.Count > 0)//当前理货单已理货
{
//获取当前物料的所有排托信息
myDataRowArray = dtTallyBillDetail.Select("materialNo='" + strMaterialNo + "'");
if (myDataRowArray.Length > 0)//当前物料已进行理货
{
//判断放置物料的最后一个区域箱数
if (Convert.ToInt32(myDataRowArray[myDataRowArray.Length - 1]["boxNum"]) < 5)
{
//未超出5箱，使用物料的最后一个区域
region = Convert.ToInt32(myDataRowArray[myDataRowArray.Length - 1]["region"]);
}
else//最后一个物料的区域已达到5箱
{
//查找放置此物料未满的区域
myDataRowArray = dtTallyBillDetail.Select("materialNo='" + strMaterialNo + "' and boxNum<5");
if (myDataRowArray.Length > 0)
{
region = Convert.ToInt32(myDataRowArray[0]["region"]);
}
else
{
//查找其他区域
for (int i = 1; i <= 8; i++)
{
myDataRowArray = dtTallyBillDetail.Select("region=" + i.ToString());
if (myDataRowArray.Length == 0)
{
region = i;
break;
}
}
}
}
}
else//当前物料未进行理货，取使用的最大区域加1
{
region = Convert.ToInt32(dtTallyBillDetail.Rows[dtTallyBillDetail.Rows.Count - 1]["region"]) + 1;
if (region > 8)//推荐区域超出8，逐个查找没有使用的区域
{
for (int i = 1; i <= 8; i++)
{
myDataRowArray = dtTallyBillDetail.Select("region=" + i.ToString());
if (myDataRowArray.Length == 0)
{
region = i;
break;
}
}
}
}
}
else//当前理货单还未理货
{
region = 1;
}
return region;
}
finally
{
commBB.Dispose();
tallyBillDetailBB.Dispose();
}
}