/// <summary>
/// 查询所有未完成出库信息
/// </summary>
/// <returns>Dataset类型</returns>
public DataSet getOutsWhereFailToOut()
{
string sqltext = "select Outout.outID,Goods.goodsName,Goodstype.goodsTypeName,Position.positionNum,Outout.outAmount,Inin.date as indate,Outout.date as outdate,Staff.staffName from Outout,Position,Goods,Goodstype,Batch,inin,Sysuser,Staff where Outout.positionNum=Position.positionNum and Outout.goodsNum=Goods.goodsNum and Goods.goodsTypeNum=Goodstype.goodsTypeNum and Outout.batchNum=Batch.batchNum and Inin.goodsNum=Goods.goodsNum and Outout.userId=Sysuser.userId and Sysuser.staffNum=Staff.staffNum and (Batch.condition='准备' or Batch.condition='进行中')";
SqlDataAdapter sdr = new SqlDataAdapter(sqltext, DBTools.DBConn());
DataSet ds = new DataSet();
sdr.Fill(ds);
DBTools.DBClose();
return(ds);
}