/// <summary>
/// ���캯��
/// </summary>
public SCommBB()
{
this.selfConn = true;
this.connection = new SqlConnection(HS.Config.SqlDataObject.GetSqlConnectionString);
this.connection.Open();
this.commDB = new SCommDB(this.connection);
}
/// <summary>
/// ���캯��
/// </summary>
/// <param name="connection">��������</param>
public SCommBB(SqlConnection connection)
{
this.connection = connection;
this.commDB = new SCommDB(connection);
}
protected virtual void Dispose(bool disposing)
{
if (!disposing)
return;
if (this.selfConn)
{
this.connection.Close();
this.connection.Dispose();
this.connection = null;
}
if (this.commDB != null)
{
this.commDB.Dispose();
this.commDB = null;
}
}
/// <summary>
/// 更改物料箱锁定状态
/// </summary>
/// <param name="strWareLocatorNo">库位</param>
/// <param name="strFinanceBillNo">采购合同号</param>
/// <param name="strMaterialNo">物料号</param>
/// <param name="num">数量</param>
public void UpdateWareLocator(string strWareLocatorNo, string strFinanceBillNo, string strMaterialNo, float num)
{
SCommDB commBB = new SCommDB();
try
{
DataTable dtStock = new DataTable();
string strWhere = "", strSql = "";
//查询条件
strWhere = "isOutStocking=0 and wareLocatorNo='" + strWareLocatorNo + "' and materialNo='" + strMaterialNo + "' and num>0";
if (strFinanceBillNo != "")
{
strWhere += " and financeBillNo='" + strFinanceBillNo + "'";
}
//查询库存
dtStock = this.GetVList(strWhere).Tables[0];
foreach (DataRow row in dtStock.Rows)
{
int stockId = 0;
float stockNum = 0;
string strBoxNo = "";
stockId = Convert.ToInt32(row["id"]);
stockNum = Convert.ToSingle(row["num"]);//库存数量
strBoxNo = row["boxNo"].ToString();
//更改库存锁定状态
strSql = "update dbo.UStock set isOutStocking=1 where id=" + stockId.ToString();
SqlHelper.ExecuteNonQuery(this.connection, this.transaction, CommandType.Text, strSql.ToString());
//更改原箱库存锁定状态
strSql = "update dbo.BArrangeBillBox set isOutStocking=1 where boxNo='" + strBoxNo + "'";
SqlHelper.ExecuteNonQuery(this.connection, this.transaction, CommandType.Text, strSql.ToString());
if (stockNum >= num)
{
break;
}
else
{
num = num - stockNum;
}
}
}
finally
{
commBB.Dispose();
}
}
